Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Confirm SaveAs takes place.
I have a file that automatically copies out specific tabs of my main workbook
to a new workbook and then I am using the following code to save the new workbook to a intranet sharepoint with a name_date_time format for the file name. ActiveWorkbook.SaveAs "http://path/" & "PassCounts_" & format(now,"mmddyy_hhmmss") & ".xls" How can I have Excel verify the SaveAs function took place on the new workbook, saving the file appropriately to the intranet sharepoint, with out a prompt to accept or cancel? If the SaveAs function did not take place, acctually saving the file, I want the SaveAs process to loop until it does take place. Any help is appreciated. Stephen W |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn AutoCalc before calc takes place | Excel Programming | |||
Skipping confirm | Excel Programming | |||
What takes the place of a space in a formula? | Excel Discussion (Misc queries) | |||
Confirm Autofilter off | Excel Programming | |||
Save takes seconds vs. SaveAs/Save As takes minutes | Excel Programming |