Access 2007/XP - Excel 2007/XP

[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

 

[Alex Dybenko]

Hi,
you can try 2 options
- let it create workbook in excel 2007 and then save it in XP (xls) format
- try to get object reference to excel XP as
CreateObject("Excel.Application.10")


--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com