How to access One Folder Up for files

Coll4208

New Member
Joined
Oct 14, 2022
Messages
3
Office Version
  1. 365
Platform
  1. Windows
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!!
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Forum statistics

Threads
1,223,603
Messages
6,173,308
Members
452,510
Latest member
RCan29

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top