Hi,
I belive it is a runtime error and it is only because component object in
excel doesn't support bookmark method. I think you can take a look at the
methods which are supported by excel, the problem is that there is no compete
lising of these methods in any axapta help file and you will have to explore it
through ms excel macro library and any VB programmer could be more helpful.
anyone ! can you please tell us that where we could find a listing of all the
methods supported by com and com varient classes.
bye
Ax Dev <[EMAIL PROTECTED]> wrote:
Thanks Kumar,
I have generated a class using COM connection. I have created the bookmarks
in the excel sheet itself. But when i am trying to use those labels using
the method like this:
COM COMBookMarks,COMBookMark,COMRange;
DictField dictField;
Label label;
;
COMBookMarks = _COMWorksheet.*bookMarks()*;
if(COMBookMarks.exists('label_header'))
{
COMBookMark = COMBookMarks.item('label_header');
COMRange = COMBookMarks.range();
COMRange.insertAfter("InventoryList");
}
it shows the error that method *bookMarks() *doesn't exist in COM class.
Can you plz provide solution for this?
Thanks & Regards
Harsh
On 1/23/06, kumar gaurav <[EMAIL PROTECTED]> wrote:
>
> hi harsh,
>
> COM connector is the best way to do it, I don't see anyother way to print
> such report.
>
> You can use COM and COMVarient class for such report.
>
> bye
>
> Kumar
>
>
> Ax Dev <[EMAIL PROTECTED]> wrote:
> Hi Friends,
>
> There is a requirement of such a report form my client, that it needs to
> be
> directly open to Microsoft Excel sheet when we click on OK button when
> report interface opens.
>
> Is COM connection a good way to do so?
>
> Please suggest me how to do it?
>
> Thanks & Regards,
> Harsh
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
>
>
>
> SPONSORED LINKS
> Business finance course Business to business finance Small
> business finance Business finance consultant Business finance
> magazine Business finance schools
>
> ---------------------------------
> YAHOO! GROUPS LINKS
>
>
> Visit your group "Axapta-Knowledge-Village" 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.
>
>
> ---------------------------------
>
>
>
>
>
> Send instant messages to your online friends http://in.messenger.yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
> Yahoo! Groups Links
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" 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.
---------------------------------
Send instant messages to your online friends http://in.messenger.yahoo.com
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> 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/
