| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Delete Macro
Thanks Joel!!
"joel" wrote: I should of tested the change better. Still ended up with two XLS at the end of the file. One problem is using the TMP directory your original workbook is opened and puts the open file into the Tmp directory. I put a Z infront of the temporay filename because I got an error that I was saving a file to a filename that already existed (the open file). Make this change to my last posting and it will work. guarenteeed. from FName = TempFilePath & TempFileName & ".xls" to FName = TempFilePath & "z" & TempFileName Note: TempFilename has the XLS on the end already. "andiam24" wrote: Joel, you're fast! Copied and pasted the code but still getting code in my sent attachment. Very frustrating :( |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Threaded Mode
