Macro using file dialog opener - Cannot delete or rename folder when excel macro is

Hi All,

I am using below code for my macro to save files at user selected location
The are some folders which I created during execution.I was unable to dele those folders or rename when macro excel sheet is opened

Getting an error lik this cannot delte used by other program or other person
See the pic
Please find code here

Please Login or Register  to view this content.

All please have alook

Hi,

I'd guess that you need to close the files in your code before others can use them.