Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am trying to connect our ACT! to some excel templates, byt get the above error everytime I try to paste link the field. I am trying to link these fileds using the Dynamic Data Exchange (DDE) from ACT to Excel and I am following the example in http://www.actnews.com/Articles/1997/97- 02/ConnnectACTtoExcelwithDDELinks.htm and it works great, in any other cell, but not in the actual cells that I want them to be linked to. Can anyone shed some light on what this error is? Thanks |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
paste your information in another cell that works.
select that cell and go to the formula bar. highlight the information in the formula bar, and hit Ctrl+C to copy it. go to the merged cell and select it. go to the formula bar (click in it). do Ctrl+V to paste the information. then hit enter. You can now clear the formula from the original cell where you do not want the information. -- Regards, Tom Ogilvy " wrote in message ... Hello, I am trying to connect our ACT! to some excel templates, byt get the above error everytime I try to paste link the field. I am trying to link these fileds using the Dynamic Data Exchange (DDE) from ACT to Excel and I am following the example in http://www.actnews.com/Articles/1997/97- 02/ConnnectACTtoExcelwithDDELinks.htm and it works great, in any other cell, but not in the actual cells that I want them to be linked to. Can anyone shed some light on what this error is? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy formulas over merged cells | Excel Discussion (Misc queries) | |||
Copy/Paste formulas in merged cells | Excel Discussion (Misc queries) | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
Formulas in Merged cells | Excel Discussion (Misc queries) | |||
Formatting results of formulas within merged cells | Excel Discussion (Misc queries) |