Add in functionality in VBA

CDienst

New Member
Joined
Jul 11, 2018
Messages
31
Hello,

I'm using an add-in that adds functions to pull data from a 3rd party program. The add-in also adds a section to the ribbon with buttons that recalculate (either the current sheet or all sheets in the book). Is there any way to activate these recalculate options in a VBA macro? They seem to work a lot faster than just the standard <sheets>.Calculate.
I tried contacting support for the people who made the add-in (who are also the people who make the 3rd party program) and they just told me that macros are up to the user. I googled the issue a bit and the only things I found involved referencing or doing things with an .xll file, which I could not find. The file that is used to install the add-in is an .exe.
Does anyone know how I might accomplish this, or where I should look to find out how?

Thanks</sheets>
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Have you tried recording a macro when you use this particular option?
That might give you a clue as to the syntax to use.
 
Upvote 0
Oh, that was a good idea.
It comes out as
Code:
 Application.CalculateFull
 Application.CalculateFull
I guess I must have been imagining it being faster?

EDIT: I've gone back and compared running the macro it created and compared it to using the button from the add-in, and the one from the add-in is definitely faster.
Is there some way I can dissect the add-in and maybe find out how it works?
 
Last edited:
Upvote 0
From memory, some add-ins are included as macros.
You might be able to check the VBA code in the editor (unless, of course, it's been password protected).
 
Upvote 0

Forum statistics

Threads
1,214,985
Messages
6,122,605
Members
449,089
Latest member
Motoracer88

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