hyperlink

Hello, I am trying to hyperlink a file. The first part of the filename is constant but the end has a variable date. Is there a way to look at the constant portion only when referencing? For example the file's name is: "EarningsDiscrepancy_0069_2021_20220429_093447_5649" I would like for it to...

Hello there, I have a simple Hyperlink formula: =HYPERLINK("#Index!A7","Link") How can I make the sheet name and the cell dynamic?. Something like: Sheets("Summary").Cells(lastrow + 1, 8).Value = "=HYPERLINK(""#ActiveWorkbook.Worksheets(i).Name ! ActiveWorkbook.Worksheets(I).Cells(j...

Hi team, I am looking to have a column of hyperlinks (in say Row B), and have Column A be the cells that have the firendly name, which will be pulled from a list on a different sheet. EG: Cell A1=Data validation value. of "In Progress" and "Done" (The text here is not important, I...

Hi All, I need some help please and I can't seem to find any guides that cover this, so apologies if this is very novice. I have a drop down box and I am trying to get it to generate a hyperlink in the cell next to it, but assign a name (i.e. if url is www.google.com, give me a link that is...

Hello All, I am seeing some peculiar behave and I assume someone has seen this. I have and Excel spreadsheet (call it Summary.xlsx) on a company network drive (call it \\networkdrive\fold1\fold2). In a cell I create a hyperlink to a PDF file using \\networkdrive\fold1\fold2\fold3\file.xlsx...

Greetings all, I'm relatively new to VBA and I would like some help on a problem I'm trying to solve for. I have two columns of data and both of them are text initially. I first ran the VBA below to turn texts in the "Hyperlink" column into clickable links. However, I would also like them to...

Hello guys, I have an excel sheet in which I have many hyperlink. All hyperlinks have separate PDF files I want to print that PDF file when I click on hyperlink without opening it. Please help me with this.

Hi, I'm basically looking for a method to merged all filtered .pdfs based on "work pack" column into one pdf using the button shown, see image attached. Is this even possible? I've seen methods using Acrobat Pro which I do not own. If when I click the button, it generates a merged pdf file...

Hello, I have not posted here before but if someone could help me resolve this problem I would really appreciate it, as the other posts I have referenced have not been successful for me. I will lay out what my VBA form currently does. -User submits info into a request form... -This information...

In the Xl2bb shown below, you see in cell A3 the value A21 which is based on cell C21. The issue I have is when a listed program changes row number in sheet ProgramLocInfo then I need cell A3’s value to reflect that in the hyperlink. When a program changes row number in sheet ProgramLocInfo then...

I am currently in the midst of making a small library of links in Microsoft Team Excel. Where I have met a wall, where I cannot use the link, as they are redirected due to the including ampersand in the title. Example: xxxxxx.com/xxx/xxx/?action=show&product=301 Which is translated to...

Hallo, es darf kein Blattschutz und/oder Arbeitsmappenschutz aktiv sein. Hat der Name der Quelltabelle ein Leerzeichen ist es für den Ablauf des Makros kein Problem, aber der neue Name der Kommentartabelle darf keine Leerzeichen beinhalten und nicht zu lange sein. Das Makro fragt den Namen...

Hello, sheets and/or workbook shall not be protected. If the name of the source sheet consists of blanks this is no problem for the running of the macro, but the name of the new comment sheet shall not consist of blanks and shall not be too long. The macro asks for the name of the source...

Hello I hope some genius out there can help me. I have a cell in sheet 1(call it the source cell), hyperlinked to a hidden sheet. The text in the source cell and Sheet Name are the same, so when i select the cell, the hidden sheet opens. Here is the VB routine i am using: Private Sub...

Hi guys !!! How are you ? I need the VBA code fore Hyperlink. I have big DB and I want integrate Hyperlink to column E ( Report Number ). All reports scanned and store on the server Example ( Z:\QM\04_Piping\03_Visual & NDE Request Report\VISUAL 201 - FIELD ) Also I have 2 notes about the...

Hey guys ,im having trouble inserting a formula into a shape..and making it work can someone help me with it The Formula....=HYPERLINK("[6.Shop Workers.xlsx]"&ADDRESS(1,1,,,$G$3),"Click") ABCDEFGHIJKLMNOPQRSTU123101JebastinSalary Date4501-08-2020678Salary 10,0009101112Leave0ClickTotal...

Hello, I am trying to copy a hyperlink from cell A2 from Worksheet 2 to cell B3 of worksheet 1. The text in both cells should remain unchanged. Any help would be very much appreciated. Thank you in advance Kristina

Hi, i am wondering if this possible. I have created a little database within excel. One table i have in this database is the following (see below). These "From and "To" fields are for a serial number. The user enters a serial number on a userform, and it pulls through the row from this table...

Hi , I want to create a Hyperlink in Sheet2 of column 1, that direct to the address mentioned in sheet2(Rowno and Column) to Sheet1. Attached the Excel Sheet for your reference. Thank you in advance. Sheet1...

Hi all, I have been playing with this little project recently which, as the thread title states, allows for adding an hyperlink to the native vba MsgBox. At the moment, I managed to make this work with only one hyperlink per MsgBox... This little "tool"can come as a handy, a quicker and a more...