Excel Template

[stucoo]

I have some users that use an Access database to export data to a excel template. They then want to perform some data manipulation so i have created a button linked to a macro within the excel template. The problem is that when they export the data an xls file is created from the template, but the macro will not work as it references the original template.

Any ideas or am i approaching this from the wrong direction.

 

[SkipVought]

Rather than EXPORT from Access, IMPORT from Excel.

Data > Import Externam Data...

You can QUERY your MS Access database. If your EXPORT was from a query, you can use essentoally the same SQL code.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

as it references the original template
Really ?
Even when using ActiveWorkbook instead of ThisWorkbook ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886