Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file save problem in excel | Excel Discussion (Misc queries) | |||
Excel Save-AS Problem | Excel Discussion (Misc queries) | |||
Save problem for linked excel spreadsheet | Excel Discussion (Misc queries) | |||
Excel save as problem | Excel Discussion (Misc queries) | |||
Problem using save as in Excel | Excel Discussion (Misc queries) |