Allow User to Select File | Power Query | M + VBA | Excel
3.5 هزار بار بازدید -
4 سال پیش
-
Steps1. Create your query2. Name
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!
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!
4 سال پیش
در تاریخ 1399/11/10 منتشر شده
است.
3,538
بـار بازدید شده