delete excel file from access macro

[Guest]

I would like to delete an excel table from Access macro.
Has someone done this before?

 

[Jim/Chris]

I do not know a in macro but here is the code

Kill "c:\YourPath\YourFile.xls"

Jim

 

[Guest]

Thankyou Jim. It works in a macro too.

-----Original Message-----
I do not know a in macro but here is the code

Kill "c:\YourPath\YourFile.xls"

Jim


.

 

[Ken Snell]

Not in an ACCESS macro it won't. It works in ACCESS VBA code, which is not a
macro. (This differs from other Office products where macros mean VBA code;
in ACCESS, macros are a different animal from VBA.)

 

[Guest]

Thank you for the clarification Ken.

-----Original Message-----
Not in an ACCESS macro it won't. It works in ACCESS VBA code, which is not a
macro. (This differs from other Office products where macros mean VBA code;
in ACCESS, macros are a different animal from VBA.)

--

Ken Snell
<MS ACCESS MVP>




.