2003 vs 2007 Macros
 

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

2003 vs 2007 Macros
 

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
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

2003 vs 2007 Macros
 

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
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