Tom Ewald
Tom Ewald

Reputation: 21

See Excel add-in via Access VBA?

How can I retrieve a constant (or other items) from an Excel add-in via Access VBA? I am using Office 2013. I can open an Excel instance, and it shows the add-in as installed, but I do not know how to refer to the modules (for which I have the password) or items within the modules (e.g., a constant). Thanks.

Upvotes: 0

Views: 36

Answers (1)

Nathan_Sav
Nathan_Sav

Reputation: 8531

Have a function in the Add In would be the easiest way

public function GET_CONST_CONSTANTNAME() as variant
     GET_CONST_CONSTANTNAME=cstApplicationVersion
end function

other way is to start exploring with the IDE, looking for declaration lines etc. can be time consuming

Upvotes: 1

Related Questions