Hi,
Application was built in ms excel 2003. I opened the file in ms excel 2010 and save it with .xlsm extention because this spreadsheet has macros built in VBA. When I open the file hit the button on spreadsheet to execute the code behind it gives me compile error "can't find project or library". I read that go to Tools and select references and unchecked the missing references
<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
referrelative="t" o:spt="75" coordsize="21600,21600">"Missing: Microsoft Calendar Control 10.0"</v:shapetype>
<v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600">Location: c:\PROGRA~1\MICROS~2\OFFICE11\MSCAL.OCX</v:shapetype>
<v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600">Language: Standard</v:shapetype>
<v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"></v:shapetype>
<v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600">When I unchecked the missing box and try to run the code it give me other message box saying "The macro may not be available in this workbook or all macros may be disabled"</v:shapetype>
<v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"></v:shapetype>
<v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600">If anyone know how to fix this problem i will really appreciate.</v:shapetype>
<v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"></v:shapetype>
<v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600">Thanks</v:shapetype>
Application was built in ms excel 2003. I opened the file in ms excel 2010 and save it with .xlsm extention because this spreadsheet has macros built in VBA. When I open the file hit the button on spreadsheet to execute the code behind it gives me compile error "can't find project or library". I read that go to Tools and select references and unchecked the missing references
<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
referrelative="t" o:spt="75" coordsize="21600,21600">"Missing: Microsoft Calendar Control 10.0"</v:shapetype><v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
referrelative="t" o:spt="75" coordsize="21600,21600">Location: c:\PROGRA~1\MICROS~2\OFFICE11\MSCAL.OCX</v:shapetype><v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
referrelative="t" o:spt="75" coordsize="21600,21600">Language: Standard</v:shapetype><v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
referrelative="t" o:spt="75" coordsize="21600,21600"></v:shapetype><v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
referrelative="t" o:spt="75" coordsize="21600,21600">When I unchecked the missing box and try to run the code it give me other message box saying "The macro may not be available in this workbook or all macros may be disabled"</v:shapetype><v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
referrelative="t" o:spt="75" coordsize="21600,21600"></v:shapetype><v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
referrelative="t" o:spt="75" coordsize="21600,21600">If anyone know how to fix this problem i will really appreciate.</v:shapetype><v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
referrelative="t" o:spt="75" coordsize="21600,21600"></v:shapetype><v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
referrelative="t" o:spt="75" coordsize="21600,21600">Thanks</v:shapetype>
