topic SV:Create object issue in QlikView

Create object issue

Mon, 18 Jan 2010 14:13:48 GMT

I am getting

ActiveX component can't create object: 'Excel.Application'

when i am executing below mentioned code thru macro, please help

Sub Browse_for_File
'------------------
' Get the file pathname
Set oXL=CreateObject("Excel.Application")
f_name=oXL.GetOpenFilename("All Files (*.*),*.*",,"Select file",False)
If f_name="False" then
'user cancelled out of dialog box
Set oXL=nothing
Exit sub
End If
'store file pathname in the file_pathname variable
ret=ActiveDocument.GetVariable("file_pathname").SetContent(f_name,false)
Set oXL=nothing
End Sub

thnaks

SV:Create object issue

Mon, 18 Jan 2010 14:36:20 GMT

Do you "Allow system access" on local macro security?

/Michael

SV:Create object issue

Mon, 18 Jan 2010 14:38:21 GMT

where can i find this setting

SV:Re: SV:Create object issue

Mon, 18 Jan 2010 14:42:44 GMT

Left hand side in the edit macro module.

/Michael

SV:Create object issue

Mon, 18 Jan 2010 14:59:49 GMT

i got it, thank you, its works fine

Regards