I
ITperson
Hello
I have an access application (XP) that I run. Part of this app creates an
XL workbook and puts the results of a query into it, then formats it all (XL
XP).
I have a couple users that have Access 2007 on their machines and they
maintain the Program Files\Microsoft Office\Office 10 folder (XP). This has
both Access And Excel in it.
The problem is that when the end user runs my code from their Access XP, it
tries to write to Excel 2007 instead of XP. I get some error saying that it
is not a macro type of file.
Is there anything I can code in Access to tell it to use Excel XP to create
the workbook, put the info into it etc; instead of their default 2007?
Upgrading all users to 2007 is not an option, the application will only run
on Office XP
Thank you
Terry
I have an access application (XP) that I run. Part of this app creates an
XL workbook and puts the results of a query into it, then formats it all (XL
XP).
I have a couple users that have Access 2007 on their machines and they
maintain the Program Files\Microsoft Office\Office 10 folder (XP). This has
both Access And Excel in it.
The problem is that when the end user runs my code from their Access XP, it
tries to write to Excel 2007 instead of XP. I get some error saying that it
is not a macro type of file.
Is there anything I can code in Access to tell it to use Excel XP to create
the workbook, put the info into it etc; instead of their default 2007?
Upgrading all users to 2007 is not an option, the application will only run
on Office XP
Thank you
Terry