Hi, I'm new here!
Sorry for my english.
I have a problem. I'm trying to transfer data from Access to Excel.
And after that process, in virtual memory the Excel still remains.

How can I open an excel file from Access?
What is the code syntax?
Thanks in advance

I need to automate the process of updating and analyzing access data in
excel to produce reports. Is a macro the way to go and does anyone know
where I can find some examples? Or is there a better way?
Thanks

There's a really simple answer for this, I'm sure.
When I go to edit a macro, I do not have a conditional column.  I can't find where to "turn it on" in the help.  Please help me solve my bonehead problem
Nick

How do I open a form in another database that I have nothing linked to.
I have tried RunApp but it only opens the other database and not th
specific form I need.  Thanks
-----------------------------------------------

Hi everyone. Ignorant newbie question here
What I want to do is to fill a table - called date_table (only one relevant field: report_date) with an entry for every day of the year. This has to be done by my client, who knows nothing at all about computers, so I thought I'd give her ...

Help me if you can. Now I believe there is a way this can be done. I
have a table Called Customer with all of the customer info. What I
need to happen is to have a macro create a sub-table with the customer
lastname as the table name to have all of their billing history. Is

Hi Al
I hope someone can help me
I have created a batch file that renames a long character name with an unassociated program attached to it to a short name.txt file.  As we are an educational environment these files will always be created in this unrecognisable format and we will ...

I created an access database that its vba references to
the library Microsoft Excel 9.0 Object Library.  The
problem I am having is that when other co-workers open
the database they get an error message:

I am trying to link a table in MS SQL database to MS
Access database using the macro.
I get the error maessage " could not find installable ISAM"
Why do I get this message? I am using MS Office 2000.

I would like to append records to an existing table from
an imported excel spreadsheet.
I found the macro Action "Transfer Spreadsheet" all
right, but I am not sure how to append these records from

I'm looking for code that I can insert into any vb event handler and i
would catch all errors and store relevent info in a table for late
viewing. Does anyone know where I can find it
-----------------------------------------------

I am trying open an excel spreadsheet from access vba and
run the excel's macro, but I get on error on the part of
running the macro.  Currently I have:
...

Is there a way to use a wild card in the record source
for forms/reports.  for example  have the record source
be '*SM' meaning as long as the table ends in 'SM' then
use it?

I have a customer form with a subform containing orders,
and I have a button that runs a macro that simply opens,
prints and closes a form which give me info on that
customers order.