Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import Text Issues
Ok I've used the import external data feature to get a text file with all the
core data inserted into my workbook. Unlike the other posts, it's just the right size. My problem is I have to make this dummy proof for the user. The text file will always be the same name. In the same directory. On each computer. I need to automatically refresh the data without having the message window come up to select the file. When I record the macro it still gives me the option of selecting the file. I DON'T need these people having options like this. (I'm sure you can understand why). How do I disable the window and tell excel to refresh using the file? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Issues | Excel Worksheet Functions | |||
Text Issues | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Import External data Formatting issues | Excel Discussion (Misc queries) | |||
Export/Import + Copy issues | Excel Programming |