Hello,
I am writing a mocro that needs to open three
different .csv files in excel from an online database.
I am using...
Workbooks.Open Filename:= _
"http://srmwww.gov.bc.ca:8000/pls/aqiis/get_qa_arc
hive.csv?station_id=E231866&days=10&parameter=CH4"

it opens as "get_qa_archive.csv [Read-Only]"

Later, this file is closed and I try to open the next one.
Workbooks.Open Filename:= _
"http://srmwww.gov.bc.ca:8000/pls/aqiis/get_qa_arc
hive.csv?station_id=E231866&days=10&parameter=NMHC "

Here I get an error, since it always tries to open these
files as "get_qa_archive.csv [Read-Only]" and it either
thinks the old file is still in use, or it is trying to
save it to temporary memory under the same name.

Does anyone know of a way around this?