Output To ....Stupid message

[captnk]

I am using the "output to method",in a Macro to export a table to an .xls file.

However even with warnings set to NO,the damned thing keeps asking me if I want to replace this file.

Is their anyway to get rid of this message as I dont want the programme waiting for input at this point
Thanx
Captnk

 

[ColinEssex]

Hi

Presumably the file you are exporting has the same name and the same destination each time.

You could delete the old file first before exporting the new one. Check out the "kill" statement in Access help.


Col

 

[captnk]

Output to message

Tks Col.
Yes i get that,but even so I dont see how I can automate the "kill" in the macro.
U can delete access files ,but i cant see how u can point it to an external file.

Thanks anyway

 

[ColinEssex]

The "kill" statement is designed to delete files from external sources.

You'll need to do some Vb code in a function, something like

Kill C:\DirectoryName\ExcelFile.xls (or whatever your path is)

Save the function and call it in a macro with the "RunCode" command.

It does work, I use it in one of my databases.

Col

 

[captnk]

Output to

Many tks Col.
Yes I converted the Macro to vb,and it works fine

Many thanks
Captnk