Downgraded to Excel 2007

[MikeDBMan]

I had to be downgraded from Excel 2010 to Excel 2007. Now I am having problems that I had solved months ago. I issue this line of code and I get an error 1004 when trying to open a file on SharePoint:

Workbooks.Open Filename:="https://central.abcd.com/corp/acctg...iod/Project Management/201108 ETC - 2061.xlsx

I can still manually open this file within excel but not using VBA.
Using VBA, I now get an error 1004. The file does not open. Suggestions?

 

[xenou]

I guess you could try using the real file name with spaces instead of %20:

Workbooks.Open "https://blah blah blah.xlsx"

Rather than

Workbooks.Open "https://blah%20blah%20blah.xlsx"

Just a guess. Or you could test it by removing the spaces from the file on sharepoint (if you are able) and see if that helps.

ξ

 

[MikeDBMan]

That is not it. There is something else going on that I don't know about that is causing the problem. I actually get the same error message regardless of if I use %20 or a space. I think there is a security issue that happens automatically when I open a file manually but I am not emulating with VBA code.

 

[MikeDBMan]

Weirdest thing. I rebooted and now I can open any files. Again I think there is a security issue but whatever it is, the reboot satisfied. We'll see...