Excel Macro - Relative Path
Many thanks Macropod.
So if I have a recorded Macro containing the following:
ChDir "C:\MI\01"
Workbooks.Open FileName:=
_"C:\MI\01\01.csv
Workbooks.Open FileName:=
_"C:\MI\01\02.csv
etc, etc...
How would I edit the code to find MI as the root directory with the relative
path from there down to various sub directories?
Apologies if this is basic, but I'm unsure how to implement.
Thanks.
|