Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set path and file name using macro

Hi,

        I am trying to copy a tablebox to excel sheets using macro. I want to set a default path as well as name for the excel sheets in the macro so that a .xls file is created at the same location. I am doing all this using CopyToClipBoard and paste options in VB. I dont want to use the export option of textbox. Can anybody suggest me something???

regards,

Rupali

3 Replies
jsn
Honored Contributor

Re: Set path and file name using macro

Hi Rupali,

Search the community for excel macro's and you'll find several examples that people have created to meet their export needs.

Not applicable

Re: Set path and file name using macro

Yes I have found the solution.....

Thank You

jsn
Honored Contributor

Re: Set path and file name using macro

No problem. It seems to be a quite common query

Community Browser