Ask user to select Two Databases then perform some actions.
Forums
Hi,
I have been asked to compare expenditures related to the same client over two years.
I need to create a DialogBox that prompt the user to select the databases and call them to do some grouping and comparison.
I was trying to get inspiration from Brian's youtube video but I got stuck with a sintax error I can't understand.
I attach the ISS file.
As I am still learning how to code I will go with doubling the test on each of them and use a recorded macro to work with DBjoin, comparison and Analytical Review.
Thank you for your help.
Nope, the purpose of the main
Nope, the purpose of the main sub is to be the starting point of any script, so the sub is the starting and ending point of your script. So you could do the following:
Sub Main
Call menu
Call Test1
Call Test2
Call Test3
End Sub
So really it is the most important part of your script.
Hi Vitopiepoli,
Hi Vitopiepoli,
I updated the script so that you can get two files. I also added comments to the code so you can see what I did.
Brian