Search : in
By :

Hyperlink and vlookup

Last answer on Jun 23, 2009 2:26:02 am BST hussain, on Jun 17, 2009 6:47:42 am BST 
 Report this message to moderators

Hello,

i have an file which i have to update every day using vlookup form other files each day have name with that day date eg (file1706) ... i have managed to creat an hyperlink to open it directly but need a code tht will open the update hyperlink n then take a vlookup ..with that day file name as i tried using macro ..that open the old file only


can anyone help me on this ....
thanks in advance .....

Configuration: Windows XP Internet Explorer 6.0

Best answers for « hyperlink and vlookup » in :
Inserting an Hyperlink in an Excel Worksheet Show Creating an Hyperlink in an Excel Worksheet Introduction Implementation Linking to a Website Linking to a document Linking to another cell in the spreadsheet Notes Introduction Excel supports the use of hyperlinks and it is a very...
How to remove Hyperlink on copied text from website? Show How to remove Hyperlink on copied text from website? When copying information on website, obviously the hyperlink from the text will also appear on the edited text. To remove the hyperlink from the text, you need to right on the...
How to turn a URL into a hyperlink Show How to turn a URL into a hyperlink If you are using PHP, there is a simple way to turn a URL into a hyperlink when inserting the address into your PHP document. This process is mostly used to ease the users' search of external websites or...
Converting a URL to a clickable hyperlink ShowConverting a URL to a clickable hyperlink With regular expressions, it is possible to transform any hyperlink URL of the form http://URL (or ftp://URL) or beginning with www. :
Keyboard Shortcuts for Windows ShowKeyboard Shortcuts for Windows Windows System In a General Folder and text programs In a General Folder For a Selected Item a Folder For Microsoft Word For Microsoft Excel For Microsoft PowerPoint For Internet Explorer There are a...
Outlook- No image display ShowOutlook- No image display Under Windows XP Service Pack 2, you can no more open attachment because of virus infection You can disable the feature by following below procedure: (Valid for Outlook Express) Go to Menu Tools and...
Download MagicPDF Pro ShowMagicPDF Pro allows you to transform your electronic graphics and documents into Adobe PDF format with a professional output. It also offers other useful features like encryption, compression, embedding RGB, sRGB fonts, merging, active hyperlink,...
Download Note PP ShowDo you need a program to store your notes? Note PP allows you to store them in a single location. You can create as many notes as you like and add to them any type of information either hyperlink, phone books, to-do lists or catalogs, etc. Your...
Hyperlinks ShowIntroduction to anchors Hypertext links or hyperlinks (anchors) are HTML elements that, when clicked on, enable readers to visit a new address. Hyperlinked text is underlined by default. Hyperlinks are what connect web pages to one another. They...
Ask your question Reply

1

 venkat1926, on Jun 23, 2009 2:26:02 am BST

You can do vlookup from a closesd workbook without opening that workbook There are many solutions if you google search ("vlookup excel from closed workbooks")

an eample
suppose referece data is in Book1.xls which is saved in folder "desktop"

the new file is book2

if you type this formla

=VLOOKUP(A3,'C:\Documents and Settings\Administrator\Desktop\[Book1.xls]Sheet1'!A1:B100,2,FALSE)

you will get an answer without opening the book1.cls . note single quote and exclamation mark.

easier way in book1.xls ;name the raference range for e.g "data
then

=VLOOKUP(A3,'C:\Documents and Settings\Administrator\Desktop\[Book1.xls]'!data,2,FALSE)

   
Reply to venkat1926
Ask your question Reply
They need your help