Compilation error 1033

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
UncleBen
Newbie
Posts: 6
Joined: Thu Oct 02, 2014 12:22 pm

Compilation error 1033

Post by UncleBen » Mon Dec 22, 2014 8:11 am

Hello!

I've got an issue.

Code: Select all

    ReadFile>%find_Var_1%,vData
    Separate>vData,lf,vLine
    let>n=1
    Repeat>n
      Let>text=vLine_%n%
      StringReplace>%text%,","",text
      StringReplace>%text%,crlf,lf,text
      VBEval>LCase("%text%"),text       <--- after this line Macro Scheduler is showing that error.
      Position>%find_Var_2%,%text%,0,nPos,TRUE
       [...]
     Until>n,vLine_Count
any ideas? :?

User avatar
Marcus Tettmar
Site Admin
Posts: 7391
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Re: Compilation error 1033

Post by Marcus Tettmar » Mon Dec 22, 2014 10:30 am

It's probably the line feeds. This line won't help:

StringReplace>%text%,crlf,lf,text

The LF will confuse VBScript because the line wrap will unterminate the string.

Replace with VBScript's line feed tokens instead:

StringReplace>text,CRLF," & vbCRLF & ",text

Also note uppercase CRLF.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts