|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 12:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com