View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] MichaelRLanier@gmail.com is offline
external usenet poster
 
Posts: 36
Default Retrieving a range of values from a closed file

I would like to post a range of values from a closed file on the same drive without opening the closed file. I need the values of ranges B10:B20, B30:B40, D10:D20, and D30:D40 in the closed file to be posted in the same ranges of my open file. Let's call the open file "Apples" and the closed file "Oranges." I cannot use the usual links because I don't want to be prompted about updating links when I open the "Apples" file. If it is only a matter of preventing the update prompt, that would be very acceptable. Can you offer a solution? Thanks.