PC Review


Reply
Thread Tools Rate Thread

data from external file without opening

 
 
=?Utf-8?B?ZGVsYWxp?=
Guest
Posts: n/a
 
      21st Nov 2006
Hi All,

Is it possible to get data from an external excel file without opening the
file?

using workbooks("fname").worksheets("shtname").range("A1").value only works
when fname is open.

thanks
 
Reply With Quote
 
 
 
 
=?Utf-8?B?R2FyeScncyBTdHVkZW50?=
Guest
Posts: n/a
 
      21st Nov 2006
If you insert a link to a cell in an external file in your worksheet cell,
Excel will ask if you want to update links when your file is opened.

If you can anticipate from which cells in the external file data is
required, then just set-up links to them and pickup data data when your file
is opened.
--
Gary's Student


"delali" wrote:

> Hi All,
>
> Is it possible to get data from an external excel file without opening the
> file?
>
> using workbooks("fname").worksheets("shtname").range("A1").value only works
> when fname is open.
>
> thanks

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      21st Nov 2006
See Ron de Bruin's site for code.

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


Gord Dibben MS Excel MVP

On Tue, 21 Nov 2006 11:50:02 -0800, delali <(E-Mail Removed)>
wrote:

>Hi All,
>
>Is it possible to get data from an external excel file without opening the
>file?
>
>using workbooks("fname").worksheets("shtname").range("A1").value only works
>when fname is open.
>
>thanks


 
Reply With Quote
 
Ing. Luis Fernando Ortiz M.
Guest
Posts: n/a
 
      21st Nov 2006
delali:

Try with Vlookup

Regards.

Luis Fernando Ortiz M.

"delali" <(E-Mail Removed)> escribió en el mensaje
news:B1C0825C-968B-4F39-8533-(E-Mail Removed)...
> Hi All,
>
> Is it possible to get data from an external excel file without opening the
> file?
>
> using workbooks("fname").worksheets("shtname").range("A1").value only
> works
> when fname is open.
>
> thanks



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening An External File Matthew Microsoft Excel Misc 3 5th Oct 2009 03:33 PM
Opening an excel file which has a query to external data pedro Microsoft Access Form Coding 0 20th Nov 2007 09:46 AM
Open external data (varying file names) and closing file once data is retrieved Corrie Microsoft Excel Programming 2 31st Dec 2006 09:56 PM
Opening an external file =?Utf-8?B?bGlsbnViYQ==?= Microsoft Excel Programming 1 18th Aug 2004 04:56 PM
Autorefreshing excell external data while opening from VBA code Devendra Microsoft Excel Programming 1 7th Jan 2004 06:37 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:25 AM.