Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Opening TXT/PRN Problem
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...- jake1016
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
Date/Time Between Excel and Access
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...- jake1016
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
Formating Excel using Query Data
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"))...- jake1016
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
