Two related questions:
1. I used the wizard to create a command button on an Access form that runs Excel. However, if Excel is already open, the command button opens another copy of Excel. Also, when I launch Excel from the command button, it doesn't load the files that are in my XLStart folder. Is there some way to edit the code so that it will first check if Excel is already open, and if Excel isn't open, open it properly?
2. I want to put a command button on an Access form than will run an Excel macro. I tried to follow the Microsoft Knowledge Base instructions (Article - Q177760), but their example doesn't fit my needs. The code they give opens Excel, then opens a specified file, then runs a specified macro. The macro I want to run is in the Personal macro workbook, which is always open and hidden when Excel is running. So the command button should first check if Excel is already open, open it if neccessary, and then run the macro in the hidden Personal workbook.
I'd be grateful for any help, and examples of code are much appreciated.
Thanks!
1. I used the wizard to create a command button on an Access form that runs Excel. However, if Excel is already open, the command button opens another copy of Excel. Also, when I launch Excel from the command button, it doesn't load the files that are in my XLStart folder. Is there some way to edit the code so that it will first check if Excel is already open, and if Excel isn't open, open it properly?
2. I want to put a command button on an Access form than will run an Excel macro. I tried to follow the Microsoft Knowledge Base instructions (Article - Q177760), but their example doesn't fit my needs. The code they give opens Excel, then opens a specified file, then runs a specified macro. The macro I want to run is in the Personal macro workbook, which is always open and hidden when Excel is running. So the command button should first check if Excel is already open, open it if neccessary, and then run the macro in the hidden Personal workbook.
I'd be grateful for any help, and examples of code are much appreciated.
Thanks!
