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

Send Object with No Col Headings

P: n/a
I have an application that sends a query by e-mail in Excel format using
a DoCmd.SendObject statement in VBA. I need to delete the column
headings now before I send it. Help appreciated. Thanks.
Steve

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
This may be harder than In thought. I'm thinking that I need to
re-engineer to go into an excel file that has been created with
TransferSpreadsheet and use VBA to delete the first row then figure out
a way to send as a e-mail attachment. If that is my only hope, a code
snip example for deleting the row would be greatly appreciated. Thanks.
Steve
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #2

P: n/a
Ray
Steve Bishop <st****@viper.com> wrote in message news:<40*********************@news.frii.net>...
I have an application that sends a query by e-mail in Excel format using
a DoCmd.SendObject statement in VBA. I need to delete the column
headings now before I send it. Help appreciated. Thanks.
Steve

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Hello Steve,

Perhaps you could look at what you need from
another point of view.

Create a new form and select "Insert" to insert the
exported Excel file. Select the "Create From File"
choice, go to browse, and select the XLS file you
need. Make sure you select the "Link" check box
BEFORE selecting "OK".

This will create a link to the Excel file which is
viewed in the form. Now, right click on the new object
and select properties if your properties menu isn't displayed
currently. Select the "Data" tab and change the "Enabled"
property from NO to YES.

Now, save the form and open it. Double click on the Excel
object which will open the file, from the form, in Excel
which then can be edited by removing the first row. Select
save after removing the first row and close the Excel window
that popped up.

Now you can go from there to email your file. The purpose
of this is to edit the Excel file each time it's exported
from Access and made new.

Hope this starts you on another way to deal with the problem.

Regards,

Ray
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.