Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to Workbooks with Constantly Changing Names
I need to link to workbooks whose names will be constantly changing. I want
to access a data file that has labor cost info such as hours worked, overtime, wages, etc. Each week I need to print reports based on this info that will communicate to the production team how they are doing. The problem is that these files will have a new name each week: 06 JAN 2007, then 12 JAN 2007, etc. So in my report worksheet I want to just type the name of the new file into a cell and use the cell reference to build my formulas. So in Cell A1 I would type the name of the new file. And in buiilding my formulas I will tell the cell to look for the worksheet named "new file name" and then go to this tab; etc. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to Workbooks with Constantly Changing Names
Hi Michael in Texas
Maybe you can use this macro to select the files and create the links for you http://www.rondebruin.nl/summary2.htm See example 2 that also test if the files is already in the list Ron from Holland -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Michael in Texas" wrote in message ... I need to link to workbooks whose names will be constantly changing. I want to access a data file that has labor cost info such as hours worked, overtime, wages, etc. Each week I need to print reports based on this info that will communicate to the production team how they are doing. The problem is that these files will have a new name each week: 06 JAN 2007, then 12 JAN 2007, etc. So in my report worksheet I want to just type the name of the new file into a cell and use the cell reference to build my formulas. So in Cell A1 I would type the name of the new file. And in buiilding my formulas I will tell the cell to look for the worksheet named "new file name" and then go to this tab; etc. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to Workbooks with Constantly Changing Names
The macro doesn't quite work for me the way being able to refer to a name
would.... Any suggestions there? "Ron de Bruin" wrote: Hi Michael in Texas Maybe you can use this macro to select the files and create the links for you http://www.rondebruin.nl/summary2.htm See example 2 that also test if the files is already in the list Ron from Holland -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Michael in Texas" wrote in message ... I need to link to workbooks whose names will be constantly changing. I want to access a data file that has labor cost info such as hours worked, overtime, wages, etc. Each week I need to print reports based on this info that will communicate to the production team how they are doing. The problem is that these files will have a new name each week: 06 JAN 2007, then 12 JAN 2007, etc. So in my report worksheet I want to just type the name of the new file into a cell and use the cell reference to build my formulas. So in Cell A1 I would type the name of the new file. And in buiilding my formulas I will tell the cell to look for the worksheet named "new file name" and then go to this tab; etc. Any ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to Workbooks with Constantly Changing Names
being able to refer to a name
Not possible with closed workbooks The Indirect function is only working with open workbooks. You can try this two links and see if it can do what you want You can find the function at Harlan's FTP site: ftp://members.aol.com/hrlngrv/ Look for pull.zip Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ That includes =indirect.ext() that may help you. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Michael in Texas" wrote in message ... The macro doesn't quite work for me the way being able to refer to a name would.... Any suggestions there? "Ron de Bruin" wrote: Hi Michael in Texas Maybe you can use this macro to select the files and create the links for you http://www.rondebruin.nl/summary2.htm See example 2 that also test if the files is already in the list Ron from Holland -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Michael in Texas" wrote in message ... I need to link to workbooks whose names will be constantly changing. I want to access a data file that has labor cost info such as hours worked, overtime, wages, etc. Each week I need to print reports based on this info that will communicate to the production team how they are doing. The problem is that these files will have a new name each week: 06 JAN 2007, then 12 JAN 2007, etc. So in my report worksheet I want to just type the name of the new file into a cell and use the cell reference to build my formulas. So in Cell A1 I would type the name of the new file. And in buiilding my formulas I will tell the cell to look for the worksheet named "new file name" and then go to this tab; etc. Any ideas? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to Workbooks with Constantly Changing Names
Ron I hate to abuse your help but I'm semi-desperate!
I got the indirect.ext funcion from the site you recommended (Thanks!) but I'm wondering if I am phrasing my question correctly also... In cell A1 I want to have the text: 06 JAN 2007.xls and in my formula I want to use the reference to cell A1. Am I making sense? I'm past being able to figure this out myself! "Ron de Bruin" wrote: being able to refer to a name Not possible with closed workbooks The Indirect function is only working with open workbooks. You can try this two links and see if it can do what you want You can find the function at Harlan's FTP site: ftp://members.aol.com/hrlngrv/ Look for pull.zip Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ That includes =indirect.ext() that may help you. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Michael in Texas" wrote in message ... The macro doesn't quite work for me the way being able to refer to a name would.... Any suggestions there? "Ron de Bruin" wrote: Hi Michael in Texas Maybe you can use this macro to select the files and create the links for you http://www.rondebruin.nl/summary2.htm See example 2 that also test if the files is already in the list Ron from Holland -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Michael in Texas" wrote in message ... I need to link to workbooks whose names will be constantly changing. I want to access a data file that has labor cost info such as hours worked, overtime, wages, etc. Each week I need to print reports based on this info that will communicate to the production team how they are doing. The problem is that these files will have a new name each week: 06 JAN 2007, then 12 JAN 2007, etc. So in my report worksheet I want to just type the name of the new file into a cell and use the cell reference to build my formulas. So in Cell A1 I would type the name of the new file. And in buiilding my formulas I will tell the cell to look for the worksheet named "new file name" and then go to this tab; etc. Any ideas? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to Workbooks with Constantly Changing Names
Hi Michael
Very long time ago that I used the indirect function. No time to test it now for you, sorry -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Michael in Texas" wrote in message ... Ron I hate to abuse your help but I'm semi-desperate! I got the indirect.ext funcion from the site you recommended (Thanks!) but I'm wondering if I am phrasing my question correctly also... In cell A1 I want to have the text: 06 JAN 2007.xls and in my formula I want to use the reference to cell A1. Am I making sense? I'm past being able to figure this out myself! "Ron de Bruin" wrote: being able to refer to a name Not possible with closed workbooks The Indirect function is only working with open workbooks. You can try this two links and see if it can do what you want You can find the function at Harlan's FTP site: ftp://members.aol.com/hrlngrv/ Look for pull.zip Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ That includes =indirect.ext() that may help you. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Michael in Texas" wrote in message ... The macro doesn't quite work for me the way being able to refer to a name would.... Any suggestions there? "Ron de Bruin" wrote: Hi Michael in Texas Maybe you can use this macro to select the files and create the links for you http://www.rondebruin.nl/summary2.htm See example 2 that also test if the files is already in the list Ron from Holland -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Michael in Texas" wrote in message ... I need to link to workbooks whose names will be constantly changing. I want to access a data file that has labor cost info such as hours worked, overtime, wages, etc. Each week I need to print reports based on this info that will communicate to the production team how they are doing. The problem is that these files will have a new name each week: 06 JAN 2007, then 12 JAN 2007, etc. So in my report worksheet I want to just type the name of the new file into a cell and use the cell reference to build my formulas. So in Cell A1 I would type the name of the new file. And in buiilding my formulas I will tell the cell to look for the worksheet named "new file name" and then go to this tab; etc. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Changing Multiple Defined Names At Once? | Excel Discussion (Misc queries) | |||
linking to other workbooks | Excel Discussion (Misc queries) | |||
linking multiple workbooks | Links and Linking in Excel | |||
Linking multiple workbooks | Excel Discussion (Misc queries) |