Hutchy
Registered User.
- Local time
- Today, 08:50
- Joined
- Jun 28, 2013
- Messages
- 42
Hey guys, I need some assistance, please.
I'm not that good with VBA, but I was reading some other threads re my problem, but I was a bit confused. they are old threads, I need someone to converse with.
I'm using Access 2007.
I have a few problems and I want them to be able to be done from switchboard:
1. Is there a way for me to export a particular report (after selecting it) to a closed excel template, that is formatted? It would open the excel template (that has a logo and column headings), export data to below the column headings, then save the file with a unique name?
2. Also, a way to import data from an excel file, after allowing the user to select file? Only data below the column headings mentioned above. Same data will be appended to existing table.
I'm not that good with VBA, but I was reading some other threads re my problem, but I was a bit confused. they are old threads, I need someone to converse with.
I'm using Access 2007.
I have a few problems and I want them to be able to be done from switchboard:
1. Is there a way for me to export a particular report (after selecting it) to a closed excel template, that is formatted? It would open the excel template (that has a logo and column headings), export data to below the column headings, then save the file with a unique name?
2. Also, a way to import data from an excel file, after allowing the user to select file? Only data below the column headings mentioned above. Same data will be appended to existing table.