| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open another Excel spreadsheet to copy data into current spreadsheet ?
Hi Tom,
I have the same question but with a variation to your solution [='C:\myfolder\[Test File 2003.xls]Budget 2003'!$A$1]. What if [Test File 2003.xls] is written in cell A1. How would you re-write the formula so that it'll open based on C:\myfolder\ + cell[A1]'s filename? This would be especially helpful when I need to refer to different files with the same layout. As always, I thank-you for your help. Much appreciated, Ricky *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting part of a Spreadsheet into the Current Spreadsheet | Excel Discussion (Misc queries) | |||
| How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
| Can Excel automatically enter the current date in a spreadsheet? | Excel Discussion (Misc queries) | |||
| In Excel I want to copy text from spreadsheet to spreadsheet | Excel Worksheet Functions | |||
| Copy data from one Excel spreadsheet to another | Excel Discussion (Misc queries) | |||
Linear Mode
