[mso] Re: excel linking
- From: "Roy Crockett" <rcrockett2000@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 14 Mar 2003 12:18:56 -0500
I usually jump in at the wrong place but if all you want to do is send a
sheet from a workbook, I'd do it with VBA.
Make a temp file in the C: root C:\temp see the 9th line down. This
module uses the temp file and will not work without it. I put a smiley =
face
on the tool bar to click and send.... What ever sheet you have up when =
you
click the smiley face will be sent to the recipients... Be careful! :)
You can add recipients, just be sure to put them in quotes and use a =
coma to
separate. Roy
Sub SendThisSheetOnly()
'Roy Crockett 04/19/01
'Roy Crockett 09/15/01
'Roy Crockett 01/06/03 removed John Hoffman - retired
Dim strNewPathName As String
Dim arrRecipients As Variant
ActiveSheet.Copy 'copy the sheet to a new workbook
With ActiveWorkbook
.SaveAs ("c:\temp\" & ActiveSheet.Name & ".xls") 'save the new =
workbook
to the temp directory with the name you want to use when you send it.
strNewPathName =3D .FullName 'get the full path name of the new file
.SendMail Recipients:=3DArray("rcrockett2000@xxxxxxxxx",
"Roy.Crockett@xxxxxxxx") Subject:=3D"Data_Recovery Report for " &
ActiveSheet.Name 'send the new file
.Close (False) 'close the new file
End With
Kill strNewPathName 'delete the new file from the temp directory
End Sub
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx=20
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Errol Sapir
> Sent: Thursday, March 13, 2003 7:22 PM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] excel linking
>=20
>=20
> Hi All
> This is a rephrase of a prviously asked question. =20
> =20
> I have an Excel workbook composed of many worsheets. One=20
> worksheet is a list which gets revised periodically. I want=20
> to sent only this list to other people. Is there any way of=20
> attaching just this one page in an e-mail and not attaching=20
> the whole workbook?
> =20
> My contrived mind thought that if I made a seperate excel document
> (workrbook) of just this page and linked it to the original=20
> page I would use this new page as the e-mail attachment. This=20
> new page would be a copy of the original page so to speak and=20
> every time the original page was revised, the "copy" would=20
> also be revised. After thinking this out I realized I don't=20
> know (and can't find in all the help I used) a way to=20
> permanently link two pages so that ANY change I make in one=20
> page happens to the other linked page.
> =20
> I hope my problem is clearer now.
> =20
>=20
>=20
> *************************************************************
> You are receiving this mail because you subscribed to=20
> mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx
>=20
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>=20
> To Unsubscribe from this group, send an email to=20
> mso-request@xxxxxxxxxxxxx with the word "unsubscribe"=20
> (without the quotes) in the subject line.
>=20
> Or, visit the group's homepage and use the dropdown menu. =20
> This will also allow you to change your email settings to=20
> digest or vacation (no mail). //www.freelists.org/webpage/mso
>=20
> To be able to use the files section for sharing files with=20
> the group, send a request to mso-moderators@xxxxxxxxxxxxx and=20
> you will be sent an invitation with instructions. Once you=20
> are a member of the files group, you can go here to=20
> upload/download files: http://www.smartgroups.com/vault/msofiles
> *************************************************************
>=20
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
