Excel Code Stage OpenText

MelanieWerner — Thu, 24 Oct 2019 09:35:00 GMT

Hi!

I want to open an Excel .xls Data with the Excel VBO "Open Workbook." But the Format for Numbers is not correct. So I can't keep working with the data.

So I added Open Text with origin to the "Open Workbook" stage code.

Here the Code Stage:

Dim wb as Object = GetInstance(handle).Workbooks.OpenText(filename, Origin:= ("1252"))
name = wb.Name
wb.Activate()

But I get this Error Message:

Internal : Could not execute code stage because exception thrown by code stage: Der öffentliche Member Name für den Typ Boolean wurde nicht gefunden.

But in the Background the xls open correct with the correct Format.

Can someone help me?

Thank you!

Kind Regards

------------------------------
Melanie
Accountant
------------------------------

topic Excel Code Stage OpenText in Product Forum

Excel Code Stage OpenText