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!

Without seeing your code its hard to say.

"Saucer Man" wrote:

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!

Here it is without the declares...

'Set rng = Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
'With
ActiveSheet.QueryTables.Add(Connection:="TEXT;\\Da ta-store\UPS_CSV_EXPORT.csv",
Destination:=rng)
' .Name = "UPS_CSV_EXPORT"
' .FieldNames = True
' .RowNumbers = False
' .FillAdjacentFormulas = False
' .PreserveFormatting = True
' .RefreshOnFileOpen = False
' .RefreshStyle = xlInsertDeleteCells
' .SavePassword = False
' .SaveData = True
' .AdjustColumnWidth = False
' .RefreshPeriod = 0
' .TextFilePromptOnRefresh = False
' .TextFilePlatform = 437
' .TextFileStartRow = 1
' .TextFileParseType = xlDelimited
' .TextFileTextQualifier = xlTextQualifierDoubleQuote
' .TextFileConsecutiveDelimiter = False
' .TextFileTabDelimiter = False
' .TextFileSemicolonDelimiter = False
' .TextFileCommaDelimiter = True
' .TextFileSpaceDelimiter = False
' .TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1)
' .TextFileTrailingMinusNumbers = True
' .Refresh BackgroundQuery:=False
'End With
'Set rng = Nothing

"Mike" wrote in message
...
Without seeing your code its hard to say.

"Saucer Man" wrote:

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!

I tried adding...

ActiveWorkbook.Connections("UPS_CSV_EXPORT").Delet e

and the connection is gone when viewed in the connections screen in Excel
2007. However, the next time I open the Excel document, the connection is
back again.

Also, the connections created when we run the macro daily are building up.
There is

UPS_CSV_EXPORT1
UPS_CSV_EXPORT2
UPS_CSV_EXPORT3
UPS_CSV_EXPORT4
UPS_CSV_EXPORT5
UPS_CSV_EXPORT6

Even removing these with the Connections dialog in Excel 2007 is only
temporary. They come back when we open the document the next time.



"Saucer Man" wrote in message
...
Here it is without the declares...

'Set rng = Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
'With
ActiveSheet.QueryTables.Add(Connection:="TEXT;\\Da ta-store\UPS_CSV_EXPORT.csv",
Destination:=rng)
' .Name = "UPS_CSV_EXPORT"
' .FieldNames = True
' .RowNumbers = False
' .FillAdjacentFormulas = False
' .PreserveFormatting = True
' .RefreshOnFileOpen = False
' .RefreshStyle = xlInsertDeleteCells
' .SavePassword = False
' .SaveData = True
' .AdjustColumnWidth = False
' .RefreshPeriod = 0
' .TextFilePromptOnRefresh = False
' .TextFilePlatform = 437
' .TextFileStartRow = 1
' .TextFileParseType = xlDelimited
' .TextFileTextQualifier = xlTextQualifierDoubleQuote
' .TextFileConsecutiveDelimiter = False
' .TextFileTabDelimiter = False
' .TextFileSemicolonDelimiter = False
' .TextFileCommaDelimiter = True
' .TextFileSpaceDelimiter = False
' .TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1)
' .TextFileTrailingMinusNumbers = True
' .Refresh BackgroundQuery:=False
'End With
'Set rng = Nothing

"Mike" wrote in message
...
Without seeing your code its hard to say.

"Saucer Man" wrote:

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!