Excel conversion
 

what are the errors you're receiving?

"Wonder" wrote in message
...
Hi,

I have a few excel spreadsheet which are linked. One of
the spreadsheet has macro created in it and it takes
almost 6-7 mins to execute.

This files were created in Excel 95. I want to run it in
excel 2000 & 2002 and its showing so many errors. Is
there anyway to convert this files to the higher version
so that it works the same as in the earlier version?

Need help on this! I'm new to macros and VBA.

Thanks...

Excel conversion
 

There were so many errors. This could be because of the
version incompatibilities. One of the error that I
encountered:

Workbooks.Open Filename:=DataPath + "MOPS.XLS" --(XL95)

and I changed it to

Workbooks.Open DataPath & "MOPS.XLS" -- (XL2002)

Like this, there were so many errors and I'm new to this
macro. I don't know the use of each functions. I'm just
getting help from some examples from the internet and the
help.

Is there an easiest way to convert this files to excel
2000/2002?

Thanks.



-----Original Message-----
what are the errors you're receiving?

"Wonder" wrote in message
...
Hi,

I have a few excel spreadsheet which are linked. One of
the spreadsheet has macro created in it and it takes
almost 6-7 mins to execute.

This files were created in Excel 95. I want to run it
in
excel 2000 & 2002 and its showing so many errors. Is
there anyway to convert this files to the higher
version
so that it works the same as in the earlier version?

Need help on this! I'm new to macros and VBA.

Thanks...


.