Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import Data
I am creating a macro that imports data using;
Application.ScreenUpdating = False With Selection.QueryTable .Connection = _ "TEXT;C:\path\file." BackgroundQuery:=True Application.ScreenUpdating = True It works perfect except that I have to manually input the path and file name each time it runs i.e it stops and shows the input dialog box. I want it to do this automatically. It knows the path and file name, yet asks for it. As you can see I have used Application.ScreenUpdating = False and changed BackgroundQuery:= to True. Any ideas how to make this run w/o user input? Thanks for any help or suggestions. Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import XML data...Is there a size limit on the import? | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Import external data, data includes Excel function | Excel Worksheet Functions | |||
Prevent equation from skipping data when referencing import data? | Excel Discussion (Misc queries) | |||
how to Import data in excel office2003 with data more 65000 rows | Excel Worksheet Functions |