hyperlink

[Ravindra]

Dear All,


I would like to know how to make a hyperlink such that one can just open sheet according today's date.


Hint:- ServerAddressAssignment 18.xlsx

in above 18 sepecifies day of date which ,,I just want to take this day by =day(date()) thus on daily bases I can use this hyperlink address in =hyperlink(hyperlink-address;textname)

 

[Faseeh]

Hi Ravindra,


You mean sheet or workbook??

 

[Ravindra]

workbook

 

[Faseeh]

I created a sample "Test" folder on my desk top with this path address:

C:Documents and SettingsRizwan.zafar.MILLDesktoptest


In folder Test i created a file, BK18 (Today is 18th of Jan)


In Cell A1, i write TODAY(), in B1, wrote =TEXT(A1,"dd"). and in some other cell i wrote:


=HYPERLINK("C:Documents and SettingsRizwan.zafar.MILLDesktoptestBk"&B1&".xlsx")

...and clicking the hyperlink opened the file. Try this on your end.


Regards,