Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Run Excel Macro from Access
- Thread starter CHTHOMAS
- Start date
Well the "shell' statement works well here.<br>
<br>
But your question is a bit vague. Do you want to open Excel and a speadsheet and run a macro on that spreadsheet.<br>
OR.... <p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>
<br>
But your question is a bit vague. Do you want to open Excel and a speadsheet and run a macro on that spreadsheet.<br>
OR.... <p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>
- Thread starter
- #3
What i would like to do is <br>
1) open an Access database ( in which there is a link to the Excel sheet),<br>
2) Run a macro in excel, which performs certain calculations on the sheet.<br>
<br>
So even if i don't explicitly open Excel sheet, i would be satisfied if the excel macro is run so that the Access database has the updated information from Excel.<br>
<br>
Charley
1) open an Access database ( in which there is a link to the Excel sheet),<br>
2) Run a macro in excel, which performs certain calculations on the sheet.<br>
<br>
So even if i don't explicitly open Excel sheet, i would be satisfied if the excel macro is run so that the Access database has the updated information from Excel.<br>
<br>
Charley
- Status
Similar threads
- Locked
- Question
- Locked
- Question