I would like to run a macro from Excel that does the following things:
1) Runs a .bat file from a network share to open Access front end (unless already open)
Current is [Shell "\\sbs\EMS_APP\Launch bat\OT_Sandbox.bat"] This works but is it all I need for good programming? How to I make sure the app is not already open for example?
2) Run Access query named "qryPasteExcel"
I've been reading related posts but they seem to be too advanced or too specific for my level.
I have more to do here but I will enter as a new question.
Thanks to all for any additional explanations that may help me learn.