Need to automate the creation of an Excel (2010) workbook , some would call it a *laboratory notebook*. We enter testing data, pictures, etc. into the workbook and then save a pdf for report. Individual test result input grids, routines, etc are .xlsx worksheets or workbooks. They already exist and are part of a controlled document system. I would like to have an Access form from which one could choose 5-10 of these individual tests (.xlsx) out of say a menu of ~100. A command button then copies the sheets from all selected workbooks into a new workbook, name it with a lab # and save to network drive at a single *work in progress* folder. Order of the sheets is not critical. While the database will be in mulituser environment, only 1 user would be doing this activity. The definition of the menu (individual tests) would be stored as an Access (2010) table of short descriptions in one column and a hyperlink (or text full path..whatever) in another. For me, the problem is populating the (hopefully single screen) menu form with all of the choices. New controlled document xlsx might be added/changed daily. Maybe automate the rebuilding of the form? Needs to work with mapped drive in Windows 7, Vista, and XP (other code i found on EE that uses a file browsing window falls on its face here).
I'm sure that i'm missing something, but this is my first posting. After this project, I have dozens of office automations i'd like to have done. Looking for a partner to both help specify the projects and code them.
26 freelancers are bidding on average $354 for this job
dearsir/madame i will do a small custom vb script from inside the access db macro editor to automate the creation of an axcel workbook and copy the desired data to the named fields in the excel workbook.