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
--
Jan
