Thread: Macro import
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Richard Choate Richard Choate is offline
external usenet poster
 
Posts: 42
Default Macro import

There are a number of methods which are not available in 97. This is likely
one of them.
--
HTH
Richard Choate, CPA

"Lynn" wrote in message
...
I wrote a macro in XP to import data from one excel file
to another excel. The macro runs fine in XP but I keep
getting this error in 2000.

Run-time error 438
Object doesn't support this property or method.

When I click debug it takes me to this line of code:

..SourceDataFile = "E:\filepath\filename.xls"