ActiveX Component can't create object ""Scripting.FileSystemObject""

[Anonymous]

Hi,

I've got this error (ActiveX Component can't create object ""Scripting.FileSystemObject"") when I lanch a macro to upload a file with a FTP.

The script is:

sub Upload

set vPath = ActiveDocument.Variables("vPathFile").GetContent

Dim FSO
Dim File
Set FSO = CreateObject("Scripting.FileSystemObject")
Set File = FSO.OpenTextFile("C:\temp.txt", 2, True)

File.WriteLine "open ***-ftp.*************"
File.WriteLine "user"
File.WriteLine "****"
File.WriteLine "*****"
File.WriteLine "cd qlikview/prodis"
File.WriteLine "PUT "& vPath.string
File.WriteLine "disconnect"
File.WriteLine "quit"

Dim shell
Set shell = CreateObject("WScript.Shell")
shell.Run "ftp -n -s:C:\temp.txt"

End Sub 

If i lanch this macro like this, there is no problem...

but if I change the path of the .txt file for example: * **

C:\Users\Public\Documents\temp.txt

I've got an error....

The problem is the users are not Adminstrateur of their computer, so they can't create a txt file in C:

that's why i want to change the path, like that...

I don't know why ActiveX can't create the object with this path wheras it works whith an other.

(My macro has system Access, it's not the problem)

Thanks

DUEZ Thomas

[marcus_sommer]

ActiveX settings belongs to the global security settings from windows and is for each user individual. If it worked for some user and for other user not - it will be these settings. I think you need therefor the help from the IT.

- Marcus

[#3 · Accepted solution]

Hi,

I too had same issue with Active X component. Can you please ask users to install IE plugin from Access Point and after successfull install ask users to open application and the press Ctrl+Shift+M and give system access to module script.

Let me know if any further info is required.

Regards,

Varsha

[marcus_sommer]

How Varsha Shashidharmentioned there are also the possibility for the user to forbid or limited the macro-execution. If Ctrl+Shift+M not worked you could also go (and change) to the settings.ini in C:\Users\UserName\AppData\Roaming\QlikTech\QlikView.

- Marcus

[Anonymous]

Ok it was finally a security problem....and Crtl+shift+M solve the problem...

Thank you very much...

But when users re-open the application, the Crtl+shit+M choice isn't save....they have to do this each time....

Is it normal?

If I change the settings.ini file as Marcus say, it will be better?

[#6]

Hi Thomas,

I don't think so its required each time. But if IE settings are cleared when browser is opened then you may have this problem.

Regards,

Varsha

[jerrysvensson]

Have a look at this thread

Re: Change Macro security to allow System Access

[#8]

Thanks Marcus, that was my issue. Something easy to overlook.