Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-07-26 05:04 AM

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

531 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2012-07-26 05:36 AM
Author

Hi Rupali,

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

245 Views
0 Likes
Not applicable
‎2012-07-26 05:46 AM
Author

In response to Anonymous

Yes I have found the solution.....

Thank You

245 Views
0 Likes
Anonymous
Not applicable
‎2012-07-26 05:51 AM
Author

In response to

No problem. It seems to be a quite common query

245 Views
0 Likes