Calling Excel Macros

's Computer Specifications

Is it knowen that when using the

Application.Run command for calling a excel file macro, that
"SHEET.xls!macro" that the SHEET name, can not have spaces? Ex. "Run This
Macro.xls" vs "RunThisMacro.Xls" . Odd...

's Computer Specifications

No, I believe it can have spaces, just delimit the name with ' characters.

"'SHEET.xls'!macro"

--

Ken Snell
<MS ACCESS MVP>

"derek michael" <derek (E-Mail Removed)> wrote in message
news:5745B2CD-7CEB-4B76-B0D5-(E-Mail Removed)...
> Is it knowen that when using the
>
> Application.Run command for calling a excel file macro, that
> "SHEET.xls!macro" that the SHEET name, can not have spaces? Ex. "Run This
> Macro.xls" vs "RunThisMacro.Xls" . Odd...

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calling excel-macros from script?	grz01	Microsoft Excel Discussion	4	4th May 2005 11:11 PM
Calling excel-macros from script?	grz01	Microsoft Excel Programming	5	4th May 2005 11:11 PM
Calling Excel 4 Macros From VBA	=?Utf-8?B?RWxveQ==?=	Microsoft Excel Programming	1	24th Jan 2005 04:43 PM
Calling Excel Macros	TommyBoy	Microsoft C# .NET	3	13th Aug 2004 10:42 PM
Re: Calling Excel FUNCTION MACROS Programmatically from VB	Rob Bovey	Microsoft Excel Programming	0	23rd Jul 2003 09:35 PM