Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
current workbook name
Hi,
I have a Master workbook called "MESSER" to be used over and over by new people. Upon first use, the name of the workbook is changed to whatever name. The following statement: Application.Run "MESSER.xls!Sort_by_ID" obiously doesn't work in the new workbook with a different name. Is there anyway to have "MESSER.xls" replaced by an expression which reflects the new workbook name i.e. the 'currentworkbookname' whatever that is? thanks Helmut |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
current workbook name
Try Application.Run Thisworkbook.Name & "!Sort_by_ID" Regards, Stefi €˛Helmut€¯ ezt Ć*rta: Hi, I have a Master workbook called "MESSER" to be used over and over by new people. Upon first use, the name of the workbook is changed to whatever name. The following statement: Application.Run "MESSER.xls!Sort_by_ID" obiously doesn't work in the new workbook with a different name. Is there anyway to have "MESSER.xls" replaced by an expression which reflects the new workbook name i.e. the 'currentworkbookname' whatever that is? thanks Helmut |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
current workbook name
Hi Stefi,
I get a Run-time-Error 1004.... actual workbook name!Sort_by_ID cannot be found. any other suggestions? Helmut "Stefi" wrote: Try Application.Run Thisworkbook.Name & "!Sort_by_ID" Regards, Stefi €˛Helmut€¯ ezt Ć*rta: Hi, I have a Master workbook called "MESSER" to be used over and over by new people. Upon first use, the name of the workbook is changed to whatever name. The following statement: Application.Run "MESSER.xls!Sort_by_ID" obiously doesn't work in the new workbook with a different name. Is there anyway to have "MESSER.xls" replaced by an expression which reflects the new workbook name i.e. the 'currentworkbookname' whatever that is? thanks Helmut |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
current workbook name
Hi Stefi,
It works in the original workbook, but after a NEW workbook was created with another name, int that new workbook it gives me the RunTimeError. Helmut "Stefi" wrote: Try Application.Run Thisworkbook.Name & "!Sort_by_ID" Regards, Stefi €˛Helmut€¯ ezt Ć*rta: Hi, I have a Master workbook called "MESSER" to be used over and over by new people. Upon first use, the name of the workbook is changed to whatever name. The following statement: Application.Run "MESSER.xls!Sort_by_ID" obiously doesn't work in the new workbook with a different name. Is there anyway to have "MESSER.xls" replaced by an expression which reflects the new workbook name i.e. the 'currentworkbookname' whatever that is? thanks Helmut |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
current workbook name
Try
Application.Run "'" & Activeworkbook.Name & "'!Sort_by_ID" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Helmut" wrote in message ... Hi Stefi, I get a Run-time-Error 1004.... actual workbook name!Sort_by_ID cannot be found. any other suggestions? Helmut "Stefi" wrote: Try Application.Run Thisworkbook.Name & "!Sort_by_ID" Regards, Stefi "Helmut" ezt ķrta: Hi, I have a Master workbook called "MESSER" to be used over and over by new people. Upon first use, the name of the workbook is changed to whatever name. The following statement: Application.Run "MESSER.xls!Sort_by_ID" obiously doesn't work in the new workbook with a different name. Is there anyway to have "MESSER.xls" replaced by an expression which reflects the new workbook name i.e. the 'currentworkbookname' whatever that is? thanks Helmut |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
current workbook name
How is a new workbook created? By copying the original MESSER.XLS to a new
name or MESSER.XLS is opened and saved as another workbook e.g. in Workbook_open event or ... ? Can you stop the macro at line Application.Run Thisworkbook.Name & "!Sort_by_ID" and debug Thisworkbook.Name? Stefi €˛Helmut€¯ ezt Ć*rta: Hi Stefi, It works in the original workbook, but after a NEW workbook was created with another name, int that new workbook it gives me the RunTimeError. Helmut "Stefi" wrote: Try Application.Run Thisworkbook.Name & "!Sort_by_ID" Regards, Stefi €˛Helmut€¯ ezt Ć*rta: Hi, I have a Master workbook called "MESSER" to be used over and over by new people. Upon first use, the name of the workbook is changed to whatever name. The following statement: Application.Run "MESSER.xls!Sort_by_ID" obiously doesn't work in the new workbook with a different name. Is there anyway to have "MESSER.xls" replaced by an expression which reflects the new workbook name i.e. the 'currentworkbookname' whatever that is? thanks Helmut |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
current workbook name
Thanks Bob, the "'" did the trick...
Helmut "Bob Phillips" wrote: Try Application.Run "'" & Activeworkbook.Name & "'!Sort_by_ID" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Helmut" wrote in message ... Hi Stefi, I get a Run-time-Error 1004.... actual workbook name!Sort_by_ID cannot be found. any other suggestions? Helmut "Stefi" wrote: Try Application.Run Thisworkbook.Name & "!Sort_by_ID" Regards, Stefi "Helmut" ezt Ć*rta: Hi, I have a Master workbook called "MESSER" to be used over and over by new people. Upon first use, the name of the workbook is changed to whatever name. The following statement: Application.Run "MESSER.xls!Sort_by_ID" obiously doesn't work in the new workbook with a different name. Is there anyway to have "MESSER.xls" replaced by an expression which reflects the new workbook name i.e. the 'currentworkbookname' whatever that is? thanks Helmut |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Treeview For Current Workbook? | Excel Programming | |||
Place code from current workbook to new workbook | Excel Programming | |||
Close a the current workbook and load another specified workbook | Excel Programming | |||
Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
Transparently updating another workbook from the current workbook | Excel Programming |