hyperlink address

Ok, all, first time posting on any forum. Just been sitting in the back, reading and learning. But now I'm stuck and decided to ask for help. I need to assign a created image with a hyperlink to a hidden sheet, using a variable address based on the value of a cell. EV36 would be the location of...

Hi guys. Is there a way to edit the below formula so that the worksheet name is referenced to a cell?? - "2020" is a cell. =HYPERLINK("#"&ADDRESS(MATCH(A4,'2020'!A:A,0),8,1,1,"2020"),"Link")

Good Morning, I am trying to hyperlink to google maps but in doing so I am also trying to substitute two values (postcodes) on my spreadsheet into the address from and the address to. For example: =HYPERLINK("https://maps.google.co.uk/maps?saddr="&SUBSTITUTE(C8,"...

<tbody> A B C D ... X Y Z AA 1 2 Dates 8/30/16 ... 4/13/17 4/14/17 4/15/17 4/16/17 3 Description Start Date End Date 4 Foundation Concrete Pour 4/13/17 4/16/17 20 20 20 20 5 </tbody> I have a table with items and the time each takes to be...

Sub Report() MsgBox "Report is ready to use" End Sub So far I have something like this, but I would like to add a hyperlink of report's path. If the report's path is C:\Program Files\Acute Data_1000.xlsx is it possible to include a hyperlink on the message box? Thank you!

Hi ! Greetings from Paris :) ! I've just started playing with VBA, macros, and all this stuff on excel. I've created this macro: Sub MiPrimeraMacro() With Worksheets(1) .Hyperlinks.Add Anchor:=.Range("i2"), _ Address:=("http://www.apple.com/" & Range("i2")), _ ScreenTip:="Apple link" End...

I am using Excel 2003 I use the next method to open a file located in the same folder of the current xls file right click, hyperlink, choose Existing File or Webpage, choose desired file but I want to open a file in a folder relative to where the current file is located, so when they are moved...

Hello All, I'm trying to create a series of Macros that take the contents of Column E, puts a direct hyperlink to website in question. I just can't seem to find the code online to help me achieve what I want. This is the code I have so far. Dim sh1 As Worksheet Dim...

hyperlink w/in excel loses reference this is the situation person cell id hyperlink Adams b20 b20 Jones b50 b50 Zilch b99 b99 If I create a hyperlink at Zilch to Jones the hyperlink = b50 then if I add a person above Jones (b50), the Jones info moves down and...

Hello dear I have a hyper link in cell A2. Value of the cell is "1st link" and hyperlink address is "http://1stlink/add.php". Now I want that valu of B2 cell will be "http://1stlink/add.php" I want to do that work in vba. How can I do that, plz help me.

Hi all, I have a question that I have not been able to work out. I have a 9 digit number in cell B2 and need to set the folder in VBA based on the number. Part of the map involves the first number of the 9 digit number so as an example: Cell B2: 231231231 Folder map would be...

Hi Board of Genius' Can anybody help me to achieve this, at all, please? I currently have a Hyperlink Cell (C10) which, when clicked, takes the user externally to Google maps at the address as inputted into a number of Cells: User Cells: B6 = "House Name / Number" B7 = "Street" B8 = "Town"...

I have an Excel report 'Report A' which contains hyperlinks to other files. The hyperlink is also copied from 'Report A' to 'Report B' and other reports which are distributed to users. Therefore the hyperlink needs to contain the absolute address. Excel replaces the absolute address with a...

I am creating a yearly report for my company, and I have an email column that we can enter in the individual’s email address in the cell. When we click on the email address it does what it is supposed to do; however, I want to go a step beyond that. I want the email to prefill the subject line...

Hello people, I am having a bit of trouble inserting a dynamic hyperlink into an Email that will be generated from Excel, linking to a newly saved document. there is a macro, which seems to work fine, calling a function that seems to hold the error. here is the macro: (Please note that the...

I have a list of 300 linkedin links. I want to create a macro to open the links and and capture the current title in the link. Is it possible ?

Hi All, I have a spreadsheet with 15 sheets and this includes a 1st quarter, 2nd quarter, 3rd quarter, 4th quarter and monthly report sheet. The quarterly sheets have around 1,000 lines and list a lot of expenses and income by different categories. The monthly report sheet takes the total of...

i use PC and a couple of my clients use MAC. I use Office 2010 Clients use 2011 it seems that when they take a spread sheet that I make for the and they save it as another name on the MAC, the hyperlinks disapear. Any way to prevent this?

Hi Folks, I am trying to make a workbook that will basically be a document index to files on a network drive. So what i wish to be able to do is have a button on the worksheet that will check for the next empty cell in a coloum and then open a browse window so i can look for a file on the...

Hello, I am trying to make a list of files in excel. each cell needs to have a hyperlink, so when I click on the cell content it opens the file. With excel 2003 I used this code: With ActiveSheet i = 0 For Each rngCell In .Range("A1:A65530") i = i + 1 A$ = Cells(i, 2).Value + Cells(i...