open excel file in qlikview using macros

[Anonymous]

Hi,

This is a script am using to open excel file within application but it is not working please help to solve this

Sub Close()

set XLApp = CreateObject("Excel.Application")

fname="D:\Jeld-wen-new-requirements\Excels\ZSD008OA.xlsx"

set XLDOC = XLApp.Workbooks.Open(fname)

XLApp.Visible = True

end sub

[vikasmahajan]

Check with this settings

Vikas

[Anonymous]

Instead of path i can use a variable?

[vikasmahajan]

yes defile in script

SET vQVFile = 'D:\Jeld-wen-new-requirements\Excels\ZSD008OA.xlsx';

Sub Close()

set XLApp = CreateObject("Excel.Application")

set XLDOC = XLApp.Workbooks.Open($(fname))

XLApp.Visible = True

end sub

[vikasmahajan]

instead of fname use vQVFile

[Anonymous]

i just have file name in the variable not entire path

[Anonymous]

I need to use variable in that file name is stored path is same for all file name changes according to the client selection

Sub Close()

set XLApp = CreateObject("Excel.Application")

fname="D:\Jeld-wen-new-requirements\Excels\$(Variable)"

set XLDOC = XLApp.Workbooks.Open(fname)

XLApp.Visible = True

end sub

[vikasmahajan]

Better you take file name in input box assign this to variable and use this variable in macro.

Vikas

[Anonymous]

Thank you..