Can I get Power Query to Export a Spreadsheet to another Workbook somewhere else?
DILLEMA: I am creating several Budget Data Entry Worksheets for various Regions. The Payroll Data is automatically imported via a Power Query from a Payroll Master. All is well until....the files are moved to other computers. I am using Dropbox right now, but the path is different for everyone. SO.... I created a Cell that returns the current Path of the current file (see below). This is great but only if everything is in the same folder. I don't want Payroll Master in this Folder. I can put it in the folder above, but, I don't know a code to return that path.
So Far I have:
I have found: =LEFT(CELL("filename",P1),FIND("[",CELL("filename",P1))-1)
and even =HYPERLINK("..","Open One Folder Up")
The first one will return the Path in text for the current file folder, and the second one is a hyperlink. How can I get the Path for the Hyperlink to show?
Thank you!!
DILLEMA: I am creating several Budget Data Entry Worksheets for various Regions. The Payroll Data is automatically imported via a Power Query from a Payroll Master. All is well until....the files are moved to other computers. I am using Dropbox right now, but the path is different for everyone. SO.... I created a Cell that returns the current Path of the current file (see below). This is great but only if everything is in the same folder. I don't want Payroll Master in this Folder. I can put it in the folder above, but, I don't know a code to return that path.
So Far I have:
I have found: =LEFT(CELL("filename",P1),FIND("[",CELL("filename",P1))-1)
and even =HYPERLINK("..","Open One Folder Up")
The first one will return the Path in text for the current file folder, and the second one is a hyperlink. How can I get the Path for the Hyperlink to show?
Thank you!!