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
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/