Workbooks.OpenText Error "Expected function or variable"

Question

Why does my code below not work? It highlights the .OpenText part and states:

Expected function or variable

Dim Indata As Excel.Workbook

Set Indata = Workbooks.OpenText(Filename:="C:\Users\thePunter\Desktop\Count_Types_062016.txt", DataType:=xlDelimited, Tab:=True)

mrbungle · Accepted Answer · 2016-06-21 21:40:37Z

7

You're trying to set the workbook variable while using the OpenText method but OpenText doesn't return a workbook reference. Do this instead

Dim Indata As Excel.Workbook
 Workbooks.OpenText(Filename:="C:\Users\thePunter\Desktop\Count_Types_062016.txt", DataType:=xlDelimited, Tab:=True)
Set Indata = ActiveWorkBook

answered Jun 21, 2016 at 21:40

mrbungle

1,9391 gold badge16 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

HackSlash Over a year ago

I hate that this is the answer. It should just return a workbook.

Sgdva · Accepted Answer · 2016-06-21 21:45:59Z

0

This should fix it -odd enough though-

'...
Dim Indata As Excel.Workbook
Call Workbooks.OpenText(Filename:="C:\Users\thePunter\Desktop\Count_Types_062016.txt", DataType:=xlDelimited, Tab:=True)
Set Indata = ActiveWorkbook
Indata.Close False
'...

However, while working with csv and txt files, I find highly effective the EOF command.

answered Jun 21, 2016 at 21:45

Sgdva

2,8103 gold badges19 silver badges31 bronze badges

2 Comments

thePunter Over a year ago

Thank you, All. I will give them all a try.

Sgdva Over a year ago

Please, check the green mark once an answer has fulfilled your answer and most importantly, try them, most of the users here won't be able to help if you "suddenly" (a week, a month after) change your original requirements or ask for new ones.

Collectives™ on Stack Overflow

Workbooks.OpenText Error "Expected function or variable"

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related