syntax opentext

[dk54]

hi guys.

I know this is probably super-basic, but could i get some help with this syntax?

Sub opentxt()

Dim filepath As String

filepath = "C:\Users\admin\Desktop"

workbooks.opentext (Sample,filepath, , xldelimited, ,,,,,true)


End Sub


I'm just trying to open a text file. Fields are separated by spaces.

I'm getting "compile error, expected ="

Cheers,
-dk

[AB33]

What is "sample"? I thought you start with filepath

[Norie]

This is the general syntax for OpenText:

Workbooks.OpenText(Filename, Origin, StartRow, DataType, TextQualifier, ConsecutiveDelimiter, Tab, Semicolon, Comma, Space, Other, OtherChar, FieldInfo, TextVisualLayout, DecimalSeparator, ThousandsSeparator, TrailingMinusNumbers, Local)