Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking multiple workbooks - UPDATED
Can someone please help me with linking multiple workbooks to a listbox
I have 32 excel workbooks full of charts and I want to link each t selection in a listbox on a master sheet. Help!! Thanks I have 32 excel workbooks that have over 32 sheets in each. I hav created a 'Home' page that includes multiple list boxes. Each list bo has 4 selections. I want to link the 4 selections to sheets that are i different workbooks. i.e. Product ttl is in productttl.xls (sheet product tttl) and siz 1.75 is in productttl1.75.xls (sheet procutttl 1.75). Hope this makes more sense -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking multiple workbooks - UPDATED
If the workbooks will be closed, you will have to have your macro hard code
a reference to them. If they will be open, you can use the indirect worksheet function. -- Regards, Tom Ogilvy "bkey01 " wrote in message ... Can someone please help me with linking multiple workbooks to a listbox? I have 32 excel workbooks full of charts and I want to link each to selection in a listbox on a master sheet. Help!! Thanks I have 32 excel workbooks that have over 32 sheets in each. I have created a 'Home' page that includes multiple list boxes. Each list box has 4 selections. I want to link the 4 selections to sheets that are in different workbooks. i.e. Product ttl is in productttl.xls (sheet product tttl) and size 1.75 is in productttl1.75.xls (sheet procutttl 1.75). Hope this makes more sense. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking multiple workbooks - UPDATED
Tom Ogilvy wrote:
*If the workbooks will be closed, you will have to have your macr hard code a reference to them. If they will be open, you can use the indirect worksheet function. -- Regards, Tom Ogilvy "bkey01 " wrote in message ... Can someone please help me with linking multiple workbooks to listbox? I have 32 excel workbooks full of charts and I want to link eac to selection in a listbox on a master sheet. Help!! Thanks I have 32 excel workbooks that have over 32 sheets in each. I have created a 'Home' page that includes multiple list boxes. Each lis box has 4 selections. I want to link the 4 selections to sheets tha are in different workbooks. i.e. Product ttl is in productttl.xls (sheet product tttl) an size 1.75 is in productttl1.75.xls (sheet procutttl 1.75). Hope this makes more sense. --- Message posted from http://www.ExcelForum.com/ * Thanks for the information. Can you provide me with an example of th code for a hard code macro? Thank -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking multiple workbooks - UPDATED
Sub WriteLink()
ActiveCell.formula = "='c:\Mydocuments\Myfolder\[Book1.xls]Sheet1'!$A$1" End Sub -- Regards, Tom Ogilvy "bkey01 " wrote in message ... Tom Ogilvy wrote: *If the workbooks will be closed, you will have to have your macro hard code a reference to them. If they will be open, you can use the indirect worksheet function. -- Regards, Tom Ogilvy "bkey01 " wrote in message ... Can someone please help me with linking multiple workbooks to a listbox? I have 32 excel workbooks full of charts and I want to link each to selection in a listbox on a master sheet. Help!! Thanks I have 32 excel workbooks that have over 32 sheets in each. I have created a 'Home' page that includes multiple list boxes. Each list box has 4 selections. I want to link the 4 selections to sheets that are in different workbooks. i.e. Product ttl is in productttl.xls (sheet product tttl) and size 1.75 is in productttl1.75.xls (sheet procutttl 1.75). Hope this makes more sense. --- Message posted from http://www.ExcelForum.com/ * Thanks for the information. Can you provide me with an example of the code for a hard code macro? Thanks --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking multiple workbooks together | Excel Discussion (Misc queries) | |||
linking multiple workbooks | Links and Linking in Excel | |||
Linking multiple workbooks | Excel Discussion (Misc queries) | |||
how can you see what is updated when linking workbooks | Excel Discussion (Misc queries) | |||
linking multiple workbooks (VBA) | Excel Programming |