Help with VBScript - Copy File

pkelly — Wed, 08 Jun 2011 09:57:46 GMT

Hi All...

As part of my QlikView report VBScript, I copy the PDF file created by PDF-Xchange to a new file.

The location of this file varies based on the user...

Examples of the variables used are...

emailOutput = \\ukts2k3r2ss1\users$\pkelly\Documents\QlikView Printing.pdf

emailAttachment = \\ukts2k3r2ss1\users$\pkelly\Documents\TS10.pdf

When the user clicks the button to output the pdf, I set thses variables - this works okay.

Within my VBScript I want to use these variables...

I have created a vraiable within my script called vo (Output) and va (Attachment).

I pick up the values using...

set vo = ActiveDocument.Variables("emailOutput")

The issue that I am having is with the following section of my script...

objFSO.CopyFile vo , va

I get the following error...

Type mismatch: 'objFSO.CopyFile'

Any assistance greatly appreciated....

Regards

Paul

Wed, 08 Jun 2011 10:06:28 GMT

hi Paul, try

vo = ActiveDocument.Variables("emailOutput").GetContent.String

pkelly — Wed, 08 Jun 2011 12:46:50 GMT

Thanks Alex - spot on...

topic Help with VBScript - Copy File in QlikView