N
NateBuckley
Greetings,
I currently am using one workbook to open another, now the sheet I open is
always located in "\HolSheets\holSheet.xls" and the original workbook is in
the folder that is the parent of the directory HolSheets. This will always be
so, yet not sure where they want me to copy the report once I've completed
it, so does anyone know how to get the root of the original workbook, so then
I only need to specify the path like this
rootPath & "\HolSheets\holSheet.xls"
Being playing around with the filesystem object but still learning that part.
Thanks in advance! (Hopefully that was clear enough)
I currently am using one workbook to open another, now the sheet I open is
always located in "\HolSheets\holSheet.xls" and the original workbook is in
the folder that is the parent of the directory HolSheets. This will always be
so, yet not sure where they want me to copy the report once I've completed
it, so does anyone know how to get the root of the original workbook, so then
I only need to specify the path like this
rootPath & "\HolSheets\holSheet.xls"
Being playing around with the filesystem object but still learning that part.
Thanks in advance! (Hopefully that was clear enough)