Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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?
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
Have a look at this thread
Thanks Marcus, that was my issue. Something easy to overlook.