In Progress

Automate Creation of Excel workbook from Access

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.

Skills: Microsoft, Microsoft Access, Visual Basic

See more: automate excel creation access, workbook access, access excel creation, user tests, test data creation, me excel, looking excel projects, first lab, daily access, uses excel, microsoft excel test, microsoft excel 2010 test, microsoft access test, excel uses, xlsx, visual basic form excel, table creation, save excel, rebuilding, menu pdf, lab test, lab report, excel report, excel projects, excel automate

About the Employer:
( 1 review ) Indianapolis, United States

Project ID: #1154990

Awarded to:

svet63

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

$450 USD in 5 days
(44 Reviews)
6.1

26 freelancers are bidding on average $354 for this job

jhaynes75

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

$400 USD in 7 days
(29 Reviews)
6.1
bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$400 USD in 5 days
(27 Reviews)
5.6
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 in 4 days
(31 Reviews)
5.5
srinichal

I can deliver the automation script

$400 USD in 5 days
(27 Reviews)
5.3
dotnetsupercoder

Please check PM for details.

$300 USD in 3 days
(11 Reviews)
5.1
amnmttl

Hello..please chk pmb for bid details

$350 USD in 5 days
(24 Reviews)
5.0
KellogITSolution

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

$250 USD in 4 days
(30 Reviews)
4.8
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 More

$250 USD in 0 days
(17 Reviews)
4.5
guevanjr

Please consider my bid. Thanks

$250 USD in 4 days
(6 Reviews)
3.2
telemarketing555

Hi, please check your PM. Thank you.

$300 USD in 5 days
(8 Reviews)
3.5
finsoft03

Please check PM.

$250 USD in 2 days
(4 Reviews)
3.1
AccuPro

Kindly check PMB.

$250 USD in 2 days
(1 Review)
2.9
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 in 3 days
(1 Review)
0.2
ahmadserageldin

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.

$650 USD in 11 days
(0 Reviews)
0.0
JosephKetz

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

$350 USD in 30 days
(0 Reviews)
0.0
seunfreelance

please give me the job am ready to do it.thanks

$250 USD in 2 days
(0 Reviews)
0.0
jonesi

I'm a bright student who majors in Excel and Access VBA with some .net experience and the hardware to develop and test in XP, Vista and Win7.

$250 USD in 8 days
(0 Reviews)
0.0
alleycatuk

Hi, please see PM. Many thanks.

$300 USD in 5 days
(0 Reviews)
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 More

$350 USD in 14 days
(0 Reviews)
0.0
davidinscotland

Hi having read your requirements Please see PM and attachment thanks

$500 USD in 5 days
(0 Reviews)
0.0