Office97 Objects will Not Run Under 2000

  • Thread starter Thread starter Craig Phillips
  • Start date Start date
C

Craig Phillips

Can anybody help me???
I have an excel file which was originially written in Office 97 bu
then updated under 2000. Since the updates have occured, several of th
object function give an run-time error 1004 when run again under 97

for example:
Sheet2.Range("A37:L50").Borders.LineStyle = xlLineStyleNone

this is just one example but occurs with application.object functions.
:
 
Generally:

Multiversion development should be done in the LOWEST version.
then tested for anomalies in higher version(s).

I've tested your code line in xl97 dutch version
and it works perfectly.

with 1 adjustment :)

Worksheets(2).Range("A37:L50").Borders.LineStyle = xlLineStyleNone

Note that Sheet2 is the codename of a worksheet object
(= the name of the VBcomponent in the workbook's VBproject)
which in a newly created sheet in Dutch would be "Blad2"


so the question is... does the ACTIVEworkbook contain
a worksheet with the CODEname sheet2?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Office 97 Code Edited in 2000 Will Not Run 7
Office 97 Code Edited in 2000 Will Not Run 1
Run-time-error 1004 "ListIndex method of listbox class failed" 1
Excel 2003 protect not working in Excel 97 4
Error 1004 'Range' when using French Regional options but not Engl 5
Run time error '1004' 2
setting a range not working, please help 3
Macros written in Excel 97 will not work in Excel 2003 4

Back
Top