Call a Excell macro

T

tuxo99

Board Regular
Joined
Aug 13, 2015
Messages
75
Hello,

I would like to know if it is in an access macro to call a macro from Excel.

Thank you
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Sort by date Sort by votes
Pretty sure you cannot. However, you could open an Excel file (RunApp command in Access macro) that has an Auto_Open macro. That Excel macro would have to call whatever other workbook macro you want to run. Make sure you have "Show All Actions" turned on in Access because I believe the default setting will not show the RunApp command. You might have to ensure the workbook is in a 'trusted' location in order to get an Auto_Open macro to run.
 
Upvote 0
Yes it can call an Excel Macro, can you supply some extra information. This would be done in the VBA screen.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Having a problem in the expression builder, very new to Access. It thinks I'm trying to use Automation objects?
2
Replies
15
Views
823
Micron
M
CPGDeveloper
  • Question
Error Messages and Best Practices
Replies
5
Views
335
Micron
M
D
  • Solved
Export To Excel .XLSX file
Replies
3
Views
774
Micron
M
J
  • Question
Split Name
2
Replies
10
Views
914
dellehurley
D
C
  • Question
Linked Excel table in Access - field values change as I navigate?
Replies
5
Views
486
welshgasman
welshgasman

Forum statistics

Threads
1,221,834
Messages
6,162,268
Members
451,758
Latest member
lmcquade91

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top