| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.run Macro Code Problem
Hey
Below is my code to run a procedure SMSClose in the SMSClose module of the workbook "Book1.xls". Application.Run "'" & TargetWB.Name & "'" & "!SMSClose" & Chr(34) Workbook "Book1.xls" is the book stored in variable TargetWB. When I go to run this code I get the following debug error: Run-Time error '1004': The macro "Book10'!SMSClose'" cannot be found. What am I doing wrong? Thank you Todd Huttenstine |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application.run Macro Code Problem
hey guys, I got it. It was a SYNTAX problem.
Application.Run "'" & TargetWB.Name & "'!SMSFinish" -----Original Message----- Hey Below is my code to run a procedure SMSClose in the SMSClose module of the workbook "Book1.xls". Application.Run "'" & TargetWB.Name & "'" & "!SMSClose" & Chr(34) Workbook "Book1.xls" is the book stored in variable TargetWB. When I go to run this code I get the following debug error: Run-Time error '1004': The macro "Book10'!SMSClose'" cannot be found. What am I doing wrong? Thank you Todd Huttenstine . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel application.quit in macro problem | New Users to Excel | |||
| macro to close excel application other than application.quit | Excel Programming | |||
| Code to set NamedRange for all application-Languages | Excel Programming | |||
| Application error with VBA code | Excel Programming | |||
| Code execution skips Application.Run statement | Excel Programming | |||
Hybrid Mode
