Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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.
|
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
write cell values to a closed file | Excel Programming | |||
Error retrieving data from closed workbook | Excel Programming | |||
Retrieving values from a specified sheet of a different file. | Excel Worksheet Functions | |||
How can I add values to a closed excel file? | Excel Worksheet Functions | |||
Getting values from a closed file | Excel Programming |