PC Review


Reply
Thread Tools Rate Thread

different behavior in Excel2002

 
 
igodzin@lehman.
Guest
Posts: n/a
 
      24th Oct 2003
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/

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel2002 JWD Microsoft Excel Setup 0 9th Nov 2009 03:55 PM
Excel2002 & Trapping Esc key =?Utf-8?B?VGFu?= Microsoft Excel Programming 4 9th May 2006 12:32 AM
VBA and comments in Excel2002 Neil Garrard Microsoft Excel Programming 4 25th Feb 2004 12:50 PM
excel2002 elwyn Microsoft Excel Discussion 2 11th Nov 2003 10:54 PM
ASC( ) in EXCEL2002 chengj Microsoft Excel Worksheet Functions 0 31st Oct 2003 01:39 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:01 PM.