Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import data without query
I am a newbie here in the VBA world...could use a little help:
I'm trying to create a macro which imports data from a text file into a specific worksheet on the workbook I have open...with specific delimited perameters. I tried recording a macro but the only way that I know how to do it is by simply opening the file which creates a whole new workbook. I finally came up with something on my personal computer which creates a query, and when I tried it on my computer at work it didn't work because the query is not installed. Is there a way to do this without creating a query? Also I realized that when the document is opened in excel, it is still the original file...I want to copy the data because there is a lot that needs to be done with the information without disrupting the txt file. I've come so close with a few different code's but now I'm stumped... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tool bar: Data/Import external data/New database query | Setting up and Configuration of Excel | |||
Customize Query in Data Import | Excel Discussion (Misc queries) | |||
Import Data -- External Web Query | Excel Worksheet Functions | |||
Import External Data/New WEB Query | Excel Discussion (Misc queries) | |||
new web query ( import data ) | Excel Discussion (Misc queries) |