Automate Creation of Excel workbook from Access
$250-750 USD
Pagado a la entrega
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.
Nº del proyecto: #1154990
Sobre el proyecto
Adjudicado a:
25 freelancers están ofertando un promedio de $352 por este trabajo
Hi, I have more 10 years experience in MS Access and VBA, so I'm realy GURU in this. I can help you with this project right now. Best Regards, Alex
Hello, I am very experienced in laboratory data management (20+ years). See PM for more detail.
Hello, i can do this in a timely manner look to work with you At your disposal for any query. Regards softwarevamp
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 appl Más
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 spreads Más
I've been working with Access and VB for 15 years. I know how to deliver a professional solution.
Hello, So kindly give us an nice opportunity to work with you. Respectfully yours, Joseph