| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Open the Menu Data,Refresh Data,filename,import
When recording a macro I am trying to open the Data Menu, select Refresh Data
a box opens you have to chose the file and Import. I want the code to have the file name so it will import automatically without having to choose the file each time. This is the code now: Selection.QueryTable.Refresh BackgroundQuery:=False How do I put what file opens every time? Thank you for your help, Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Data refresh problem | Excel Discussion (Misc queries) | |||
| Error on Refresh Data Import from Access | Excel Discussion (Misc queries) | |||
| Refresh Data Import Q | Excel Programming | |||
| How to import a path/filename when importing data into an XML list | Excel Worksheet Functions | |||
| Import Data with the filename coming from inputbox ? | Excel Programming | |||
Linear Mode
