Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you "Allow system access" on local macro security?
/Michael
where can i find this setting
Left hand side in the edit macro module.
/Michael
Hi
i got it, thank you, its works fine
Regards