Excel Link?

0 ⤊

Hi,

I have for example the following link: ='C:\Documents and Settings\wycmest1\Desktop\[vat_Details.xls]Sheet1'!$A$1. Is it possible to make the sheetname (Sheet1) variable e.g. referring to a cell with the name of the sheet?

Many Thanks

2007-11-26 01:54:45 · 2 answers · asked by No1DiamondGeezer 1 in Computers & Internet ➔ Programming & Design

2 answers

Yes, but (as far as I know) only by using a VB macro ..

2007-11-26 03:09:11 · answer #1 · answered by Steve B 7 · 0⤊ 0⤋

i dint get you.. you wanna change the sheet name? at the bottom on the sheet name, right click and just change the name there... thats it...
The link you gave is the link which is on your comp on your desktop. it cant be seen by any1 else...

2007-11-26 02:05:54 · answer #2 · answered by Vj Chris 2 · 0⤊ 0⤋