Posted to microsoft.public.excel.programming

kirkm[_7_] kirkm[_7_] is offline

external usenet poster

Posts: 91

Modify function for another workbook

On Thu, 20 Dec 2007 11:18:57 -0000, "Bob Phillips"
wrote:

No it is the book name

Workbooks("my other book.xls")

instead of activeWorkbook.

Pass it as a parameter like the rest.

Thanks Bob,

That worked a treat :-)

Cheers - Kirk

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Modify search function	Dinesh	Excel Worksheet Functions	3	March 18th 09 02:26 AM
Modify Function to Return Value	Connie	Excel Programming	2	October 11th 06 10:37 AM
How do I Default a modify password for each workbook	Sammy work	New Users to Excel	1	December 8th 05 04:11 PM
Modify the default new workbook?	Margot	Excel Worksheet Functions	1	February 11th 05 12:03 AM
to modify cells from a function	Pierre Laporte	Excel Programming	1	July 10th 03 02:11 PM

All times are GMT +1. The time now is 09:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us