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, MicrosoftExcelBiff8(*.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