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.
Respected Sir,
Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail.
Please see attached sample application that how much user friendly application development capability I have. Looking forward to your prompt reply.
Kindest regards.
Farrukh Rehman.
I would like to be considered for this project. I am an honours graduate in Software Engineering and have over 10 years professional experience in Database design and development and am an expert in VBA and office applications. I have developed numerous tailored office applications to meet clients exact requirements.
I have developed a similar system to this for an international hospitality company.
The database will be delivered within 5 days and I will be available at any time (via Skype, email or telephone) for the subsequent month for any tweaking or technical support that may be desired.
I can provide a solution in which Access uses the contents of a specified folder to build an array in which to load the selection form.
Another option would be to have one table in which you would identify a spreadsheet and select criteria to attach to it i.e. key words, then a selection form could be divided by these keywords. The combining of sheets into another workbook is a piece of cake, as long as the original workbooks stay in a unique directory, all by themselves.