VBA code Error after changed to windows 7, working fine in windows XP before

Hi,

Can anyone help me,

The code run perfectly in window XP but when I changed to windows 7 got runtime error

Workbooks.Open Filename:=IName does not work. the filepath have not changed. remained as before

Please Login or Register  to view this content.

I don't see any reason that code wouldn't work unless the filepath had changed.

I'd suggest opening one of the workbooks in question and running some code like:

Please Login or Register  to view this content.

and comparing this to what you have in your filepath sheet.

Hi,

I have verified many times include your technique, the filepath is 100% accurate. Is it due to excel 2013 issue? a lot of files unable to open after changed to excel 2013. I dont think windows 7 issue.


The protected view has been uncheck in trust center settings. It is really make me frustrated how come this thing happened?

Hi,

I don't think it comes from 2013 version but how in your new Windows files are displayed !
The workbook's name must be like in its title window once opened in Excel :
you have to enter it with its correct extension like .xlsb, .xlsm or .xlsx …

Regards !

Try doing something like:

Please Login or Register  to view this content.

and see if that works.

Are you running the code from within excel?

Maybe try creating this folder:
C:\Windows\SysWOW64\config\systemprofile\Desktop

if it does not already exist.

Hi,

The files is not stored at my desktop. The files stored in another desktop mapped on my network drive

Y:\eSST Daily Uptime\eSST Daily Uptime Apr 2014\ATM\ATM Availability - 20140401.xls



The original Desktop path is on D:\ATM & SST\eSST Daily Uptime\eSST Daily Uptime Apr 2014\ATM\ATM Availability - 20140401.xls

do i need to create C:\Windows\SysWOW64\config\systemprofile\Desktop in original desktop

Hi ,

If i record a macro the file path as follow,

Please Login or Register  to view this content.

does it due to excel 2013 protected view still working, even though has been uncheck?

Is there a folder:
C:\Windows\SysWOW64\config\systemprofile\Desktop
on your machine?
If there is not, try and create it.

Hi

is it excel file format issue?

FileFormat:=xlExcel8, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False