LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
JK JK is offline
external usenet poster
 
Posts: 78
Default Cell Values from a Closed Workbook

Thanks to JW I was able to implement this procedure in increments but unable
to to make it work in one fluid motion.

I would like my users to select a closed file, then on an active sheet
automatically import cell values from the closed sheet to cells on the
active sheet.

If you have a procedure it would be most appreciated. TIA

James R Kobzeff


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export cell data to closed workbook cluckers Excel Discussion (Misc queries) 7 July 23rd 09 08:43 PM
Reading values from a closed workbook Graham F New Users to Excel 6 July 28th 08 03:32 PM
Get value of last cell in column A from a closed workbook Jon Atkins Excel Programming 3 September 20th 04 08:43 PM
Linking to a cell in another (closed) workbook John Wirt[_6_] Excel Programming 6 May 12th 04 07:55 AM
Code that retrieves values from a closed workbook Todd Huttenstine Excel Programming 1 April 28th 04 07:34 PM


All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"