topic Re: open excel file in qlikview using macros in QlikView

open excel file in qlikview using macros

Anonymous — Thu, 08 Oct 2015 06:35:48 GMT

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 — Thu, 08 Oct 2015 06:40:37 GMT

Check with this settings

Vikas

Anonymous — Thu, 08 Oct 2015 06:51:14 GMT

Instead of path i can use a variable?

vikasmahajan — Thu, 08 Oct 2015 06:55:54 GMT

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 — Thu, 08 Oct 2015 06:56:39 GMT

instead of fname use vQVFile

Anonymous — Thu, 08 Oct 2015 07:13:13 GMT

i just have file name in the variable not entire path

Anonymous — Thu, 08 Oct 2015 08:08:51 GMT

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 — Thu, 08 Oct 2015 10:06:43 GMT

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

Vikas

Anonymous — Thu, 08 Oct 2015 10:08:30 GMT

Thank you..