View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Saucer Man Saucer Man is offline
external usenet poster
 
Posts: 54
Default 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!