By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,931 Members | 1,247 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,931 IT Pros & Developers. It's quick & easy.

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

P: 5
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
Sep 13 '07 #1
Share this Question
Share on Google+
5 Replies


P: 5
Anyone??

Can such a operation be performed?
Sep 13 '07 #2

JConsulting
Expert 100+
P: 603
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
Sep 14 '07 #3

P: 5
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!
Sep 14 '07 #4

P: 5
Anyone???

Starting to give up on this now? ;o(
Sep 14 '07 #5

JConsulting
Expert 100+
P: 603
Anyone???

Starting to give up on this now? ;o(
check this link from microsoft

http://support.microsoft.com/default.aspx?scid=kb;en-us;896865
Sep 14 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.