Hi All,
I am seeking some guidance on creating some VBA code to handle a process, I recently started to edit VBA and have had some fun creating a CRUD db. The next project is slightly different and if I have some assistance on the principles I can build what I need from there. I have trawled a number of posts (including Google) similar to mine but unable to relate.
In the sample DB, I have two simple select queries and I would like to understand the code needed to run each query and insert the data into a new single excel workbook with each query having its own tab. The output excel file is what I am trying to achieve.
Many Thanks
I am seeking some guidance on creating some VBA code to handle a process, I recently started to edit VBA and have had some fun creating a CRUD db. The next project is slightly different and if I have some assistance on the principles I can build what I need from there. I have trawled a number of posts (including Google) similar to mine but unable to relate.
In the sample DB, I have two simple select queries and I would like to understand the code needed to run each query and insert the data into a new single excel workbook with each query having its own tab. The output excel file is what I am trying to achieve.
Many Thanks