LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default importing a cell value

I need to import a cell values from an un-opened .xls using a variable address
ie
cell A34 = the location of the .xls on our server
(j:\121213\Drafting\Quants\)
"105 White Ant" = the name of the .xls
B3 = the cell I need to import

C6 = value(A34+"105 White Ant"+B3)

Any help or advice would be hugely appriciated

 
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
Importing range of cell values from several workbooks to one ®eljka Petrović New Users to Excel 2 October 4th 07 01:12 PM
Importing Alan Beban's code on Arrays; Importing a module or a project Steve G Excel Worksheet Functions 4 August 27th 07 04:18 PM
Importing gif as a note on a cell bluebadger Excel Discussion (Misc queries) 1 June 23rd 06 12:20 PM
importing csv Gary''s Student Excel Discussion (Misc queries) 2 November 9th 05 04:41 PM
Cell formatting when importing data cjay Excel Discussion (Misc queries) 2 May 18th 05 10:01 PM


All times are GMT +1. The time now is 11:20 AM.

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

About Us

"It's about Microsoft Excel"