call or run a macro using concantenation 1

• Nov 1, 2022

• #2

pmonett

Programmer

Sep 5, 2002

2,636

FR

I would create a VB Script that takes DotNum as parameter, creates the proper name and launches that macro.
Once that works, all you would need would be to point your existing action to the VB Script and send the proper DotNum.

I've got nothing to hide, and I demand that you justify what right you have to ask.

 

Upvote 0 Downvote

• Nov 1, 2022

• #3

Andrzejek

Programmer

Jan 10, 2006

8,578

US

So, what you are saying you have macros:

Code:

Option Explicit

Sub Im_Dot_12
...
End Sub

Sub Im_Dot_13
...
End Sub[red]
... etc.[/red]
Sub Im_Dot_23
...
End Sub

Are these different macros with different code?
Or the code is the same and the only difference is your DotNum?

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

Upvote 0 Downvote

• Nov 1, 2022

1
• #4

M

mintjulep

Technical User

Aug 20, 2004

1,562

JP

The best approach is almost certainly something else.

Why don't you explain what you need to do instead of how you think it should be done.

 

Upvote 0 Downvote

• Nov 1, 2022

• #5

strongm

MIS

May 24, 2001

20,264

GB

>Application.Run ("Im_Dot_" & DotNum), but this doesn't work

In what sense?

 

Upvote 0 Downvote

• Nov 1, 2022

• #6

M

mintjulep

Technical User

Aug 20, 2004

1,562

JP

At any rate, this works for me.

Code:

Public Sub Run_Me()
    MsgBox ("Run_Me ran!")
End Sub


Public Sub Run_You()
    MsgBox ("Run_You ran!")
End Sub



Public Sub Starter(who As String)

Dim target As String

 target = "Run_" & who
 
    Application.Run (target)

End Sub

 

Upvote 0 Downvote