J
Jan
Hi,
I hope that someone can help me, I have read through heaps of other
questions and answers both from the Access side and also from the Excel
threads, but didn’t find a solution. My issue revolves around sending data
from Access to Excel. From my Access database I open an Excel template, pass
in the relevant data and then save as a new excel file. This code works fine
for all the users except 1 who uses Excel a lot and has recorded macros/code
in his Personal.xls. When this user runs the procedure from the database and
Excel is opened, the ‘Personal.xls’ is opened (as expected). Even though my
code points to a specific (named) Excel template to be opened, the data is
placed onto the Sheet in Personal.xls. How can I ensure that the data gets to
the correct Excel file (NOT personal.xls)?
Thanks in anticipation
I hope that someone can help me, I have read through heaps of other
questions and answers both from the Access side and also from the Excel
threads, but didn’t find a solution. My issue revolves around sending data
from Access to Excel. From my Access database I open an Excel template, pass
in the relevant data and then save as a new excel file. This code works fine
for all the users except 1 who uses Excel a lot and has recorded macros/code
in his Personal.xls. When this user runs the procedure from the database and
Excel is opened, the ‘Personal.xls’ is opened (as expected). Even though my
code points to a specific (named) Excel template to be opened, the data is
placed onto the Sheet in Personal.xls. How can I ensure that the data gets to
the correct Excel file (NOT personal.xls)?
Thanks in anticipation