Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Excel - Web Save Problem

I am launching Excel from a Browser. Using both IE and Netscape. Excel
2000. When I save the file I use a SaveAs function to save the Netscape
launched file to a specific location / name. (Note: Netscape gives a file
opened with its browser a odd system generated name like "VIEBF6M1.xls".)
This works fine, if I save the file with the SaveAs function. If not, and I
chose not to save the file, within the Macro, it then asks if I want to save
the file with the system generated file name. It asks this question after
the Macro with the SaveAs function has completed. The question comes up
after the end of the macro. Checked with a break at the end of the Macro.

I have tried using an "Application.DisplayAlert=False" within the code but
this does not help. On break, just after the above statement, the
Application.DisplayAlert = True? Only one file open.

IE launched files have the same name as the original file and are not a
problem.

Suggestions?


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 42
Default Excel - Web Save Problem

Try putting DoEvents after your messages controlling the save options.

"ksgoodwin" wrote in message
...
I am launching Excel from a Browser. Using both IE and Netscape. Excel
2000. When I save the file I use a SaveAs function to save the Netscape
launched file to a specific location / name. (Note: Netscape gives a file
opened with its browser a odd system generated name like "VIEBF6M1.xls".)
This works fine, if I save the file with the SaveAs function. If not, and

I
chose not to save the file, within the Macro, it then asks if I want to

save
the file with the system generated file name. It asks this question after
the Macro with the SaveAs function has completed. The question comes up
after the end of the macro. Checked with a break at the end of the Macro.

I have tried using an "Application.DisplayAlert=False" within the code but
this does not help. On break, just after the above statement, the
Application.DisplayAlert = True? Only one file open.

IE launched files have the same name as the original file and are not a
problem.

Suggestions?






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
file save problem in excel Duncan Excel Discussion (Misc queries) 1 April 27th 07 12:32 AM
Excel Save-AS Problem Charles Barnum Excel Discussion (Misc queries) 0 February 12th 07 04:17 AM
Save problem for linked excel spreadsheet Meltad Excel Discussion (Misc queries) 2 September 13th 06 04:27 PM
Excel save as problem Gabor Excel Discussion (Misc queries) 3 February 23rd 06 04:35 PM
Problem using save as in Excel Dan Kilgore Excel Discussion (Misc queries) 0 April 27th 05 08:41 PM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"