Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
confused and confounded!
I created a macro, with some help here, and sent it to another office
across the state. When she tries to run it on that computer, she gets a runtime error that it doesn't recognize the object on this line: Set wbTribal = Workbooks("Tribal template.xls") wbTribal is dimmed as a workbook. The workbook is "Tribal template.xls". It's like it can't find itself. How can this be? I emailed it to another computer in my office, and it works fine. She is running a different version of Windoze (I'm on 2000 here, she's on XP) and a different version of XL, but the computer I send it to in my office is XP and the same version of XL that she has. Can someone tell me how a file can't recognize itself because it's on a different computer? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
confused and confounded!
Bet she changed the spelling.
If the code is referring to itself use ThisWorkbook instead of the name. -- Jim "salgud" wrote in message ... |I created a macro, with some help here, and sent it to another office | across the state. When she tries to run it on that computer, she gets a | runtime error that it doesn't recognize the object on this line: | | Set wbTribal = Workbooks("Tribal template.xls") | | wbTribal is dimmed as a workbook. | | The workbook is "Tribal template.xls". It's like it can't find itself. How | can this be? I emailed it to another computer in my office, and it works | fine. She is running a different version of Windoze (I'm on 2000 here, | she's on XP) and a different version of XL, but the computer I send it to | in my office is XP and the same version of XL that she has. Can someone | tell me how a file can't recognize itself because it's on a different | computer? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
confused and confounded!
On Thu, 17 Jul 2008 14:16:41 -0400, Jim Rech wrote:
Bet she changed the spelling. If the code is referring to itself use ThisWorkbook instead of the name. Thanks for your reply. She says she didn't change anything, and I can't figure out why she would. This spreadsheet is going to save her a lot of headaches and she says she's anxious to get it and use it. Who knows? I had thought about trying "Thisworkbook", so I'll try that next. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
confused and confounded!
There is also a Trim function in Excel that will remove leading and trailing
spaces. Keith "salgud" wrote: I created a macro, with some help here, and sent it to another office across the state. When she tries to run it on that computer, she gets a runtime error that it doesn't recognize the object on this line: Set wbTribal = Workbooks("Tribal template.xls") wbTribal is dimmed as a workbook. The workbook is "Tribal template.xls". It's like it can't find itself. How can this be? I emailed it to another computer in my office, and it works fine. She is running a different version of Windoze (I'm on 2000 here, she's on XP) and a different version of XL, but the computer I send it to in my office is XP and the same version of XL that she has. Can someone tell me how a file can't recognize itself because it's on a different computer? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
confused and confounded!
On Thu, 17 Jul 2008 12:56:23 -0600, salgud wrote:
On Thu, 17 Jul 2008 14:16:41 -0400, Jim Rech wrote: Bet she changed the spelling. If the code is referring to itself use ThisWorkbook instead of the name. Thanks for your reply. She says she didn't change anything, and I can't figure out why she would. This spreadsheet is going to save her a lot of headaches and she says she's anxious to get it and use it. Who knows? I had thought about trying "Thisworkbook", so I'll try that next. I changed it to "Thisworkbook" and now it's working. Go figure. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
confused and confounded!
On Thu, 17 Jul 2008 13:43:08 -0700, Keithlo wrote:
There is also a Trim function in Excel that will remove leading and trailing spaces. Keith "salgud" wrote: I created a macro, with some help here, and sent it to another office across the state. When she tries to run it on that computer, she gets a runtime error that it doesn't recognize the object on this line: Set wbTribal = Workbooks("Tribal template.xls") wbTribal is dimmed as a workbook. The workbook is "Tribal template.xls". It's like it can't find itself. How can this be? I emailed it to another computer in my office, and it works fine. She is running a different version of Windoze (I'm on 2000 here, she's on XP) and a different version of XL, but the computer I send it to in my office is XP and the same version of XL that she has. Can someone tell me how a file can't recognize itself because it's on a different computer? thanks for your reply. Got it working with "Thisworkbook". |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
confused and confounded!
Have her save it to her hard drive before she opens it and tries to run the
macro. When you open a file directly from email it will save it to a temp folder and then open it. That will sometimes append a (1) to the file name that the macro doesn't match to. Using ThisWorkbook should cure that scenario also. Mike F "salgud" wrote in message ... I created a macro, with some help here, and sent it to another office across the state. When she tries to run it on that computer, she gets a runtime error that it doesn't recognize the object on this line: Set wbTribal = Workbooks("Tribal template.xls") wbTribal is dimmed as a workbook. The workbook is "Tribal template.xls". It's like it can't find itself. How can this be? I emailed it to another computer in my office, and it works fine. She is running a different version of Windoze (I'm on 2000 here, she's on XP) and a different version of XL, but the computer I send it to in my office is XP and the same version of XL that she has. Can someone tell me how a file can't recognize itself because it's on a different computer? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
confused and confounded!
On Thu, 17 Jul 2008 17:26:48 -0400, Mike Fogleman wrote:
Have her save it to her hard drive before she opens it and tries to run the macro. When you open a file directly from email it will save it to a temp folder and then open it. That will sometimes append a (1) to the file name that the macro doesn't match to. Using ThisWorkbook should cure that scenario also. Mike F "salgud" wrote in message ... I created a macro, with some help here, and sent it to another office across the state. When she tries to run it on that computer, she gets a runtime error that it doesn't recognize the object on this line: Set wbTribal = Workbooks("Tribal template.xls") wbTribal is dimmed as a workbook. The workbook is "Tribal template.xls". It's like it can't find itself. How can this be? I emailed it to another computer in my office, and it works fine. She is running a different version of Windoze (I'm on 2000 here, she's on XP) and a different version of XL, but the computer I send it to in my office is XP and the same version of XL that she has. Can someone tell me how a file can't recognize itself because it's on a different computer? Thanks for the reply. I should have mentioned that's the first thing I did. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Confounded by date differences | Excel Discussion (Misc queries) | |||
confused. Please help. | Excel Discussion (Misc queries) | |||
I'm still confused | Excel Worksheet Functions | |||
Confused | New Users to Excel | |||
confused,please help | Excel Discussion (Misc queries) |