Automate Creation of Excel workbook from Access

Completado Publicado Aug 6, 2011 Pagado a la entrega
Completado 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.

Microsoft Microsoft Access Visual Basic

Nº del proyecto: #1154990

Sobre el proyecto

25 propuestas Proyecto remoto Activo Aug 12, 2011

Adjudicado a:

svet63

Access/Excel developer since 1997. Can do. Regards, Svet.

$450 USD en 5 días
(49 comentarios)
6.2

25 freelancers están ofertando un promedio de $352 por este trabajo

jhaynes75

Professional software developer with over 11 years experience. Please see PM.

$400 USD en 7 días
(30 comentarios)
6.0
srinichal

I can deliver the automation script

$400 USD en 5 días
(38 comentarios)
5.7
fedalal2

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

$400 USD en 4 días
(32 comentarios)
5.5
dotnetsupercoder

Please check PM for details.

$300 USD en 3 días
(15 comentarios)
5.3
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

$250 USD en 4 días
(35 comentarios)
4.9
amnmttl

Hello..please chk pmb for bid details

$350 USD en 5 días
(24 comentarios)
5.0
frehmanpk

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 Más

$250 USD en 0 días
(18 comentarios)
4.5
guevanjr

Please consider my bid. Thanks

$250 USD en 4 días
(6 comentarios)
3.2
AccuPro

Kindly check PMB.

$250 USD en 2 días
(2 comentarios)
3.1
finsoft03

Please check PM.

$250 USD en 2 días
(4 comentarios)
3.1
telemarketing555

Hi, please check your PM. Thank you.

$300 USD en 5 días
(8 comentarios)
3.5
erry

hi, let's do this project

$350 USD en 7 días
(0 comentarios)
0.0
mlDataSolutions

Hello, I am very experienced in laboratory data management (20+ years). See PM for more detail.

$750 USD en 5 días
(0 comentarios)
0.0
softwarevamp

Hello, i can do this in a timely manner look to work with you At your disposal for any query. Regards softwarevamp

$250 USD en 3 días
(1 comentario)
0.2
rapidDev2010

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

$250 USD en 5 días
(0 comentarios)
0.0
rdennis125

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

$350 USD en 14 días
(0 comentarios)
0.0
mp9jetta2

I've been working with Access and VB for 15 years. I know how to deliver a professional solution.

$350 USD en 5 días
(0 comentarios)
0.0
davidinscotland

Hi having read your requirements Please see PM and attachment thanks

$500 USD en 5 días
(0 comentarios)
0.0
JosephKetz

Hello, So kindly give us an nice opportunity to work with you. Respectfully yours, Joseph

$350 USD en 30 días
(0 comentarios)
0.0
alleycatuk

Hi, please see PM. Many thanks.

$300 USD en 5 días
(0 comentarios)
0.0