monirg
Well-known Member
- Joined
- Jan 11, 2005
- Messages
- 629
Hello;
1) Here’s another example of XL 2003 w/b code not working properly in XL 2010, but it appears specific enough in this case!
The w/b Open() event code had been copied a while back from an XL ref, and the w/b works perfectly in XL 2003.
(I’ve just opened and run the w/b in XL 2003 with no problem!)
2) When the XL 2003 w/b is opened in XL 2010, I get the error:
3) Top section of the code:
Your help would be greatly appreciated.
Regards.
1) Here’s another example of XL 2003 w/b code not working properly in XL 2010, but it appears specific enough in this case!
The w/b Open() event code had been copied a while back from an XL ref, and the w/b works perfectly in XL 2003.
(I’ve just opened and run the w/b in XL 2003 with no problem!)
2) When the XL 2003 w/b is opened in XL 2010, I get the error:
and the Open statement in the following code is highlighted.Run-time error ‘75’:
Path / File access error
3) Top section of the code:
Code:
Private Sub Workbook_Open()
Dim StartTime#, CurrentTime#
Const TrialPeriod# = 30
'set own obscure path and file-name
Const ObscurePath$ = "C:\"
Const ObscureFile$ = "TestFileLog.Log"
If Dir(ObscurePath & ObscureFile) = Empty Then
StartTime = Format(Now, "#0.#########0")
[B][SIZE=3]Open ObscurePath & ObscureFile For Output As #1[/SIZE][/B]
Regards.