By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,061 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Using Access to open, populate and save Excel template

P: 56
I have an Excel template that has to be populated with data each month. It has to be a this particular template because it has several functions embedded into it which are for a bespoke accounting system. This I'm not concerned about, all I'm worried about is getting data from Access, month on month, into a template, and having the template save to a drive.

Lots of the fiddly stuff like specifying drive locations, flexible filenames etc I'm ok with. Its the talking to Excel that I'm concerned with.

Basically, I will run an Access query each month. The result of this query will be a few records per 'supplier' and some financial data relevant for that supplier. I need a template opened for each supplier, and the financial data input into certain places on the template. This will then autosave.

How do I make Access talk to this template and how can I tell it where to put in the data?

Any help gratefully received!
Oct 10 '07 #1
Share this Question
Share on Google+
2 Replies


nico5038
Expert 2.5K+
P: 3,072
You can use automation to control the filling of the excel sheet.
Check as a start:
http://www.mvps.org/access/modules/mdl0006.htm

With having a template and performing a Filecopy command to get a fresh copy.

Getting the idea ?

Nic;o)
Oct 11 '07 #2

P: 56
You can use automation to control the filling of the excel sheet.
Check as a start:
http://www.mvps.org/access/modules/mdl0006.htm

With having a template and performing a Filecopy command to get a fresh copy.

Getting the idea ?

Nic;o)
Bookmarking and devouring! THANKS MATE!
Oct 12 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.