I copy a code from Mr. Ron de Bruin website here
to import/export all macros in each module.
It works perfectly, thanks to Mr. Ron de Bruin.
Since I don't understand the codes at all (just using it)
I would like to know how the code wofrom the code below :
At the blue line :
If I directly added a code [msgbox "SpecialPath"] under the blue line, the msgbox shows [D:\Documents].
Since I want a different directory, I changed the blue line into [SpecialPath = "D:\xxx\"].
Although the code runs then put the "VBAProjectFiles" folder inside D:\xxx\ directory....
I wonder, is it OK if I change the blue line into [SpecialPath = "D:\xxx\"] ?
I ask this because I think the blue line has a connection with the purple line which I don't understand at all what does the purple line code mean...
so, I am afraid later on maybe the code won't run (trouble) because I change the blue line code into [SpecialPath = "D:\xxx\"] which has no connection with the purple line anymore.
Any kind of respond would be greatly appreciated.
Thank you in advanced.
Bookmarks