Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMAT statement in 2003 Excel Macro
I have several worksheets developed in Excel 2007 and have ported them to
computers with Excel 2003. In some cases the following statement works and in others it does not. An example of the format statement is as follows: SMth = Format(SecMth, "mmmm") The macro will not compile because it gets hung up on the "Format" statement stating that it cannot compile because either the Object or Library is not found. Like I stated, this statement does work in other worksheets. HOW CAN I GET THIS TO WORK? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMAT statement in 2003 Excel Macro
In VB Editor
Check Tools-References It might be pointing to the Excel 2007 library (Excel12) Change it to Excel11 "RidgeView" wrote: I have several worksheets developed in Excel 2007 and have ported them to computers with Excel 2003. In some cases the following statement works and in others it does not. An example of the format statement is as follows: SMth = Format(SecMth, "mmmm") The macro will not compile because it gets hung up on the "Format" statement stating that it cannot compile because either the Object or Library is not found. Like I stated, this statement does work in other worksheets. HOW CAN I GET THIS TO WORK? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMAT statement in 2003 Excel Macro
I finally found the following solution. In the VB Editor, the problem was
caused by a check mark in TOOLS/REFERENCE/"Missing.....". Once removed all worked OK. Thanks for your response. "Sheeloo" wrote: In VB Editor Check Tools-References It might be pointing to the Excel 2007 library (Excel12) Change it to Excel11 "RidgeView" wrote: I have several worksheets developed in Excel 2007 and have ported them to computers with Excel 2003. In some cases the following statement works and in others it does not. An example of the format statement is as follows: SMth = Format(SecMth, "mmmm") The macro will not compile because it gets hung up on the "Format" statement stating that it cannot compile because either the Object or Library is not found. Like I stated, this statement does work in other worksheets. HOW CAN I GET THIS TO WORK? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup with if statement - Excel 2003 | Excel Discussion (Misc queries) | |||
Average If Statement (Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2003. Custom format gets replaced by Special format. | New Users to Excel | |||
Place an IF Statement into a Macro 2007 and 2003 | Excel Discussion (Misc queries) | |||
excel 2003-countif statement | Excel Discussion (Misc queries) |