Many thanks for this excellent video! I have gone through this and the 2 earlier videos for creating data imports via VBA. Now I am feeling very well prepared for my tasks and could even generate all needed code while I followed your video! I was googling hours and hours for automated imports to EXCEL before - your 3 videos cover the topic totally! 😍
A Couple Questions: 1) Can you cover if you want to make the source for the query dynamic (like populated from a user-selected dialog box)? and 2) Is there any way to copy from advanced editor in PowerQuery such that it gives you something that's formatted correctly for VBA like what you paste in for query_formula in this video? When I paste it just thinks the query is "let"
Hi! Very interesting video! But i have a question: If I want to change the source of the query (x example: it takes info from "excel1.xlsx" and I want to change it to "excel2.xslx") how can I access to this property to change it¿? Only using VBA. Thanks!
What is the best way to update the records in the source table/sheet form the Power Query ( like, adding records, deleting a record, editing,.....). Can we make a column properties ( one or more columns) a Hyperlink that be clicking it, a custom data entry form be opened to add, deleted or update the record/s in the source tables?
The only thing that is disturbing with this is that when I add the query table, it's a "Connection only" instead of a table. I've tried to work it around but didn't succeed.
Hi can we do as below when:- Whenever Workbook is opened the Master Data sheet should be Locked & can be opened by individuals whoever knows the password. 2. When password is entered, Data sheet should be refreshed, updates the data & saves it. 3. Now data is refreshed-updated&saved into sheet, should again fall back to protection. This should be functioning I'm expecting. (Lock- Enter password- data Refresh & updated- Again Lock) 1. Click button 2. Enter password 3. Refresh sheet 4. save sheet 5. Lock sheet
Many thanks for this excellent video! I have gone through this and the 2 earlier videos for creating data imports via VBA. Now I am feeling very well prepared for my tasks and could even generate all needed code while I followed your video! I was googling hours and hours for automated imports to EXCEL before - your 3 videos cover the topic totally! 😍
Super video 👍👍 thanks
A Couple Questions: 1) Can you cover if you want to make the source for the query dynamic (like populated from a user-selected dialog box)? and 2) Is there any way to copy from advanced editor in PowerQuery such that it gives you something that's formatted correctly for VBA like what you paste in for query_formula in this video? When I paste it just thinks the query is "let"
Hi! Very interesting video! But i have a question: If I want to change the source of the query (x example: it takes info from "excel1.xlsx" and I want to change it to "excel2.xslx") how can I access to this property to change it¿? Only using VBA. Thanks!
What is the best way to update the records in the source table/sheet form the Power Query ( like, adding records, deleting a record, editing,.....). Can we make a column properties ( one or more columns) a Hyperlink that be clicking it, a custom data entry form be opened to add, deleted or update the record/s in the source tables?
What if I don't want to load the data to a worksheet but only use the connection to get the data and load it to a Combobox object for example?
The only thing that is disturbing with this is that when I add the query table, it's a "Connection only" instead of a table. I've tried to work it around but didn't succeed.
Hi. Resource file is different with RUclips contents. Please check resource file link.
Hi can we do as below when:-
Whenever Workbook is opened the Master Data sheet should be Locked & can be opened by individuals whoever knows the password.
2. When password is entered, Data sheet should be refreshed, updates the data & saves it.
3. Now data is refreshed-updated&saved into sheet, should again fall back to protection.
This should be functioning I'm expecting.
(Lock- Enter password- data Refresh & updated- Again Lock)
1. Click button
2. Enter password
3. Refresh sheet
4. save sheet
5. Lock sheet