I have many 2003 spreadsheets with macros.

I just tried to load one of them inot 2007.
I Opened the File, then Saved it as .xlsm file. Then I closed it ant opened
it.
I tried to run my macro and got the message "Can't find Project or Library."

Dim rstring As String
rstring = "A" + Trim(Str(r1)) + ":G" + Trim(Str(r2)) where str is highlighted.

Any thoughts? If I have to convert/upgrade these programs, is there any
utility or tutorial on what to do?

Thanks

First, make sure all the references are set properly. Open the
workbook, then open the VBA editor. There, go to the Tools menu and
choose References. If any are marked "MISSING", you will need to
uncheck that reference and, if it is required, reset it to the proper
file name. See http://www.cpearson.com/Excel/StartupErrors.aspx for
more info about diagnosing and fixing errors.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Wed, 26 Nov 2008 07:06:05 -0800, John Tripp
<(E-Mail Removed)> wrote:

>I have many 2003 spreadsheets with macros.
>
>I just tried to load one of them inot 2007.
>I Opened the File, then Saved it as .xlsm file. Then I closed it ant opened
>it.
>I tried to run my macro and got the message "Can't find Project or Library."
>
>Dim rstring As String
>rstring = "A" + Trim(Str(r1)) + ":G" + Trim(Str(r2)) where str is highlighted.
>
>Any thoughts? If I have to convert/upgrade these programs, is there any
>utility or tutorial on what to do?
>
>Thanks

Thanks! Works fine. I guess I will have to do that with any similar
workbook, as I use them.

"Chip Pearson" wrote:

> First, make sure all the references are set properly. Open the
> workbook, then open the VBA editor. There, go to the Tools menu and
> choose References. If any are marked "MISSING", you will need to
> uncheck that reference and, if it is required, reset it to the proper
> file name. See http://www.cpearson.com/Excel/StartupErrors.aspx for
> more info about diagnosing and fixing errors.
>
> Cordially,
> Chip Pearson
> Microsoft MVP
> Excel Product Group
> Pearson Software Consulting, LLC
> www.cpearson.com
> (email on web site)
>
>
> On Wed, 26 Nov 2008 07:06:05 -0800, John Tripp
> <(E-Mail Removed)> wrote:
>
> >I have many 2003 spreadsheets with macros.
> >
> >I just tried to load one of them inot 2007.
> >I Opened the File, then Saved it as .xlsm file. Then I closed it ant opened
> >it.
> >I tried to run my macro and got the message "Can't find Project or Library."
> >
> >Dim rstring As String
> >rstring = "A" + Trim(Str(r1)) + ":G" + Trim(Str(r2)) where str is highlighted.
> >
> >Any thoughts? If I have to convert/upgrade these programs, is there any
> >utility or tutorial on what to do?
> >
> >Thanks
>