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 ?


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

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 ?



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 06:51 PM
Macro to open workbook and copy and paste values in to orig workbo Dena X Excel Worksheet Functions 1 December 15th 05 11:13 PM
Copy and Paste Formula Without the linked file path KevinB Excel Worksheet Functions 2 January 20th 05 06:45 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM

All times are GMT +1. The time now is 10:58 PM.

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

About Us

"It's about Microsoft Excel"