Steps
1. Create your query
2. Name a specific cell
3. Go to Visual Basic Editor, or Press Alt+F11
4. Enter Code
5. Create a button, or an Icon
6. Assign macro to the button/icon
7. Go to the Power Query Editor
8. Open the Advanced Editor, and update the first few lines of code to reflect the following
LocalPath = Excel.CurrentWorkbook(){[Name="FilePath"]}[Content]{0}[Column1], Source = Excel.Workbook(File.Contents(LocalPath), null, true),
That's it!
Негізгі бет Allow User to Select File | Power Query | M + VBA | Excel
Пікірлер: 5