| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing .csv file once daily leaves a data connection
I have a macro that imports a .csv file into Excel. This macro is run once
at night. I recently saw under Connections that each time we do an import, it leaves a connection. So after importing the file for 3 nights, we have 3 connections. I don't believe I need these connections to remain. Each night is a fresh import into different rows so we are not actually refreshing the previous connection. How can I prevent these connections from remaining after the import? -- Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing data from daily worksheets into my annual report | Excel Discussion (Misc queries) | |||
| Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
| sdf file supported as data connection in Excel 2007? | Excel Discussion (Misc queries) | |||
| Extracting data from text file that changes daily | Excel Programming | |||
| always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
Threaded Mode
