Excel app.Workbooks.OpenText - interface?

General
1

Friends: need to access Excel VBA command app.Workbooks.OpenText from Xojo. It is not in Dakin’s “Program Excel 2016
with Xojo in Windows”.
Have tried this. It compiles, but does not work:
xlapp.Workbooks.OpenText (filestring, xlWindows, 1, xlDelimited, xlDoublequote, False, True, False, False, False, False, vbTab, Array(1, 1), False, “.”, “,”)

2

Hi Mike,

I was able to get it working on my computer with most of the commands that were added with a text file called ExampleText.txt. Here are the contents of the text file:

This is new text stuff in a file

Maybe try the following code to start?

[code]Dim excel as new ExcelApplication
excel.Visible = True

excel.Workbooks.OpenText(“C:\Users\Owner\Desktop\ew\ExcelOpenText\ExampleText.txt”, Office.xlWindows, 1, Office.xlDelimited, Office.xlTextQualifierDoubleQuote, False, True, False, False, False, False, chr(9)))[/code]

3

Yes, it works !!! Thanks, Eugene :slight_smile:

Your book has helped me greatly converting VBA from VB6 to Xojo.

Now, if only the Xojo debugger would stop crashing or “Cannot connect to the debugger …”, the debugging would be much faster ;-(