Copy worksheet problems.

  • Thread starter Thread starter Skip
  • Start date Start date
S

Skip

I am trying to copy a "read only" spreadsheet into my
workbook in an automated fashion. When I try to open the
original workbook from my macro, I recieve run-time error
9: subscript out of range. I have tried to use Import, but
there are alphas in a numeric field. In this case, the
cells with alphas show up as blank and are unusable. How
can I automate a copy from a different workbook?
 
See one guess at your other post.
I am trying to copy a "read only" spreadsheet into my
workbook in an automated fashion. When I try to open the
original workbook from my macro, I recieve run-time error
9: subscript out of range. I have tried to use Import, but
there are alphas in a numeric field. In this case, the
cells with alphas show up as blank and are unusable. How
can I automate a copy from a different workbook?
Click to expand...
 
Back
Top