MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Question about file opening

  Asked By: Nisha    Date: Feb 13    Category: MS Office    Views: 1716

I need to import a .txt file in the VBA I am writing now. I am
wondering is there any chance I could skip the text import wizard, but
yet use Tab as delimiter and import all fields as "text" instead of
integers? i.e., say I have a number 001234, is there any chance I
could import 001234 instead of 1234?



1 Answer Found

Answer #1    Answered By: Hadeel Khan     Answered On: Feb 13

You can import  a file  in Two ways.
a) Open the file in Excel and do a text  to columns. If
the file is in a proper structure.

b) The second method is by using #input method. If the
file. This uses the positional character.

Can you please provide some lines from the Text file,
I shall send you the code.

Didn't find what you were looking for? Find more on Question about file opening Or get search suggestion and latest updates.