RE: SV: [development-axapta] Running Excel macros from Axapta through COM ?
Hi Jos,
Thank you very much. It is working after I did what
you said, but after run the macro, I gor another error
message:
Method 'Run' in COM object of class
'Excel.Application' returned error
code 0x800A9C68 () which means:.
Do you know what cost this error?, and where can i
check the meaning of code 0x800A9C68?
Thanks
Jesse
--- Jos Litjens <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> Have you figured it out yet? I had the same error
> message, turned out
> the statement misses some quotes. It should be:
>
> xlApp.Run("'c:\\Documents
>
andSettings\\jwang\\Desktop\\MonthlyTest.xls'!Macro1");
>
> So add a quote before c:\\ and after xls and it
> should work!
>
> Regards,
>
> Jos Litjens
>
>
> -Original Message-
> From: development-axapta@yahoogroups.com
> [mailto:[EMAIL PROTECTED] On
> Behalf Of jessewang_98
> Sent: woensdag 13 juli 2005 1:12
> To: development-axapta@yahoogroups.com
> Subject: Re: SV: [development-axapta] Running Excel
> macros from Axapta
> through COM ?
>
> Do you have code example?
> why I could not run this code:
> static void test_ExcelMacro(Args _args)
> {
> COM xlApp;
> ;
>
> xlApp = new COM("Excel.Application");
> xlApp.Visible(1);
> //xlApp.Run("MacroTest.xls!TestMacro");
> xlApp.Run("c:\\Documents and
> Settings\\jwang\\Desktop\\MonthlyTest.xls !Macro1");
> // ...
>
> }
> Error Message:
>
> Method 'Run' in COM object of class
> 'Excel.Application' returned error
> code 0x800A03EC () which means: The macro
> 'c:\Documents and
> Settings\jwang\Desktop\MonthlyTest.xls !
> Macro1' cannot be found.
>
>
>
> --- In development-axapta@yahoogroups.com, "Jens
> Strandberg"
> <[EMAIL PROTECTED]> wrote:
> > Thanks for your reply.
> >
> > The Excel stuff is set up properly and works just
> fine, when I run
> the macro
> > inside Excel.
> >
> > However, doing the "Run" on the COM object in
> Axapta tells me, that
> this
> > cannot be done... :-(
> >
> > Any additional input ?
> >
> > Best Regards,
> > Jens
> >
> > -Oprindelig meddelelse-
> > Fra: Amund [mailto:[EMAIL PROTECTED]
> > Sendt: 16. september 2004 14:08
> > Til: development-axapta@yahoogroups.com
> > Emne: Re: [development-axapta] Running Excel
> macros from Axapta
> through
> > COM ?
> >
> >
> > Inside VBA this would be something like:
> Application.Run
> > "Workbook.xls!Macroname"
> >
> > From Axapta you can use:
> COM-object>.Run("Workbook.xls!
> Macroname");
> >
> > In general you may do what you want inside the
> macro recorder in
> Excel (or
> > Word, or..) and use the resulting VBA-code almost
> as-is in Axapta.
> >
> > Amund
> >
> >
> >
> > Thu, 16 Sep 2004 13:50:36 +0200 skrev Jens
> Strandberg
> > <[EMAIL PROTECTED]>:
> >
> > > Hello there,
> > >
> > > I am using COM to display data from Axapta in
> Excel. Is there a
> way to
> > > tell
> > > Excel to run a certain macro once the data has
> been moved to
> Excel ?
> > >
> > > Thanks in advance !
> > >
> > > Best Regards,
> > >
> > > Jens
> > >
> > >
> > >
> > > Yahoo! Groups Sponsor
> > > ADVERTISEMENT
> > >
> > > Yahoo! Groups Links
> > >
> > > To visit your group on the web, go to:
> > >
> http://groups.yahoo.com/group/development-axapta/
> > >
> > > To unsubscribe from this group, send an email
> to:
> > > [EMAIL PROTECTED]
> > >
> > > Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of
> Service.
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
__
Yahoo! Mail
Stay connected, organized, and protected. Take the tour:
http://tour.mail.yahoo.com/mailtour.html
YAHOO! GROUPS LINKS
Visit your group "development-axapta" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: SV: [development-axapta] Running Excel macros from Axapta through COM ?
Hi there,
Have you figured it out yet? I had the same error message, turned out
the statement misses some quotes. It should be:
xlApp.Run("'c:\\Documents
andSettings\\jwang\\Desktop\\MonthlyTest.xls'!Macro1");
So add a quote before c:\\ and after xls and it should work!
Regards,
Jos Litjens
-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of jessewang_98
Sent: woensdag 13 juli 2005 1:12
To: development-axapta@yahoogroups.com
Subject: Re: SV: [development-axapta] Running Excel macros from Axapta
through COM ?
Do you have code example?
why I could not run this code:
static void test_ExcelMacro(Args _args)
{
COM xlApp;
;
xlApp = new COM("Excel.Application");
xlApp.Visible(1);
//xlApp.Run("MacroTest.xls!TestMacro");
xlApp.Run("c:\\Documents and
Settings\\jwang\\Desktop\\MonthlyTest.xls !Macro1"); // ...
}
Error Message:
Method 'Run' in COM object of class 'Excel.Application' returned error
code 0x800A03EC () which means: The macro 'c:\Documents and
Settings\jwang\Desktop\MonthlyTest.xls !
Macro1' cannot be found.
--- In development-axapta@yahoogroups.com, "Jens Strandberg"
<[EMAIL PROTECTED]> wrote:
> Thanks for your reply.
>
> The Excel stuff is set up properly and works just fine, when I run
the macro
> inside Excel.
>
> However, doing the "Run" on the COM object in Axapta tells me, that
this
> cannot be done... :-(
>
> Any additional input ?
>
> Best Regards,
> Jens
>
> -Oprindelig meddelelse-
> Fra: Amund [mailto:[EMAIL PROTECTED]
> Sendt: 16. september 2004 14:08
> Til: development-axapta@yahoogroups.com
> Emne: Re: [development-axapta] Running Excel macros from Axapta
through
> COM ?
>
>
> Inside VBA this would be something like: Application.Run
> "Workbook.xls!Macroname"
>
> From Axapta you can use: .Run("Workbook.xls!
Macroname");
>
> In general you may do what you want inside the macro recorder in
Excel (or
> Word, or..) and use the resulting VBA-code almost as-is in Axapta.
>
> Amund
>
>
>
> Thu, 16 Sep 2004 13:50:36 +0200 skrev Jens Strandberg
> <[EMAIL PROTECTED]>:
>
> > Hello there,
> >
> > I am using COM to display data from Axapta in Excel. Is there a
way to
> > tell
> > Excel to run a certain macro once the data has been moved to
Excel ?
> >
> > Thanks in advance !
> >
> > Best Regards,
> >
> > Jens
> >
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> > http://groups.yahoo.com/group/development-axapta/
> >
> > To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
>
>
>
>
> Yahoo! Groups Links
Yahoo! Groups Links
YAHOO! GROUPS LINKS
Visit your group "development-axapta" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: SV: [development-axapta] Running Excel macros from Axapta through COM ?
Do you have code example?
why I could not run this code:
static void test_ExcelMacro(Args _args)
{
COM xlApp;
;
xlApp = new COM("Excel.Application");
xlApp.Visible(1);
//xlApp.Run("MacroTest.xls!TestMacro");
xlApp.Run("c:\\Documents and
Settings\\jwang\\Desktop\\MonthlyTest.xls !Macro1");
// ...
}
Error Message:
Method 'Run' in COM object of class 'Excel.Application' returned
error code 0x800A03EC () which means: The
macro 'c:\Documents and Settings\jwang\Desktop\MonthlyTest.xls !
Macro1' cannot be found.
--- In development-axapta@yahoogroups.com, "Jens Strandberg"
<[EMAIL PROTECTED]> wrote:
> Thanks for your reply.
>
> The Excel stuff is set up properly and works just fine, when I run
the macro
> inside Excel.
>
> However, doing the "Run" on the COM object in Axapta tells me, that
this
> cannot be done... :-(
>
> Any additional input ?
>
> Best Regards,
> Jens
>
> -Oprindelig meddelelse-
> Fra: Amund [mailto:[EMAIL PROTECTED]
> Sendt: 16. september 2004 14:08
> Til: development-axapta@yahoogroups.com
> Emne: Re: [development-axapta] Running Excel macros from Axapta
through
> COM ?
>
>
> Inside VBA this would be something like: Application.Run
> "Workbook.xls!Macroname"
>
> From Axapta you can use: .Run("Workbook.xls!
Macroname");
>
> In general you may do what you want inside the macro recorder in
Excel (or
> Word, or..) and use the resulting VBA-code almost as-is in Axapta.
>
> Amund
>
>
>
> Thu, 16 Sep 2004 13:50:36 +0200 skrev Jens Strandberg
> <[EMAIL PROTECTED]>:
>
> > Hello there,
> >
> > I am using COM to display data from Axapta in Excel. Is there a
way to
> > tell
> > Excel to run a certain macro once the data has been moved to
Excel ?
> >
> > Thanks in advance !
> >
> > Best Regards,
> >
> > Jens
> >
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> > http://groups.yahoo.com/group/development-axapta/
> >
> > To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
>
>
>
>
> Yahoo! Groups Links
YAHOO! GROUPS LINKS
Visit your group "development-axapta" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
SV: [development-axapta] Running Excel macros from Axapta through COM ?
Thanks for your reply.
The Excel stuff is set up properly and works just fine, when I run the macro
inside Excel.
However, doing the "Run" on the COM object in Axapta tells me, that this
cannot be done... :-(
Any additional input ?
Best Regards,
Jens
-Oprindelig meddelelse-
Fra: Amund [mailto:[EMAIL PROTECTED]
Sendt: 16. september 2004 14:08
Til: [EMAIL PROTECTED]
Emne: Re: [development-axapta] Running Excel macros from Axapta through
COM ?
Inside VBA this would be something like: Application.Run
"Workbook.xls!Macroname"
From Axapta you can use: .Run("Workbook.xls!Macroname");
In general you may do what you want inside the macro recorder in Excel (or
Word, or..) and use the resulting VBA-code almost as-is in Axapta.
Amund
Thu, 16 Sep 2004 13:50:36 +0200 skrev Jens Strandberg
<[EMAIL PROTECTED]>:
> Hello there,
>
> I am using COM to display data from Axapta in Excel. Is there a way to
> tell
> Excel to run a certain macro once the data has been moved to Excel ?
>
> Thanks in advance !
>
> Best Regards,
>
> Jens
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Yahoo! Groups Links
Yahoo! Groups Sponsor ~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM
~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
