Migrating to Windows 7 - Open file for output unreliable

[mgs73]

Hi Froum

Hope someone here can help me out on this one! We are currently migrating our machines from XP/Office2003 to Win7/Office 2010. A problem I am having very frequently is this line of code is not working reliably any more:

Please Login or Register  to view this content.

The variables are declared and valid, the path and filename are valid. If the path is on a WinXP machine, the code will work 100% of the time. If the path is on a Win7 machine (even if the code itself is being run on XP) then it is very unrealiable, and often (but not always) gives a run-time error Bad Name or File Number. In debug mode, if I simply change the path to an XP machine it will work, confirming the file name and number are both valid.

As a workaround, in one spreadsheet I have set up a loop that keeps trying until eventually it opens. I keep count of how many times it tries - here are some sample values: 35,706 tries, 107,599 tries, 65,489 tries, 158,725 tries.

My only guess it that there is some kind of permissions issue, but then if that were the case I would expect it to never work. In any case, I have admin rights, and the problem also occurs when logged in as administrator.

Any thoughts?

[Leith Ross]

Hello mgs73,

Are these machine connected through a network or are they separate?

What types of files are you opening?

[mgs73]

Hi

The machines are on a network, both connected to the same switch.

The file created is a simple three-line bat file.

Michael

[Leith Ross]

Hello Micheal,

I have both XP/2003 and Win 7/2010. The VBA code is compatible as there were no changes between the versions fro this function. Given that the code runs successfully on both machine, the problem is your network.

Unfortunately, there are some many variables associated with networks and not being familiar with yours, I really don't have any advice for on troubleshooting this further.

Don't be discouraged. They are many other members on the forum with network experience. Perhaps some have had the same trouble as you and have a answer.

[mgs73]

Thanks for your time, but I can assure you it is not a network issue. Most times I have encountered this problem, the spreadsheet has been running on a Windows 7 machine, trying to write to the local hard drive.

In fact it was only this morning I disovered that the problem will also occur on XP when trying to write to a Win7 machine.

At least that confirms that Excel is not the issue. I'm guessing it is Windows related. Anyhow, I'm hoping someone has had this trouble before (and solved it of course!)