Macro: OpenQuery--> OutputTo--> SAVE????

[silvershadow]

Hi all, my first post on the forum so please be gentle....

I've just started using Macros in Access today, I would like to run a specific query on a daily basis and then have it saved on the LAN in Excel?

So far I have managed to have the query automated (by using task scheduler), Output to Excel from here I need to browse to the LAN and manually save it? I would like to have this all automated?

Im using Microsoft 2003 on Windows XP

Can anybody help?

Any feedback would be much appreciated.

P.S. sorry if the question is'nt formated right

[silvershadow]

Anyone??

Can such a operation be performed?

[JConsulting]

Hi all, my first post on the forum so please be gentle....

I've just started using Macros in Access today, I would like to run a specific query on a daily basis and then have it saved on the LAN in Excel?

So far I have managed to have the query automated (by using task scheduler), Output to Excel from here I need to browse to the LAN and manually save it? I would like to have this all automated?

Im using Microsoft 2003 on Windows XP

Can anybody help?

Any feedback would be much appreciated.

P.S. sorry if the question is'nt formated right

It's kind of unclear what part of this you need help with. Seems there are two things you're looking for.

1) you can use the relative path to a network drive/file inside the macro
where it says FileName. Ex: \\myserver\myfo lder\myfile.xls

2) you can automate the macro from a shell command similar to this

----------------------------------------------------------------
you want to create a batch file.
open notepad
paste in the shell that applies to your environment
Example.
--------------------------------------
Echo off
"C:\Program Files\Microsoft Office\ART\Offi ce\MSACCESS.exe /User UserName /Pwd Password /Wrkgrp Z:\System.mdw" "Z:\Interface.m de" /X YourMacroHere
-----------------------------------------
the first part...your Access name and arguements. The second part, your DB path and file name. The third part, your macro name.
Now put this in the scheduler.
------------------------------------------------------------

J

[silvershadow]

Hi J,

Thanks for your reply.

I've managed to proceed a little further. I think i now have the macro saving but i get the following:



This is the bit where i want it automated and saved??

What now?

Thanks in advance!

[silvershadow]

Anyone???

Starting to give up on this now? ;o(

[JConsulting]

Anyone???

Starting to give up on this now? ;o(

check this link from microsoft

http://support.microso ft.com/default.aspx?sc id=kb;en-us;896865