Unfortunately not with these videos. I do have a simpler version without VBA and less SQL for members th-cam.com/video/2oT-PhgcKa8/w-d-xo.htmlfeature=shared
@AnthonySmoak it's not that. I had to keep pausing the video so I could read your code. If it were in an article, I could just read it and copy paste some parts. I understand SQL and some VB. Thanks for the video and the reply!
Hey Anthony nice video. What do I need to do if instead of details I want to do pivot table representation? meaning I want to do all this, but then data needs to be transformed to a pivot table without user interaction.
Thanks. You can repeat the process on a table that has been "pre-pivoted" in SQL Server or most likely you will need some sort of VBA code to automate the pivot. Play around with the macro recorder and observe what code it develops when you create a pivot table.
I spent 2 days trying to resolve this issue. It is a common issue people have and I'm not sure why. To fix, just replace the refresh line with: ActiveWorkbook.RefreshAll
how is this in anyway better than MSQuery where i could just do {Call MyStoredProcedure(?,?,?)}. Not a bit of VBA or a macro, i could just assign the 3 parameters to cells on the sheet.
I know MSQuery is listed as an older legacy option and you have to manually enable it in the latest version of Office 365 Excel (will it continue to be supported like VBA)? However, you have given me an option to test, I'll let you know how it goes.
@@AnthonySmoak My complaint is really with Microsoft. They took something simple and replaced it with a nightmare. I'm a programmer so other than disliking VBA, i have no problem with this approach other than it used to be very simple with MSQuery.
@@AnthonySmoak Thank you for doing that. Microsoft has buried MSQuery on the current Excel version and you have to add it to the menu yourself. I hope that it doesn't go away completely, or at least if it does Microsoft could replace it something that its as equally simple. I'm a programmer, but for fast ad-hoc solutions I can turnout an Excel doc calling a stored procedure in minutes. Perhaps the more people who know about and use MSQuery the less likely it gets killed by Microsoft.
thanks for the video, please can share this file with us so we can edit it according to our need or share the code you pasted. I will be much greafull thank you sir
Become a member and you can do this the easy way without code (and support the channel)! th-cam.com/video/2oT-PhgcKa8/w-d-xo.html
Hello, do you have this video in article format, so I can understand the SQL part more clearly?
Unfortunately not with these videos. I do have a simpler version without VBA and less SQL for members th-cam.com/video/2oT-PhgcKa8/w-d-xo.htmlfeature=shared
@AnthonySmoak it's not that. I had to keep pausing the video so I could read your code. If it were in an article, I could just read it and copy paste some parts. I understand SQL and some VB. Thanks for the video and the reply!
@@sureshmukhi2316 Thanks for watching!
@@AnthonySmoak Welcome!
Hey Anthony nice video. What do I need to do if instead of details I want to do pivot table representation? meaning I want to do all this, but then data needs to be transformed to a pivot table without user interaction.
Thanks. You can repeat the process on a table that has been "pre-pivoted" in SQL Server or most likely you will need some sort of VBA code to automate the pivot. Play around with the macro recorder and observe what code it develops when you create a pivot table.
Thank you very much. 👍🏼
Much appreciated!
Very nice.
Followed everything. Runs great on mine but some other users get runtime error 1004 on the refresh line of the macro. Thoughts?
Double check the cell references.
I spent 2 days trying to resolve this issue. It is a common issue people have and I'm not sure why. To fix, just replace the refresh line with: ActiveWorkbook.RefreshAll
i find its because the Refresh method isnt available to me for some reason
Thank you for this video it works perfectly, but i have the error 438 when we run this macro in an other PC
how to create stored procedure please give me a video step by step .....
I literally show the stored procedure code I use in the video. 😊
I cant get my button to execute I click it and nothing I tried this 3 times and I dont see anything wrong
@@jaygibbs7218 I assume you have design mode turned off and your code is placed in the on click action?
how is this in anyway better than MSQuery where i could just do {Call MyStoredProcedure(?,?,?)}. Not a bit of VBA or a macro, i could just assign the 3 parameters to cells on the sheet.
I know MSQuery is listed as an older legacy option and you have to manually enable it in the latest version of Office 365 Excel (will it continue to be supported like VBA)? However, you have given me an option to test, I'll let you know how it goes.
@@AnthonySmoak My complaint is really with Microsoft. They took something simple and replaced it with a nightmare. I'm a programmer so other than disliking VBA, i have no problem with this approach other than it used to be very simple with MSQuery.
@@jdwyer4851 I made a video exploring the MS Query approach. Thanks for the comment. th-cam.com/video/2oT-PhgcKa8/w-d-xo.htmlfeature=shared
@@AnthonySmoak Thank you for doing that. Microsoft has buried MSQuery on the current Excel version and you have to add it to the menu yourself. I hope that it doesn't go away completely, or at least if it does Microsoft could replace it something that its as equally simple. I'm a programmer, but for fast ad-hoc solutions I can turnout an Excel doc calling a stored procedure in minutes. Perhaps the more people who know about and use MSQuery the less likely it gets killed by Microsoft.
Very nice but the video is fast. Please see if you can make it go slow.
Adjust your playback speed in the settings.
thanks for the video, please can share this file with us so we can edit it according to our need or share the code you pasted. I will be much greafull thank you sir