I
igodzin
I have an empty WB with VBA code in IT in Excel 2002:
Sub main()
Dim wb As Workbook
Set wb = ActiveWorkbook
'wb.SaveAs Filename:="\\nygisw906107\My Documents\test.xls"
wb.SaveAs Filename:="c:\Documents and Settings\1igodzin\My
Documents\test.xls"
'wb.Save
End Sub
I am trying to save this WB using wb.Saveas in the same place with the
same name. Depending how I Open the WB only one of these lines is
working.
1. open using File|Open . in this case second statement is working.
2. open using Start|Run \\nygisw906107\My Documents\test.xls just first
statement is working.
In Excel 2000 both statements are working.
Does somebody have ideas why it doesn't work in Excel2002
Thanks,
Ilya
Sub main()
Dim wb As Workbook
Set wb = ActiveWorkbook
'wb.SaveAs Filename:="\\nygisw906107\My Documents\test.xls"
wb.SaveAs Filename:="c:\Documents and Settings\1igodzin\My
Documents\test.xls"
'wb.Save
End Sub
I am trying to save this WB using wb.Saveas in the same place with the
same name. Depending how I Open the WB only one of these lines is
working.
1. open using File|Open . in this case second statement is working.
2. open using Start|Run \\nygisw906107\My Documents\test.xls just first
statement is working.
In Excel 2000 both statements are working.
Does somebody have ideas why it doesn't work in Excel2002
Thanks,
Ilya