MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

AddIn Problem

  Asked By: Kent    Date: Feb 25    Category: MS Office    Views: 1575

I am new in Excel development. I would appreciate for your help in advance. My
problem is as follows:

I have written some macros in a worksheet. A group of these macros performs
some file collation task which are dumped some where on my hard drive. The path
of that specific folder is being fetched by Input box.

Active workbook, range, pivot cache, worksheet, range etc objects has been
used frequently in project. These macros are working well and performing the
required task without any problem while I run them from that workbook.

My problem is when I convert this workbook to an AddIn, I get error messages
as I am using active worksheet method in a macro to get the output which does
not appear in my AddIn. Being specific, I do not get any worksheet in my AddIn.

Questions about my problem are welcome. If necessary, I would paste my code



3 Answers Found

Answer #1    Answered By: Judy Gray     Answered On: Feb 25

If I'm interpreting your problem  correctly...

To use the add-in, you need to activate it for a given workbook  using
>Tools>Addins. Then, things such as "Active Workbook" will have a
context. As a stand-alone, the add-in will not have those things,
because it is NOT a normal workbook. It is just a collection of
functions and subroutines that can be "added in" to any workbook.

Answer #2    Answered By: Bernadette Daniels     Answered On: Feb 25

I followed your instruction and created a button on
toolbar and assigned my macro  to it. Now the problem  is after saving it as an
Add-In, when I access it in any opened workbook, my toolbar button is not
present there. It has been dis-appeared. How cld I trace it.

Answer #3    Answered By: Cecelia Sims     Answered On: Feb 25

Huh? I never gave you instructions on creating a button...

As far as I know, you can save the macro  for the button in the add-in,
but the button or toolbar would still need to be activated to whatever
worksheets you want it in. I don't believe it is saved within the
add-in. EXCEL stores custom buttons and menus in a different location.

Didn't find what you were looking for? Find more on AddIn Problem Or get search suggestion and latest updates.