OutputTo Macro in Access 2003

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • paul.hanti@gmail.com

    #1

    OutputTo Macro in Access 2003

    This board has been a plethora of information. Thanks to all that
    respond!

    I have a quick question regarding the built-in OutputTo macro. I've
    built a shared database in Access 2003 (in Access 2000 file format)
    that resides on a shared network drive. This OutputTo macro is
    essentially setup to export one small table to an Excel spreadsheet
    once a user clicks a command button on the switchboard. Another user
    and I (both of us have 2003) have no problems with using this macro and
    it operates like it's supposed to, however when other users (users that
    are using Microsoft 2000) try to use this export functionality, they
    keep getting an error. The error pops up an "Action Failed" dialog box
    with the following information:

    Macro name (Save ProjList to Excel), Condition(True) , Action
    Name(OutputTo), and Arguments (0,ProjList, MicrosoftExcelB iff8(*.xls),
    , No,

    Does anyone know whether this OutputTo macro can be used in previous
    versions (even though it's saved in Access 2000 file format)?

    Thanks in advance,
    Paul

  • paul.hanti@gmail.com

    #2
    Re: OutputTo Macro in Access 2003

    Quick clarification on the following : (users that
    are using Microsoft 2000)...should' ve been Microsoft Access 2000.

    Comment

    Working...