[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Invoking a Excel Macro SQR?
- Subject: Re: [sqr-users] Invoking a Excel Macro SQR?
- From: Deb Harris <dhjdharris@sbcglobal.net>
- Date: Mon, 29 Aug 2005 06:08:47 -0700 (PDT)
- Delivery-date: Mon, 29 Aug 2005 08:09:56 -0500
- In-reply-to: <20050828033140.80763.qmail@web54108.mail.yahoo.com>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Basicly I need to have the report output go into an excel file in addition to
HTML & PDF outputs. Just outputing the report to a csv file, using the
parameter flags, just places the information in the first column as text. The
macro would need to parse out the information into separate columns. Is there
a better way of doing this?
Dattatraya Shetty <datta_shetty@yahoo.com> wrote:
Its possible. But what is that you want to do ? Create a template
spreadsheet and call it ?. or the spreadsheet is going to change
everytime sqr runs ?
The simple thing to do is use thisworkbook.open method in Excel macro
to invoke the rest of the VBA code and use system command to open the
EXCEL Spreadsheet. Let me know if this make sense.
Thanks,
Datta.
--- Prasanna Menta
wrote:
>
> We are interested too to know if there is a possibility to invoke a
> word macro from sqr? any code samples is appreciated.
> Prasanna
>
> ----- Original Message -----
> From: Deb Harris
> Date: Friday, August 26, 2005 10:56 pm
> Subject: [sqr-users] Invoking a Excel Macro SQR?
>
> > Is there a way to create and invoke an Excel Macro from SQR?
> >
> > Any help would be greatly appreciated.
> >
> > Thanks
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> >
>
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users