Delete Excel File- Possible?

[RAxel]

I'm using VBA to export a make-table query to excel, always to the same location (say C:\).

Before I export the table to excel, can I first delete the file that's already there (always the same name)? I thought I read somewhere about a 'Kill' statement but I haven't had any luck finding that code.

Thanks.

 

[PHV]

Something like this ?
strPath = "C:\path\to\workbook.xls"
If Dir(strPath) <> "" Then Kill strPath

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RAxel]

Works great, thanks.

 

[RAxel]

Can the excel file be automatically opened after exporting it from access?

 

[ZmrAbdulla]

if you are using OutputTo then set AutoStrat =True

DoCmd.OutputTo acOutputTable, "ObjectName", acFormatXLS, "C:\FileName.xls", [b]True[/b]

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials