topic Re: Set path and file name using macro in QlikView https://community.qlik.com/t5/QlikView/Set-path-and-file-name-using-macro/m-p/368885#M492016 <HTML><HEAD></HEAD><BODY><P>Yes I have found the solution.....</P><P>Thank You</P></BODY></HTML> Thu, 26 Jul 2012 09:46:34 GMT 2012-07-26T09:46:34Z Set path and file name using macro https://community.qlik.com/t5/QlikView/Set-path-and-file-name-using-macro/m-p/368883#M492014 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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???</P><P></P><P>regards,</P><P>Rupali</P></BODY></HTML> Thu, 26 Jul 2012 09:04:25 GMT https://community.qlik.com/t5/QlikView/Set-path-and-file-name-using-macro/m-p/368883#M492014 2012-07-26T09:04:25Z Re: Set path and file name using macro https://community.qlik.com/t5/QlikView/Set-path-and-file-name-using-macro/m-p/368884#M492015 <HTML><HEAD></HEAD><BODY><P>Hi Rupali,</P><P></P><P>Search the community for excel macro's and you'll find several examples that people have created to meet their export needs.</P></BODY></HTML> Thu, 26 Jul 2012 09:36:50 GMT https://community.qlik.com/t5/QlikView/Set-path-and-file-name-using-macro/m-p/368884#M492015 Anonymous 2012-07-26T09:36:50Z Re: Set path and file name using macro https://community.qlik.com/t5/QlikView/Set-path-and-file-name-using-macro/m-p/368885#M492016 <HTML><HEAD></HEAD><BODY><P>Yes I have found the solution.....</P><P>Thank You</P></BODY></HTML> Thu, 26 Jul 2012 09:46:34 GMT https://community.qlik.com/t5/QlikView/Set-path-and-file-name-using-macro/m-p/368885#M492016 2012-07-26T09:46:34Z Re: Set path and file name using macro https://community.qlik.com/t5/QlikView/Set-path-and-file-name-using-macro/m-p/368886#M492017 <HTML><HEAD></HEAD><BODY><P>No problem. It seems to be a quite common query</P></BODY></HTML> Thu, 26 Jul 2012 09:51:11 GMT https://community.qlik.com/t5/QlikView/Set-path-and-file-name-using-macro/m-p/368886#M492017 Anonymous 2012-07-26T09:51:11Z