Using TransferSpreadsheet

[Guest]

I am using the TransferSpreadsheet via VBA to send a query to a directory for
a user to later use in Excel. The command may be used several times. The
query that is exported is always named the same thing. If the spreadsheet
already exists in the folder, I get "Can't expand named range" error. Not
what I was expecting. I had expected that the new version of the query
exported would simple replace the existing Excel file. That would be the
actin I would want. I can I make this happen?

Janie

 

[Alex Dybenko]

Hi,
you can delete existing spreadsheet before running TransferSpreadsheet:

if len(dir(strFileName))> 0 then
'file exists, delete it!
kill strFileName
end if

TransferSpreadsheet ...

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com