Error on read range workbook

There is an error appear stated “Statement cannot appear within a method body. end of method assumed.” after i put the datatable variable type in the output. This was fine last week. but dont know why suddenly today have this error.

@randa_prakasa

Can you please show what you have written in the field and also specify the datatypes of each variable used

cheers

may i know which field?
i am use DataTable variable as the output.

@randa_prakasa

the field which shows error

short_name etc

cheers

hi, @randa_prakasa

Looks like Studio is reading one of your fields as VB code instead of a simple value. Double‑check the sheet name expression and the DataTable field so it’s just your variable name.
If anything other than a pure expression/variable is there, this BC30289 error pops up.

error show in the field where we put the “Sheet Name”

@randa_prakasa

I understand that..but the error is coming because of the value you have in the sheetname field

so please show the complete value

better open expression editor and show the value and say the datatypes of each variable used in the field

cheers


its a string. everything completely fine last week. i just see this kind of error today

@randa_prakasa

its looks like one off issue

to make sure just add new activity and try

cheers

i try already and still show the same.. not sure why

@randa_prakasa

did you try giving a string only..is it still throwing same error?

also were there any upgrades in between?

cheers

Just clear value and type it again.. Verify the data type of Short_Name

If still you get issue, try creating a new variable with different and give it a try.