Search results for query: *

Hi, I was wondering if you ever got this to work. I have the same problem.

Skip, you are correct about the settings but unchecking the boxes makes no difference. I do use the IMPORT sometimes but I've got a number of macros that use TextToColumns assuming that all of the data is in one column. I'm just lazy about recreating them to use IMPORT. I guess that's what I...

Excel 2003 SP3 Windows XP Professional SP2 I'm having a problem that I'm not sure belongs directed to this group so let me know where to send it if necessary. My problem is when I open a PRN or TXT file using Excel. In the past couple of months it reacts differently than it used to: Excel...

I have some data that is available to me in Excel that I want to store in Access. One of the data elements is a race time that looks like this in Excel: 01:56.1 (indicating that the time of the race was 1 min 56 sec and 1/5 sec). To get it to display like this I format the cell like this...

This may not be exactly what you need but it might be something you could use. In essence it is picking off all files in MyDir that are .TXT types and in this case I'm just putting the names into the current Excel column but within the IF statement you could do anything you want while the file...

Hi, I'm trying to get data from a web site and load it into an Excel spreadsheet. Here is the query I'm using: Public Sub Test1() myLink = ActiveCell.Hyperlinks(1).Address With ActiveSheet.QueryTables.Add(Connection:="url;" & myLink, _ Destination:=Range("a1"))...