Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Email an MS Access object as a PASSWORD PROTECTED Excel file

Status
Not open for further replies.
PrasadTummala

PrasadTummala

Programmer
Mar 15, 2003
1
AU

Hi

In MS Access-2000, using a SendObject command, we can Email the Access objects (say a report) in a variety of formats, such as Word, Excel, CSV format etc.

I want to Email an Access object, using SendObject or any other command, as a password protected Excel spread sheet. Any ideas on how to do this in Access-2000 using VBA?

Regards

Prasad
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
1K
remeng
remeng
Andrzejek
  • Question
Open Word as ReadOnly 1
Replies
6
Views
326
Chriss Miller
C
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
394
strongm
strongm
feipezi
  • Locked
  • Question
How to pull data from MS Access DB and place on an Excel spreadsheet with WHERE clause? 2
Replies
10
Views
514
feipezi
feipezi
K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
612
combo
combo

Part and Inventory Search

Sponsor

Back
Top