View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fredriksson Fredriksson is offline
external usenet poster
 
Posts: 1
Default Help using FileDialog with OpenText

I am trying to import a text file into a specific worksheet. Since the name
and location of the file changes every month, I am trying to use the
FileDialog method. After the user has selected the file, I would like to use
OpenText method to import the file. In the file, Columns 1 through 11 need
to be specified as type TEXT and Column 12 can be general. I am having a
having a hard time trying to understand the correct way writing the syntax
for the FieldInfo in the OpenText.

Any suggestions would be helpful.