[mso] Re: ACCESS 2002: Export Table To Excel Problems

Thanks Jim, this gets me farther, it opens the file in excel, which my
original file created by my code would not even open.  However, this new
code still takes a long time (3 1/2 minutes from start of export to opening
the document in excel vs. 6 seconds when you right click on the table and
manually export).

I'm wondering if there is something not configured right in my set up or
what is happening different when it's exported from both methods.  I have
learned the OS images they give us sometimes have things turned off for
various security/control issues, and I would not know what aspects of the
Access/XP/Excel interface to even look for to see if that aspect has been
turned off for us (does that make sense?).

Would the SetMenuItem function work in this situation and if so, how would
I set it up? I have never used it and don't know what it can/can't do - is
it worth testing? I got my original code by creating a macro, then
converting the macro to code on the form.  I am really grabbing at straws
here, as I don't know why there is such a discrepancy between 2 methods of
doing the same task.  Hope I'm explaining ok, thanks, Cathy


                                                                                
                       
                      "Jim Pettit"                                              
                       
                      <j_e_pettit@hotmail      To: <mso@xxxxxxxxxxxxx>          
                       
                      .com>                                                     
                       
                      Sent by:                 cc:                              
                       
                      mso-bounce@freelist                                       
                       
                      s.org                    Subject:  [mso] Re: ACCESS 2002: 
Export Table To Excel  
                      03/25/2004 11:50 AM         Problems                      
                       
                      Please respond to                                         
                       
                      mso                                                       
                 ..... 
                                                                                
                       
                                                                                
                       




Cathy--

You say you're running Access 2002? Try the following line instead and
se if it gives you what you want:

DoCmd.OutputTo acOutputTable, "MM_CL", acFormatXLS, "", True

(Of course, by leaving the 4th parameter -- filename -- blank, you'll be
prompted for a file save path and name. And the last two parameters can
be omitted, since you're using the default values anyway.)

--Jim





-----------------------------------------------------------------------------------------------------
The information transmitted is intended only for the person
or entity to which it is addressed and may contain confidential
and/or privileged material. If you are not the intended recipient 
of this message you are hereby notified that any use, review,
retransmission, dissemination, distribution, reproduction or any
action taken in reliance upon this message is prohibited. If you 
received this in error, please contact the sender and delete the 
material from any computer.  Any views expressed in this message
are those of the individual sender and may not necessarily reflect 
the views of the company.  
-------------------------------------------------------------------------------------------------------

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: