By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,763 Members | 1,641 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,763 IT Pros & Developers. It's quick & easy.

OutputTo Macro in Access 2003

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.