Thread: Import Cell Values From An Unopen XLS File
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Import Cell Values From An Unopen XLS File
Hi vbman

See
http://www.rondebruin.nl/copy7.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"vbman" wrote in message news:yIeGh.377$3i.360@trnddc01...
Hello all. I am trying to copy values from an unopened Excel spreadsheet to
one that I have open. I cannot figure out how to do this. When I use the
following, cells from the open sheet get selected:

Set xlw = xl.Workbooks.Open("F:\Larry\TEST1_Backup.xls")
xlw.Activate
xlw.Sheets("Field Sheet").Select
Range(Cells(1, 1), Cells(150, 6)).Copy

I am using Excel 2000. Please help. TIA.

Larry


Reply With QuoteReply With Quote