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\myfolder\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\Office\MSACCESS.exe /User UserName /Pwd Password /Wrkgrp Z:\System.mdw" "Z:\Interface.mde" /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