Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 1
Default On a DDE Linked worksheet : Copy and Paste Value to a to a file via a macro ?

Hi,

I'm now copying and pasting files from a worksheet in an excel file which
carries dde links to a worksheet in same file for purposes of values only.


Unfortunately other's in our team which have to open this excel file
experience problems because they have no access to the dde links causing
error messages.

Now I would my little routine of copying pasting values and formats to
happen to a file on our disk instead of to a worksheet in the same excel
file.

This file should and will be named CGG and this same name will be used all
the time for this file.

Hope I'm clear, Any suggestions ?

Thanks,

Martin



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro copy and paste = blank worksheet efface Excel Discussion (Misc queries) 1 April 27th 06 09:52 PM
Search, Copy, Paste Macro in Excel [email protected] Excel Worksheet Functions 0 January 3rd 06 07:51 PM
Macro to open workbook and copy and paste values in to orig workbo Dena X Excel Worksheet Functions 1 December 16th 05 12:13 AM
Copy and Paste Formula Without the linked file path KevinB Excel Worksheet Functions 2 January 20th 05 07:45 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 06:37 AM


All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"