Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to open workbooks with different names
Hi,
I have a need to open workbooks with same names in different folders at the same time. Is there any feature using VBA to open workbooks with different name. I guess I could copy it with a different name before I open it. But is there any other way? Also I have a situation where many users will be opening these workbooks at the same time possibly. thanks Kanan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to open workbooks with different names
If you really want to have two different workbooks with the same name, you'll
have to open two different instances of excel. This makes communicating between them (copy|pasting even!) more difficult. But you can start another instance by: windows start button|Run excel (and hit enter) Kanan wrote: Hi, I have a need to open workbooks with same names in different folders at the same time. Is there any feature using VBA to open workbooks with different name. I guess I could copy it with a different name before I open it. But is there any other way? Also I have a situation where many users will be opening these workbooks at the same time possibly. thanks Kanan -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to open workbooks with different names
Please describe your typical system and if networked.
-- Jim at Eagle "Dave Peterson" wrote: If you really want to have two different workbooks with the same name, you'll have to open two different instances of excel. This makes communicating between them (copy|pasting even!) more difficult. But you can start another instance by: windows start button|Run excel (and hit enter) Kanan wrote: Hi, I have a need to open workbooks with same names in different folders at the same time. Is there any feature using VBA to open workbooks with different name. I guess I could copy it with a different name before I open it. But is there any other way? Also I have a situation where many users will be opening these workbooks at the same time possibly. thanks Kanan -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to open workbooks with different names
Why would this matter?
Jim at Eagle wrote: Please describe your typical system and if networked. -- Jim at Eagle "Dave Peterson" wrote: If you really want to have two different workbooks with the same name, you'll have to open two different instances of excel. This makes communicating between them (copy|pasting even!) more difficult. But you can start another instance by: windows start button|Run excel (and hit enter) Kanan wrote: Hi, I have a need to open workbooks with same names in different folders at the same time. Is there any feature using VBA to open workbooks with different name. I guess I could copy it with a different name before I open it. But is there any other way? Also I have a situation where many users will be opening these workbooks at the same time possibly. thanks Kanan -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to open workbooks with different names
Imagine a group of people on a cliff 100 feet in the high. They must leave in
alphabetical order and they hang 26 ropes off the cliff. They get in proper line and begin descent. Sounds like good start. However, all the ropes are 25 long. A lot of software is created to address problems in applications design or to overcome existing structure. It sounded to me as if Kanan was in the middle of a descent and I was hoping to stimulate examination of objective from start and not from present dilemma. The concern was from €śAlso I have a situation where many users will be opening these workbooks at the same time€ť. -- Jim at Eagle "Dave Peterson" wrote: Why would this matter? Jim at Eagle wrote: Please describe your typical system and if networked. -- Jim at Eagle "Dave Peterson" wrote: If you really want to have two different workbooks with the same name, you'll have to open two different instances of excel. This makes communicating between them (copy|pasting even!) more difficult. But you can start another instance by: windows start button|Run excel (and hit enter) Kanan wrote: Hi, I have a need to open workbooks with same names in different folders at the same time. Is there any feature using VBA to open workbooks with different name. I guess I could copy it with a different name before I open it. But is there any other way? Also I have a situation where many users will be opening these workbooks at the same time possibly. thanks Kanan -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to open workbooks with different names
HI Eevery one,
Sorry I was out of town for a week or so. My environment is networked. I have different folders in the shared drive. Each one of these folders have workbooks with same names but the content is different. I have a command button (I call it "Drilldown") in the worksheet in my workbook (called Nonclinical) which will display range of options. One of the option is to open the workbook in one of team folders. Each team folder has a workbook called Nonclinical. Thats where my problem is. I hope I explained clearly. Let me know thanks Kanan "Jim at Eagle" wrote: Imagine a group of people on a cliff 100 feet in the high. They must leave in alphabetical order and they hang 26 ropes off the cliff. They get in proper line and begin descent. Sounds like good start. However, all the ropes are 25 long. A lot of software is created to address problems in applications design or to overcome existing structure. It sounded to me as if Kanan was in the middle of a descent and I was hoping to stimulate examination of objective from start and not from present dilemma. The concern was from €śAlso I have a situation where many users will be opening these workbooks at the same time€ť. -- Jim at Eagle "Dave Peterson" wrote: Why would this matter? Jim at Eagle wrote: Please describe your typical system and if networked. -- Jim at Eagle "Dave Peterson" wrote: If you really want to have two different workbooks with the same name, you'll have to open two different instances of excel. This makes communicating between them (copy|pasting even!) more difficult. But you can start another instance by: windows start button|Run excel (and hit enter) Kanan wrote: Hi, I have a need to open workbooks with same names in different folders at the same time. Is there any feature using VBA to open workbooks with different name. I guess I could copy it with a different name before I open it. But is there any other way? Also I have a situation where many users will be opening these workbooks at the same time possibly. thanks Kanan -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to open workbooks with different names
If you want to open multiple files with the same name in excel, you'll have to
start a different instance of excel for each of them. A single instance of Excel won't let you open a second file that has the same filename as an already open file. Kanan wrote: HI Eevery one, Sorry I was out of town for a week or so. My environment is networked. I have different folders in the shared drive. Each one of these folders have workbooks with same names but the content is different. I have a command button (I call it "Drilldown") in the worksheet in my workbook (called Nonclinical) which will display range of options. One of the option is to open the workbook in one of team folders. Each team folder has a workbook called Nonclinical. Thats where my problem is. I hope I explained clearly. Let me know thanks Kanan "Jim at Eagle" wrote: Imagine a group of people on a cliff 100 feet in the high. They must leave in alphabetical order and they hang 26 ropes off the cliff. They get in proper line and begin descent. Sounds like good start. However, all the ropes are 25 long. A lot of software is created to address problems in applications design or to overcome existing structure. It sounded to me as if Kanan was in the middle of a descent and I was hoping to stimulate examination of objective from start and not from present dilemma. The concern was from €śAlso I have a situation where many users will be opening these workbooks at the same time€ť. -- Jim at Eagle "Dave Peterson" wrote: Why would this matter? Jim at Eagle wrote: Please describe your typical system and if networked. -- Jim at Eagle "Dave Peterson" wrote: If you really want to have two different workbooks with the same name, you'll have to open two different instances of excel. This makes communicating between them (copy|pasting even!) more difficult. But you can start another instance by: windows start button|Run excel (and hit enter) Kanan wrote: Hi, I have a need to open workbooks with same names in different folders at the same time. Is there any feature using VBA to open workbooks with different name. I guess I could copy it with a different name before I open it. But is there any other way? Also I have a situation where many users will be opening these workbooks at the same time possibly. thanks Kanan -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to open workbooks with different names
I recommend you not be afraid to rename all files with a naming rhythm easily
understood. Program your workbook to retrieve other workbooks using an interpreter in your menu. For example all workbooks are named following the name from your server station ID and this correlates with a drop down list in your workbook with a personal name or office station that is familiar to you. If you anticipate a strong growth in workbooks, correcting this deficiency sooner is best. Good luck, -- Jim at Eagle "Kanan" wrote: HI Eevery one, Sorry I was out of town for a week or so. My environment is networked. I have different folders in the shared drive. Each one of these folders have workbooks with same names but the content is different. I have a command button (I call it "Drilldown") in the worksheet in my workbook (called Nonclinical) which will display range of options. One of the option is to open the workbook in one of team folders. Each team folder has a workbook called Nonclinical. Thats where my problem is. I hope I explained clearly. Let me know thanks Kanan "Jim at Eagle" wrote: Imagine a group of people on a cliff 100 feet in the high. They must leave in alphabetical order and they hang 26 ropes off the cliff. They get in proper line and begin descent. Sounds like good start. However, all the ropes are 25 long. A lot of software is created to address problems in applications design or to overcome existing structure. It sounded to me as if Kanan was in the middle of a descent and I was hoping to stimulate examination of objective from start and not from present dilemma. The concern was from €śAlso I have a situation where many users will be opening these workbooks at the same time€ť. -- Jim at Eagle "Dave Peterson" wrote: Why would this matter? Jim at Eagle wrote: Please describe your typical system and if networked. -- Jim at Eagle "Dave Peterson" wrote: If you really want to have two different workbooks with the same name, you'll have to open two different instances of excel. This makes communicating between them (copy|pasting even!) more difficult. But you can start another instance by: windows start button|Run excel (and hit enter) Kanan wrote: Hi, I have a need to open workbooks with same names in different folders at the same time. Is there any feature using VBA to open workbooks with different name. I guess I could copy it with a different name before I open it. But is there any other way? Also I have a situation where many users will be opening these workbooks at the same time possibly. thanks Kanan -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to open workbooks with different names
thanks for all your feedback. kanan "Jim at Eagle" wrote: I recommend you not be afraid to rename all files with a naming rhythm easily understood. Program your workbook to retrieve other workbooks using an interpreter in your menu. For example all workbooks are named following the name from your server station ID and this correlates with a drop down list in your workbook with a personal name or office station that is familiar to you. If you anticipate a strong growth in workbooks, correcting this deficiency sooner is best. Good luck, -- Jim at Eagle "Kanan" wrote: HI Eevery one, Sorry I was out of town for a week or so. My environment is networked. I have different folders in the shared drive. Each one of these folders have workbooks with same names but the content is different. I have a command button (I call it "Drilldown") in the worksheet in my workbook (called Nonclinical) which will display range of options. One of the option is to open the workbook in one of team folders. Each team folder has a workbook called Nonclinical. Thats where my problem is. I hope I explained clearly. Let me know thanks Kanan "Jim at Eagle" wrote: Imagine a group of people on a cliff 100 feet in the high. They must leave in alphabetical order and they hang 26 ropes off the cliff. They get in proper line and begin descent. Sounds like good start. However, all the ropes are 25 long. A lot of software is created to address problems in applications design or to overcome existing structure. It sounded to me as if Kanan was in the middle of a descent and I was hoping to stimulate examination of objective from start and not from present dilemma. The concern was from €śAlso I have a situation where many users will be opening these workbooks at the same time€ť. -- Jim at Eagle "Dave Peterson" wrote: Why would this matter? Jim at Eagle wrote: Please describe your typical system and if networked. -- Jim at Eagle "Dave Peterson" wrote: If you really want to have two different workbooks with the same name, you'll have to open two different instances of excel. This makes communicating between them (copy|pasting even!) more difficult. But you can start another instance by: windows start button|Run excel (and hit enter) Kanan wrote: Hi, I have a need to open workbooks with same names in different folders at the same time. Is there any feature using VBA to open workbooks with different name. I guess I could copy it with a different name before I open it. But is there any other way? Also I have a situation where many users will be opening these workbooks at the same time possibly. thanks Kanan -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
Open workbooks with different names | Excel Programming | |||
Workbooks.Open closes other workbooks | Excel Programming | |||
Workbooks.Open / .Open Text - How do you stop the .xls addition? | Excel Programming |