topic Re: Macros in QlikView

Macros

Mon, 04 May 2015 18:41:42 GMT

Hi ,

it's Very aurgent and important plzzz

i am having one straight table .client want to see that by email,and also in in excel ,means i should do it as export to excel.

i dont have any idea about Macros plzzz guide me step by step plzz i would be grate thank full to you plz.

Re: Macros

petter — Mon, 04 May 2015 19:22:38 GMT

If you want to do it from QlikView Desktop this attached QVW will show you how to do it with at Macro and invoking PowerShell in Windows to perform a Send-MailMessage. This presumes that you use an SMTP server that does not require for you to use a username and password. By changing the parameters for Send-MailMessage you can accomodate user/password too....

Re: Macros

Mon, 04 May 2015 19:34:51 GMT

thanks for your response petter,

i opened the qvd.there is chart and from address ok.and Macros code but step by step implementation i am missing

Re: Macros

petter — Mon, 04 May 2015 19:50:04 GMT

1) Create a new sheet object: BUTTON

2) Add two ACTIONS to this object:

* Action Type: External

Action: Run Macro, Macro Name: SaveAsExcelAndMail

* Action Type: External

Action: Launch

Application: CLICK BROWSE

and find powershell.exe in c\windows\system32\windowspowershell\v.10\

Parameters:

='Send-MailMessage -To ' & To & ' -From ' & From & ' -Subject ' & Subject & ' -Body ' & Body

& ' -SmtpServer ' & [SMTP server] & ' -Attachments ' & [Attachement Filename]

3) In the Tool / Edit Module enter this Macro code:

Sub SaveAsExcelAndMail

Set Obj = ActiveDocument.GetSheetObject("CH01")

Obj.ExportBiff "<your-complete-filename>.xls"

End Sub

When you are in Edit Module you have to select in the two drop-downs on the left:

- Requested Module Security: System Access

- Current Local Security: Allow System Access

Re: Macros

Tue, 05 May 2015 00:57:01 GMT

Hi Peater Thanks For Your Grate Efforts.

='Send-MailMessage -To ' & To & ' -From ' & From & ' -Subject ' & Subject & ' -Body ' & Body

& ' -SmtpServer ' & [SMTP server] & ' -Attachments ' & [Attachement Filename]

getting some errore in this part

Re: Macros

Tue, 05 May 2015 01:24:25 GMT

While Pasting Macros Code Errore Plz Help

Re: Macros

petter — Tue, 05 May 2015 04:52:57 GMT

Do you have a Chart Object with an ID of CH01?

The first line of the Macro code tries to get a reference to a chart object with this ID. If it is not found it will assign null to Obj. Then the second line will give the error you got...

So you will have to create a Sheet Object that can be exported as an Excel Workbook and give it tge ID of CH01 or change the code to refer to CH02 or CH06 or whatever the ID is of the object you want to export and mail...