Send Object Output Format

T

Tom Ross

Hi.

I cannot figure out how to sepcify an Excel type file as output in the
sendobject action. I tried "Microsoft Excel" and "*.xls" but neither
worked. The help tells what options are available but not how to indicate
the type. Are there vb or ac constants?

Tom
 
R

Rick Brandt

Tom Ross said:
Hi.

I cannot figure out how to sepcify an Excel type file as output in the
sendobject action. I tried "Microsoft Excel" and "*.xls" but neither
worked. The help tells what options are available but not how to indicate
the type. Are there vb or ac constants?
Click to expand...

acFormatXLS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Send Object - Format Problem 0
Output to Excel 2
Encrypt Report sent by Macro action 0
Access 2007 and SendObject 1
Access 2007 xls format missing? 0
Export Query using Access 2007 to Excel 2003 Users 2
Export Query using Access 2007 to Excel 2003 Users 0
Macro syntax between Office 2003 and 2007 0

Top