menubar & outputTo macro

[rew]

Hi, i've a menubar with a "direct link" to an outputTo macro (exporting a query to an excel file)..in the "admin" mode is working..but in user mode when i click on it i've this message



my db is not read only (or i think so..where can i find this?) and is not unconverted from an earlier version of access, ...

after clicking on the OK i've this window



I mean, is it possible to run a macro directly from a menubar without passing through something else (form, whatever, ...) ??

thx in advance

bye

 

[rew]

i think i've found the problem..

the query is not loaded, so the outputTo cannot find it..
is there a possibility to run the query without showing the preview (or datasheet, or pivot chart, ...) ?? ..i mean something "hide"..

 

[boblarson]

Instead of OutputTo, use the TransferSpreadsheet Action.

 

[rew]

Instead of OutputTo, use the TransferSpreadsheet Action.

thx it works, i didn't use this 'cause i thought it would have worked only with a table..but it works even with query!
thx again