Excel/Access expertise needed - Miata Turbo Forum - Boost cars, acquire cats.

Welcome to Miataturbo.net   Members
 


Insert BS here A place to discuss anything you want

Reply
 
 
 
LinkBack Thread Tools Search this Thread
Old 03-03-2010, 01:02 PM   #1
Elite Member
Thread Starter
iTrader: (8)
 
Join Date: Jun 2009
Location: Albany, NY
Posts: 1,523
Total Cats: 4
Default Excel/Access expertise needed

Here's the deal. I'm gathering a group of ~30-50 parts and throwing them into a box. I am scanning each part into an excel spreadsheet and labeling each worksheet with a three-digit box number. The worksheets will only have one column, just part numbers. Easy so far.

I now need to create a separate .txt file (ms-dos txt formatting) containing just what's in each individual box, and the .txt file needs to be named 'box#-mm-dd-yy.txt', with today's date. The group of text files then needs to be emailed to a distribution list.

I want to automate the creation of these .txt files so that: 1. It's not such a repetitive process for processing 30+ boxes in a one hour timeframe and 2. a warehouse person, temp included, doesn't have to have file manipulation skills to get the process correct. If part of the automation process could email the files to the dist list, that would be even better.

I'd like to just be able to do it within excel, if possible. I do have access, as well, but would prefer to not use it if I don't need to.

Halp?
webby459 is offline   Reply With Quote
Old 03-03-2010, 01:38 PM   #2
Boost Czar
iTrader: (61)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 72,860
Total Cats: 1,788
Default

If I were doing this...I'd print labels for the boxes that matched the txt file name. So your box label would read: box1-03-03-2010

then i'd just open notepad.

scan the label first so the name of the box was the header, then scan all the parts. You'd just have to hit enter after each.

Then when you save the file, scan the box label again and hit save.


it's crude but it would work. Just save all the files into monthly folders.
Braineack is offline   Reply With Quote
Old 03-03-2010, 02:03 PM   #3
Elite Member
Thread Starter
iTrader: (8)
 
Join Date: Jun 2009
Location: Albany, NY
Posts: 1,523
Total Cats: 4
Default

+1 brainizzle. Can anyone tell by now that I like to over complicate things?

I think I'm going to just have the warehouse guy scan the parts and save the files manually as .txt files right in notepad. Aside, as a bonus, the scan gun has the option of issuing a carriage return after it scans an item, it's set like that and it works.

Then the guy will just send those .txt files to the distro list via email, easy. I can always import the text files into excel if I need to work on them separately, which I may not even need to do.

Thanks. You are King.
webby459 is offline   Reply With Quote
Old 03-03-2010, 02:08 PM   #4
Boost Czar
iTrader: (61)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 72,860
Total Cats: 1,788
Default

Someone like Urban Soot could easily write you a simple web based program that would make it automated...I'm not that skilled (or have the ambition).
Braineack is offline   Reply With Quote
 
 
Reply

Related Topics
Thread Thread Starter Forum Replies Last Post
My solution for Oiltemp and Oilpressure input into Megasuirt (MS3) Zaphod MEGAsquirt 41 01-24-2016 01:25 PM
Going back to stock. Need some 1.6 parts. Trent WTB 2 10-01-2015 01:15 PM
In need of base map for stock 1997 brandonbkd MEGAsquirt 0 09-29-2015 12:52 AM
WTB HPDE miata - Texas Voltwings Cars for sale/trade 0 09-27-2015 07:40 PM


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 06:32 AM.