"do you want to update external data" message

  • Thread starter Thread starter BdgBill
  • Start date Start date
B

BdgBill

I have a large workbook containing about 30 sheets. I have created a
summary sheet that contains data collected in various ways from all the
other sheets.

I would like to be able to export (copy) this sheet and be able to
e-mail it out without all the underlying data. The sheet looks OK when
i send it out but the "do you want to update external data ?" message
freeks some people out. How do I get rid f this box?

Also I have written a macro which works with conditional formatting to
highlight scores at different levels. How do I send the macro along
with the sheet?
Im using Excel 2000.

Thanks for any help you can provide.
 
Take a look at Ron De Bruins sendmail addin for doing exactly that, and a whole
lot more in the way of options:-

http://www.rondebruin.nl/sendmail.htm

Look for the 'Free Addins' link at the bottom of the list

As far as the macro goes, then it needs to be in the workbook if you want to
send it with it - Can't remember off the top of my head how Ron's addin handles
that though - Ron??
 
Hi BdgBill / Ken

You can make values from your formulas in the Add-in
If you want to send the code also then you can add a button
from the control toolbox on your sheet and place the code in the click event.

Both Add-ins send the code then if you send the with the option "Send ActiveSheet" or Sheets.

If you have the code in a normal module then You must use the Outlook Add-in(3.1)
this have a option of "Workbook Special".
You send the whole workbook with the sheets you want then

I must add this option also in the 2.1 version if I have time.



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




Ken Wright said:
Take a look at Ron De Bruins sendmail addin for doing exactly that, and a whole
lot more in the way of options:-

http://www.rondebruin.nl/sendmail.htm

Look for the 'Free Addins' link at the bottom of the list

As far as the macro goes, then it needs to be in the workbook if you want to
send it with it - Can't remember off the top of my head how Ron's addin handles
that though - Ron??
Click to expand...
 
Thanks guys, I will definitly be able to use some of the tips on th
link you gave me but I think I phrased my question poorly.

I do not want to automatically e-mail the sheet. This will not wor
because I am going to distribute this to employees using god knows wha
e-mail client from Hotwire to AOL.

I just want to export (copy) the sheet so it will look the way it doe
when its part of my workbook. But many of the cells are linked to cell
in other sheets. If I tell the macro to copy the sheet all of thes
links are broken and the cells show blanks or 0's etc.

I think perhaps the function Im looking for is called "Values First"?

I guess the work around will be to actually paste all the data into th
exported sheet and hide it. But I was hoping to have a nice little 20
file that would be easy to send from a dial up.

Thanks for your time
 
Hi
you may try using the PasteSpecial method instead of the Paste method.
Paste the cell contents only as 'Values' (as you would do manually with
'Edit - Paste Specials - Values'
 
Use this macro

Sub test()
' This will make a new workbook of the activesheet
'and make values of the formulas
ActiveSheet.Copy
With ActiveSheet.UsedRange
.Value = .Value
End With
End Sub
 
Cheers Ron :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Ron de Bruin said:
Hi BdgBill / Ken

You can make values from your formulas in the Add-in
If you want to send the code also then you can add a button
from the control toolbox on your sheet and place the code in the click event.

Both Add-ins send the code then if you send the with the option "Send ActiveSheet" or Sheets.

If you have the code in a normal module then You must use the Outlook Add-in(3.1)
this have a option of "Workbook Special".
You send the whole workbook with the sheets you want then

I must add this option also in the 2.1 version if I have time.
Click to expand...
 
Back
Top