Re: New form of application.run

Tech-Archive recommends: Fix windows errors by optimizing your registry

First, I haven't worked with xl2007 enough to be useful.

But AllSetFileProps is looking for a control to be passed to it.

But it doesn't look like you're using that control in that procedure.

Maybe:
Sub AllSetFileProps()
would be sufficient

or
Sub AllSetFileProps(Optional control as IRibbonControl)

But these are just guesses!

Lack of knowledge about xl2007 is a beautiful thing <vvbg>.


SteveDB1 wrote:

Dave,
Thanks for your time.
MacroC is:
-------------------------------------------------------------------
Sub AllSetFileProps(control As IRibbonControl)

Application.Run (ClearFileProps)

Application.Run (FillFilePropsComments)

Range("C5").Select

End Sub
-----------------------------------------------------------------------

"Dave Peterson" wrote:

Maybe it's time to share what MacroC looks like.

And maybe you should look for macros with duplicate names (in different
modules).

SteveDB1 wrote:

Ok, it appears that this is either too vague, or not understood.
Let me see if I can revise it some to clarify.
I have three macros.
MacroA, MacroB, and MacroC.
MacroA, and MacroB each perform a unique task, and work well.
MacroC has one job-- to access, and perform the task of both MacroA, and
MacroB, in order. Sample below.

Sub MacroC(control As IRibbonControl)
Application.run "MacroA"
Application.run "MacroB"

Range("c:5").select

end Sub

When I access MacroC, I get an error window, as stated before-- Argument not
optional error449. When I click debug, it takes me to the first
application.run "MacroA".
What is it that I've done wrong, and how can I correct it because I have at
least 6 or so macros that are similar to this one.
As always, in advance, thank you for your responses.
Best.

"SteveDB1" wrote:

Hello all.
One of my colleagues has a series of macros. In these macros he has a series
of calls-- application.run-- that call to activate a secondary, or series of
tertiary macros.
However, I keep getting the argument not optional error449.
This has lead me to think that Excel 2007 no longer uses that object event
handler.
Does anyone know the replacement, or new version of that command?
As always, your responses are deeply appreciated.
Thank you in advance.


--

Dave Peterson


--

Dave Peterson
.

Relevant Pages

  • Re: Toolbar reappears
    ... to create a set of auto macros in the user's normal.dot template that will ... control the default behaviour of Word. ... toolbox toolbar when you specifically call it. ... Sub AutoNew() ...
    (microsoft.public.word.customization.menustoolbars)
  • Re: New form of application.run
    ... Sub AllSetFileProps ... I have three macros. ... MacroA, MacroB, and MacroC. ... MacroA, and MacroB each perform a unique task, and work well. ...
    (microsoft.public.excel.programming)
  • Re: New form of application.run
    ... Sub AllSetFileProps ... I have three macros. ... MacroA, and MacroB each perform a unique task, and work well. ...
    (microsoft.public.excel.programming)
  • Re: Simple Insert Into...
    ... You can store unbound control data in a variable, ... in the sql. ... Dim strSQL As String ... In your form's Sub, you'll wind up with something like the following: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Simple Insert Into...
    ... it is in a control on the form; and is unbound (it's actually a combo ... box that is used as a dropdown list, values taken from a different table; SQL ... I need this value to assign a unique ID to the entire recordset being ... In your form's Sub, you'll wind up with something like the following: ...
    (microsoft.public.access.modulesdaovba)