Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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