topic Macro error for space in File Path and File Name in QlikView

Macro error for space in File Path and File Name

avastani — Tue, 17 Nov 2009 01:02:46 GMT

vbscript error Object required: '[string: Cha

I get the error above when trying to set the filepath to

dim fileName
set fileName = ActiveDocument.Evaluate("'\\servername\folder one\folder two\folderthree\my filename.txt'")

i even tried without the ActiveDocument and single quotes and still got the same error. Anyone encounter this issue before? thanks for your help.

Macro error for space in File Path and File Name

Miguel_Angel_Baeyens — Tue, 17 Nov 2009 02:32:46 GMT

Hi,

Have you tried escaping the backslash with a backslash? Someting like

\\\\servername\\folder one\\...

Macro error for space in File Path and File Name

avastani — Tue, 17 Nov 2009 02:58:49 GMT

tried that, didn't work. it is just hung on

Object required: '[string: "\\servername\\folder o"]'

Macro error for space in File Path and File Name

hector — Tue, 17 Nov 2009 03:43:13 GMT

but what are you trying to do? read this value to use in the macro editor? why are you using evaluate??

rgds

Macro error for space in File Path and File Name

hector — Tue, 17 Nov 2009 03:53:14 GMT

this works for what are you trying to do?

rgds

Macro error for space in File Path and File Name

avastani — Tue, 17 Nov 2009 04:39:54 GMT

not using Evaluate. i will take a look at your example

Macro error for space in File Path and File Name

Tue, 17 Nov 2009 07:34:13 GMT

Amir,

Looking at the code you've provided, I feel it important to note that the Evaluate method of ActiveDocument is intended as a means to evaluate an arbitrary Qlikview expression (i.e. Totals = ActiveDocument.Evaluate("Sum(Totals_Field)") ). You appear to be using it as a means to load a text file into Qlikview. The string you're passing to Evaluate isn't a valid Qlikview expression, which is why you are receiving the Object required error message.

Namely, the Set keyword in VBA is used to change an object reference to point to a given object. Since Evaluate returns the result of the expression evaluated as a String -which is not considered an Object by VBA- you get the error message you described.

I'm guessing that the following is what you're actually trying to achieve:


Dim fileName
fileName = "\\servername\folder one\folder two\folderthree\my filename.txt"

Since you aren't working with an object, there's no need to use the Set keyword.

Hope this helps!

-Alex

Macro error for space in File Path and File Name

avastani — Tue, 17 Nov 2009 08:33:18 GMT

Alex,

Very insightful if I may say and to continue further, that is the key to my misery with this Object required error.

Thanks.