| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run code in other workbook
Hi
I can open a second workbook in code but can not manage to run a proc within the second book (from the first book). I've made second book code Public. Something like workbooks("answers.xls").pastry doesn't work (where pastry is Public proc). Does this make sense? How to please? Thanks! Graeme |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
run code in other workbook
Try
Application.Run "answers!pastry" "Saladin" wrote: Hi I can open a second workbook in code but can not manage to run a proc within the second book (from the first book). I've made second book code Public. Something like workbooks("answers.xls").pastry doesn't work (where pastry is Public proc). Does this make sense? How to please? Thanks! Graeme |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
run code in other workbook
I think that should read...
Application.Run "answers.xls!Pastry" I think you need the file extension.... OJ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
run code in other workbook
thanks both. that's great!
"OJ" wrote in message ups.com... I think that should read... Application.Run "answers.xls!Pastry" I think you need the file extension.... OJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| workbook code | Excel Worksheet Functions | |||
| copy and paste using code from workbook to workbook | Excel Discussion (Misc queries) | |||
| Reference code in another workbook from a calling workbook | Excel Programming | |||
| VBA code to delete VBA code in another Workbook | Excel Programming | |||
| Get code from a corrupted workbook | Excel Programming | |||
Hybrid Mode
