Re: general macro question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

How is your external program launching excel?

If you're automating it (createobject???), you'll have to load the addin
yourself in the code that launches excel.



ynissel wrote:

I feel like a serious novice.
I am having such problems either trying to follow the directions or excel
isnt cooperating.
I finally got it to work and the toolbar opens up when I launch excel - but
when the external program launches excel it still doesnt show up. when I go
to add-in - its checked off !
What am I doing wrong ????

"Dave Peterson" wrote:

Subs in .xla's aren't visible via the Tools|macro|macros dialog.

That's why I suggested:

And to give them a way to run that macro, I'd either use stuff added to the
worksheet menubar or a dedicated toolbar.

I really like the way John Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

ynissel wrote:

Dave - I tried it your way - crated the macro in a worksheet saved it as an
xla. brought it in as an add-in but it still didnt show up ? when I go to
the macro menu option - I dont see any macro ?
What am I doing wrong ?

"Dave Peterson" wrote:

I wouldn't use a .xlt file for this.

I'd create the macro, but store it in a workbook that was saved as .xla (excel
addin).

And then I'd share that addin with anyone who needed the macro.

If possible, I think I'd put it on a network share and have the other users
install the addin via Tools|addins|browse. Then I'd only have to update one
file when something changed.

But if not all the users have access to a common network drive, you could email
the workbook (still .xla) and tell them to store it where they want.

And still use tools|addins|browse to install it.

And to give them a way to run that macro, I'd either use stuff added to the
worksheet menubar or a dedicated toolbar.

I really like the way John Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)



ynissel wrote:

I have an external program that creates a report into excel. I execute a
report in the program and it opens excel and populates the report data (with
formatting and all).

My issue is that I have a macro I want to run against this new file that is
created - but the way the external program works it opens a new instance of
excel so any macro I have created or have open in another instance wont run
in this instance - only the other one. Is thre any way to make a macro that
is open to any instance of excel you have running ?

Thanks,
Yosef

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
.

Relevant Pages

  • Re: general macro question
    ... addin yourself. ... have to start excel, you'll have to load the addin and run the Auto_open ... automatically opens excel with the report there! ... the macro menu option - I dont see any macro? ...
    (microsoft.public.excel.misc)
  • Re: VBA: For Count, when count changes from cell to cell
    ... with Excel 2000. ... reporting Macro being unavailable. ... Sub CalculateI3() ... means that you can refer to it in a cell just like a built-in Excel function. ...
    (microsoft.public.excel.misc)
  • RE: Sorting macro needed on a protected sheet
    ... they all have Excel 2003, before reposting this thread as a new discussion to ... you will still be prompted to enter a password when running your macro even ... closing the password dialog box performed the sort macro anyway without ... Autofiltering can be restored without having to close & ...
    (microsoft.public.excel.programming)
  • Re: no macros in new sheet
    ... because the addin macro does not appear on ... > normal if the addin creates a single worksheet workbook. ... > My new guess is that the other program opens excel. ... If it just opens another instance, ...
    (microsoft.public.excel.misc)
  • Re: Exporting Hierarchy to Excel (Jack`s Macro)
    ... Now an empty Excel ... Sub dwn ... How exactly did you copy Jack's code into the VB editor? ... contains Jack's macro? ...
    (microsoft.public.project)