Hi,
I have this code which renames the file and saves in a designated folder. However, although it saves the file, it crashed excel so i'm guessing i've gone wring somewhere. Can anyone help?
As well as this I would also like it to clear all sub's in the worksheet. Can this be done?
Please Login or Register to view this content.
Regards
Jimmi
Last edited by jimmisavage; 06-26-2019 at 06:51 AM.
why are you changing the directory? just code that in for your newFile. does that make sense?
So you're saying something like this?Originally Posted by dmcgov
Okay, I have got that working. I wanted to edit it slightly because it's actually on a network drive. It works fine when the netwrok drive is allocated "S" but if someone else has it as "T" (for instance) then it's going to throw an error. I changed the location to "\\mynetworkdrive\example\example\example" but it doesn't want to find that. Am I using it right?Please Login or Register to view this content.
Last edited by jimmisavage; 06-26-2019 at 09:41 AM.
Possibly because you're saving the file before saving the file??? Why not just save the file in a normal subroutine?Please Login or Register to view this content.
It's strange because both ways react the same. If I save it by using 'Save As' it saves fine. But if I just click 'Save' or the save icon then it crashes excel.Possibly because you're saving the file before saving the file??? Why not just save the file in a normal subroutine?Please Login or Register to view this content.
Although it does save the file
It may be crashing because it goes into an infinite loop - saving a file in a 'beforesave' subroutine triggers the 'beforesave' sub which triggers the 'beforesave'....
make sure to add '\' to your filename so it becomes:Please Login or Register to view this content.
let me figure out code for path changePlease Login or Register to view this content.
Okay, that makes sense.
How would I work around that? It doesn't need to save before saving, it just needs to change the name and then save.
so say you have two network drives, S: and T:
will the ThisWorkbook reside in either S or T?
or how will you differentiate between the two drives?
I'm talking about the same network drive. Only on my PC it might be mapped as S but on another it could be mapped as T.
Okay, I've worked around it by making it auto save when the file is opened. That way the original will always stay in tact and the new file is ready to go.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks