How would I create a macro that will open an .xls file on my "C" drive?
Thanks!
-Adam

Can anyone tell me if there is a way to output a query to an excel file in a
specific sheet from the macro page.
I have the query going to C:\directory\file.xls but this creates a new
workbook and I need to overwrite a specific sheet.  Wht is the format for

I am working on a db for work. I'm a therapist not an access programmer. What
I want to do is 1- create several reports OR output to word/excel, then 2-
have a single button to push that will print either the reports or word/excel
files.  These files MUST look like tables when ...

I have two macros I'll put in order below after I explain, can I join
them into one, or can I make another macro that runs the first, then
the second?  Each works fine, but second one loops, so combining them
is beyond me, unless there is a way to benchmark loops in code?

I have a client who is cyber-agoraphobic.  As a result he will not allow even
the possibility of macros in the database I am trying to send him.  Is there
a way to eliminate all macros from a database so that the warning will not
appear regardless of the security level setting?

I am trying to reference a bookmark name in Word 2002 from an Access macro.  
When I reference the .Name property I get "OLE_LINK1" as the name and not the
name of the bookmark.  I've read lots and can't seem to figure this one out.  
Here's my code.

Hi.  I have to say that this is the first time I have ventured into macros in
Microsoft Access so I am a complete beginner!!  I want to be able to run a
macro in a database file that imports two files via odbc from sage line 100.  
Where do I start??

Hi All Excel Pros
Can anyone tell me what is the function of  macro?
Tks

I am doing a Printer inventory and have two columns, type of cartridge and
the quantity. What I would like to do is when the quantity of each cartridge
goes below 3 when exiting, every time, a pop up warning “Inc is low for
cartridge X. Order more “shows up. So far I have it ...

This is a very basic question, and any help would be appreciated.  I have a
really good understanding of Access with the exception of Macros.  
I am attempting to create a macro which would take an entire population and
make it so it will only show a table where a field is equal ...

I would like to run an update query immediately after entering a record via a
form. The form has a 'save' button.
How can I create a macro to run the update query when I save the record entry?
thanks

I want to get my numbers in a cell a little farther away from the right
border. Putting a 1 in the indent box in the format cell dialogue box is too
much.  But it wont let me type a fraction or decimal 0.5.
Am I the only one in the universe that wants this?

I am a relative novice at VB.
I am currently trying to write a macro to compare two tables.
The tables have the exact same columns and I save the table once a month.
I want to be able to compare the new and the original databases.

A2003 split DB.
I am trying to create a macro in the FE.No problem selecting commands, but
when I Rt-Click to use the expression builder for conditions, I get "MS
Access has encountered a problem and needs to close....apologies for the

Here's what I've got, a 'call management' type database which has a
main form with the users information in it, then a sub form in list
view of all their service calls. We want to be able to double click on
the call number (ID ) and have it open that record in a separate form