xls file

[sqlwiz]

created an access 2003 app that writes data to cells of an excel file and works with ms office 2003.
Set openxls = CreateObject("Excel.Application")


set XLDoc = openxls.Workbooks.open("C:\Gage.xls");
When running it in a different PC with 2010, i get the file not found error. Even though, the xls is present.

[June7]

The code works for me using Windows 7 and Access 2010.

[Missinglinq]

...the xls is present...

Is it 'present' at "C:\" on the errant computer?

If it is at "C:\," on the errant PC, does the user have the needed permission to access C:\? On newer versions of Windows (say a version that might be hosting Access 2010) the C:drive is normally protected, I believe.

Linq ;0)>

[June7]

Good point Linq. I did have issue with saving the file at C:\ and had to put it into my user folder.

I need to get the permissions on this new Windows 7 pc set up so I login as 'Owner' or 'June' has full administrative rights. Just not sure how to do that. Something to do this weekend.

[Missinglinq]

...Something to do this weekend...

Well, it'll keep you off of the streets!

Have a great weekend!

Linq