topic Re: Set path in QlikView

Set path

smilingjohn — Thu, 05 Mar 2015 10:33:50 GMT

Hi iam using a macro to export from excel

how do i set the path for that perticular excel file

can some one tell me ?

what is the command to set the path ?

and also i want to know how do we rename the workbook

whwenever i export it pops like worboo1 , workboo2

i want to rename this work book also

Re: Set path

simospa — Thu, 05 Mar 2015 10:36:19 GMT

Hi,

try to post a snippet.

Re: Set path

smilingjohn — Thu, 05 Mar 2015 10:44:24 GMT

HI Simone Spanio

Plz find the attachment now tell me where do i mention the path here

Re: Set path

simospa — Thu, 05 Mar 2015 11:04:53 GMT

Hi,

try this:

Sub sendToExcel

'Set the path where the excel will be saved

filePath = "F:\myFile.xls"

Set excelFile = CreateObject("Excel.Application")

excelFile.Visible = true

Set myWorkBook = excelFile.WorkBooks.Add

Set mySheet = myWorkBook.WorkSheets(1)

Set tableToExport = ActiveDocument.GetSheetObject("CH01")

Set chartProperties = tableToExport.GetProperties

tableToExport.CopyTableToClipboard true

excelFile.Visible = true

myWorkBook.SaveAs filePath

myWorkBook.Close

excelFile.Quit

Set myWorkBook = nothing

Set excelFile = nothing

End Sub

Let me know if it works.

Re: Set path

simospa — Thu, 05 Mar 2015 12:48:39 GMT

John,

did it solve your problem?

Re: Set path

smilingjohn — Fri, 06 Mar 2015 04:28:05 GMT

HI John I tried but its not working

Iam attaching the script in a word document can u please add the file path to the scrip ,

i want to save it into D:\Export\

Re: Set path

Fri, 06 Mar 2015 05:23:16 GMT

Hi John,

refer this link , it may help you.

Regards,

Rajendra

Re: Set path

smilingjohn — Fri, 06 Mar 2015 06:33:44 GMT

Guys i have already posted my code just can some one add there path . I dont know how do we add the path

Re: Set path

simospa — Fri, 06 Mar 2015 07:50:13 GMT

John,

we gave you all the informations to do this.

In your script, insert yourself where you prefer to define your path the string

filePath = "F:\myFile.xls" 'your path

and, in your export to excel sub, after your

.CopyTableToClipboard true

XLSheet.paste

insert string

XLDoc.SaveAs filePath

Follow this trace,

Re: Set path

smilingjohn — Fri, 06 Mar 2015 10:34:17 GMT

Thanks simone.spanio