Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
With this script I open a file: Shell "explorer.exe " & ReNameFolder & SelectedFile Through another script I rename the file and save it in a different folder. Name ReNameFolder & SelectedFile As SQFolder & NewFileNm How do I close the "Shell.." before I run the rename script? I tried dimming Filename as variant, filename=shell... and then filename.close or quit, but I got an object error. Basically I want to take a file (could be a pdf, tif, or xfdl), rename it and save it to a different folder. And don't want to have to go back and delete it once done. Any help or suggestions would be greatly appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Close Shell | Excel Programming | |||
In Before Close Sub ActiveWorkBook.Close(False) repeat procedure | Excel Programming | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
Shell can open an application, can it close an app too? | Excel Programming | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel |