Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Apply macro to closed workbooks
Ken I did do paste special/values and still didn't get anywhere. I have managed to find a workaround but don't know why I need it... After doing paste special/values if I then edit/replace c with C for the path name it all works. This works even if the paths already have C in them. If you have a workbook with your solution in it I would be interested in seeing where I've gone wrong, if you were happy to email it to me. But at least I've got the thing done now!! Thanks for your help. Belinda *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Data from Closed Workbooks | Excel Worksheet Functions | |||
Duplicate Macro for Closed Workbooks | Excel Worksheet Functions | |||
Information from Closed workbooks | Excel Discussion (Misc queries) | |||
Apply macro to closed workbooks | Excel Programming | |||
Macro for Pivot Table - Apply to multiple workbooks | Excel Programming |