| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save file queries
Hi, I have this line of code (Y is a string) ActiveWorkbook.SaveAs Filename:=Y when there are a same file name "Y" exist in the same location, but i don't want to overwrite the file, what code that need to add, in order to ask the user to enter another file name instead o overwrite the file? Regards yl chuah : -- ylchua ----------------------------------------------------------------------- ylchuah's Profile: http://www.excelforum.com/member.php...fo&userid=2534 View this thread: http://www.excelforum.com/showthread.php?threadid=40037 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell2003 (SP-1) File > Save and File > Save As.. grayed out | Excel Discussion (Misc queries) | |||
| Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions | |||
| Excel marcos firing on file save as but not file save | Excel Programming | |||
| Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
| Save As - Multiple Sheets fails to save as text file | Excel Programming | |||
![ylchuah[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
