VBA refresh of query table not working

tombihn

New Member
Joined
May 7, 2012
Messages
2
I have a query table on a csv that was set to prompt for a file upon refresh. I decided I'd rather use a Form control with a Common Dialog control to gain better control of this process. It seemed pretty simple, I'd just disable the refresh in the Query properties and set the Connection to be

qt.Connection = "TEXT;" & strFullFilePath

...before I sent the refresh command. What happens is the file I select gets imported, but all the settings are lost. It shows as just one cell of text per line with no comma delimiter.

Is there a simple way to define the connection without stepping through all the parameters? What are the minimum parameters I need to specify for my comma-delimited file? All fields can be automatically assigned, I'd like to preserve formatting, and fill formulas down for adjacent cells.

Thanks in advance!
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Watch MrExcel Video

Forum statistics

Threads
1,108,649
Messages
5,524,067
Members
409,558
Latest member
MarkD018

This Week's Hot Topics

Top