Hi,
I am trying to get cell values from multiple files to be put into a list. All the files are the same format. I have 7 cells from each workbook that needs to be put into this list. the files will continue to grow as they are work orders. I have already made the work order form with a date / time stamp submit button. the even go in the right file path.
Post the LIST workbook, post a sample or two of the "multiple files", and list the cells you want extracted and where they should go in the LIST workbook.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
1) Here is an improved SaveAndDate macro in your form:
This saves the file the same as before without changing the name of your current file (template) nor changing your current working directory, it saves to the correct path all the time.
Please Login or Register to view this content.
In the Auto Job List.xlsm this macro will detect all the filenames in your filepath and add them as FORMULAS to the sheet, this way it extracts the information without opening the files and if you ever open and edit those forms, this list will update itself via the formula. You can leave the forms in the filepath because the macro will only add each named file once to the list.
Please Login or Register to view this content.
this is working great. thank You
I moved everything to the server. I got the work order to save, but can not get this to pull info. it does not give an error either.
Please Login or Register to view this content.
Last edited by Jarrettm; 09-04-2014 at 02:35 PM. Reason: CODE WRONG
That's an entirely different topic, one I have zero answers for. Perhaps you can share a folder from your own local system for the others to save their Forms into, one which is local to you so your main formulas keep working.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
I fixed it. When copping a file path it does not copy the \. I added it to the file path in the macros. Works great. Thank you for your help.
Awesome. Glad to hear. As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks