hi guys
just wondered if there was any code that is available to do this function
save the sheet open then close it and then reopen the original
failing that
maybe save the sheet then clear all cells that have had data entered?
regards
hi guys
just wondered if there was any code that is available to do this function
save the sheet open then close it and then reopen the original
failing that
maybe save the sheet then clear all cells that have had data entered?
regards
Maybe
VBA NoobPlease Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Where Does That Save Noob?
I Cant See It Anywhere
Thanks For Reply
I assumed you have already saved the file before. This line save it to the current path
Or if you want to save to a path something likePlease Login or Register to view this content.
VBA NoobPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks