| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
My VBA code in excel does not work on another PC
Ihave a code with the following line that does not work on other computer
If (StrComp(Application.WorksheetFunction.Trim(state) . "A") =0) Then call Updatetime - this is another sub routine. The code reads the cell which has "A" in it but it just does not call up the sub routine. It works on my machine but does not work on another machine. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
My VBA code in excel does not work on another PC
SMH:
Ihave a code with the following line that does not work on other computer If (StrComp(Application.WorksheetFunction.Trim(stat e). "A") =0) Then call Updatetime - this is another sub routine. The code reads the cell which has "A" in it but it just does not call up the sub routine. It works on my machine but does not work on another machine. If UCase(Trim(State)) = "A" Then Call Updatetime End If ( )---cucchiaino |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
My VBA code in excel does not work on another PC
Thank you but the original code works on my laptop but when I transfer the
spreadsheet to another machine running the same windows Xp and offcie 2003 it just ignores this line of code. Any idea ? "cucchiaino" wrote: SMH: Ihave a code with the following line that does not work on other computer If (StrComp(Application.WorksheetFunction.Trim(stat e). "A") =0) Then call Updatetime - this is another sub routine. The code reads the cell which has "A" in it but it just does not call up the sub routine. It works on my machine but does not work on another machine. If UCase(Trim(State)) = "A" Then Call Updatetime End If ( )---cucchiaino |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't get bar code font to work in EXCEL 2003 | Excel Discussion (Misc queries) | |||
| Why this code is not work? | Excel Worksheet Functions | |||
| How can I get this code to work? | Excel Programming | |||
| CommandBar code does NOT work if Excel is Already Open :( | Excel Programming | |||
| Why won't this Excel 2000 code work for Excel '97? | Excel Programming | |||
Hybrid Mode
