Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create object issue

Hi

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



1 Solution

Accepted Solutions
Not applicable
Author

Hi

i got it, thank you, its works fine

Regards

View solution in original post

4 Replies
Not applicable
Author

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

/Michael

Not applicable
Author

where can i find this setting

Not applicable
Author

Left hand side in the edit macro module.

/Michael

Not applicable
Author

Hi

i got it, thank you, its works fine

Regards