| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Don´t show Updatelinks prompt and don´t update
I use the code "Activesheet.copy" and newbook=activeworkbook follwed by
activeworkbook.sendMail. The mail recipient always get the updatelinks for every new book when it opens. Is it possible to give the newbook code information (maybe in an auto_open code) during the sendMail-code session, which don´t show the updatelinks prompt and don´t update it at the mail recipient? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Don´t show Updatelinks prompt and don´t update
Only in the lastest version of Excel (xl2003 has options under Edit=Links).
for other versions, no. -- Regards, Tom Ogilvy "Kent" wrote in message ... I use the code "Activesheet.copy" and newbook=activeworkbook follwed by activeworkbook.sendMail. The mail recipient always get the updatelinks for every new book when it opens. Is it possible to give the newbook code information (maybe in an auto_open code) during the sendMail-code session, which don´t show the updatelinks prompt and don´t update it at the mail recipient? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Don´t show Updatelinks prompt anddon´t update
xl2002, too.
(deuces wild!) Tom Ogilvy wrote: Only in the lastest version of Excel (xl2003 has options under Edit=Links). for other versions, no. -- Regards, Tom Ogilvy "Kent" wrote in message ... I use the code "Activesheet.copy" and newbook=activeworkbook follwed by activeworkbook.sendMail. The mail recipient always get the updatelinks for every new book when it opens. Is it possible to give the newbook code information (maybe in an auto_open code) during the sendMail-code session, which don´t show the updatelinks prompt and don´t update it at the mail recipient? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Don´t show Updatelinks prompt anddon´t update
If you don't want them updated, could you paste special|values before you send
it? Kent wrote: I use the code "Activesheet.copy" and newbook=activeworkbook follwed by activeworkbook.sendMail. The mail recipient always get the updatelinks for every new book when it opens. Is it possible to give the newbook code information (maybe in an auto_open code) during the sendMail-code session, which don´t show the updatelinks prompt and don´t update it at the mail recipient? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Don´t show Updatelinks prompt and don´t update
Activesheet.copy
' now a copy of the activesheet is the active ' sheet in a new workbook Activesheet.cells.copy Activesheet.cells.pasteSpecial xlValues Activeworkook.SendMail . . . ActiveWorkbook.Close Savechanges:=False -- Regards, Tom Ogilvy "Kent" wrote in message ... Thanks. Now I use Activesheet.copy. How can I write code to do the paste special l values ? "Dave Peterson" skrev: If you don't want them updated, could you paste special|values before you send it? Kent wrote: I use the code "Activesheet.copy" and newbook=activeworkbook follwed by activeworkbook.sendMail. The mail recipient always get the updatelinks for every new book when it opens. Is it possible to give the newbook code information (maybe in an auto_open code) during the sendMail-code session, which don´t show the updatelinks prompt and don´t update it at the mail recipient? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I don´t view the value right after six decimal place in Excel | Excel Discussion (Misc queries) | |||
| hiding all cells that dont have any text | Excel Discussion (Misc queries) | |||
| Kinda like a database - I cant believe others dont need to do th | Excel Discussion (Misc queries) | |||
| Text to speech buttons don´t go active | Excel Discussion (Misc queries) | |||
| Don´t show zero values in Pivot Table | Excel Discussion (Misc queries) | |||
Linear Mode
