PC Review


Reply
Thread Tools Rate Thread

Build link to an other excell doc

 
 
danielh
Guest
Posts: n/a
 
      5th Jan 2010
Hi!
I've managed to link fileds to an other excell document.
IE. ='C:\[calc2009.xls]Page1'!A1
But now I'm trying to build a link so that it updates with a new year every
time you change the year.
IE.
in B1 I write the year 2010.
Now the link in B2 changes to ='C:\[calc2010.xls]Page1'!A1

I've tried with ='C:\[calc&B1&.xls]Page1'!A1 and similiar, but with no
success.

Is this possible?
Thanks for your help!
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      5th Jan 2010
Check your earlier post.

danielh wrote:
>
> Hi!
> I've managed to link fileds to an other excell document.
> IE. ='C:\[calc2009.xls]Page1'!A1
> But now I'm trying to build a link so that it updates with a new year every
> time you change the year.
> IE.
> in B1 I write the year 2010.
> Now the link in B2 changes to ='C:\[calc2010.xls]Page1'!A1
>
> I've tried with ='C:\[calc&B1&.xls]Page1'!A1 and similiar, but with no
> success.
>
> Is this possible?
> Thanks for your help!


--

Dave Peterson
 
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
Build a link to an other excell document. danielh Microsoft Excel Misc 1 5th Jan 2010 04:52 PM
Is it possible to link web page with access or excell =?Utf-8?B?amFtZXM=?= Microsoft Frontpage 1 10th Sep 2006 06:32 AM
how do i build a call report form in excell =?Utf-8?B?bXIubW90b3Jpc3Q=?= Microsoft Excel Programming 2 9th Dec 2005 02:46 AM
Excell link table format =?Utf-8?B?amFja2xl?= Microsoft Access External Data 8 28th Dec 2004 07:49 PM
winver 5x(Build 2195:Service Pack 4) - package of Excell and winw. =?Utf-8?B?bWl0d29ybGQ=?= Microsoft Excel Misc 1 26th Oct 2004 09:02 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:24 PM.