I am not a big programmer but I have been learning basic stuff with visual basic lite in Excel. I have been building an application in excel recently but the size of the database have outgrown excel. So now I need to use Excel to performe some Webqueries and Access to manage the data.
I have tryed many things but I am unable to start an excel file from access, have access wait for the program to end, and shut the file. For example: if I want to load an Autostart excel program in c:\webspy\spy.xls.... ( the macro runs for about 2 hours so Access needs to wait ) and shut it done and then have access finish the job.
How do I do the excel part? Could someone past a routine for me?