why no formula based hyperlinks will work in my workbook. even the simplest formula's. either it returns "cannot open specified file" or it does absolutely nothing even though the cursor acknowledges its a hyperlink.
View 5 RepliesI am having a slight problem copying hyperlinks. I have written some code that sorts data by date and then creates a simple diary. It originally placed the name of the event in the new diary sheet. What I would like to do is instead of copying the name into this new sheet copy a hyperlink that I have created to the company's website for that event.
I can create the hyperlink using hyperlink(B1,A1) where A1 is the company name and B1 is the web address but since the new sheet will not have the underlying data I need to actually copy the values and format of the hyperlink rather than the formula.
Another interesting dilemma to solve. Using this formula:
View 2 Replies View RelatedI'm creating a tool for some of my colleagues to use at work. So far, I have a series of check boxes setup that get the user determine if this is the proper tool or not. Once the appropriate check boxes are filled, I'm trying to get excel to give the user a link to the next step.
I have =IF(AND(followonconst=TRUE,Commercial=TRUE,fixedprice=TRUE),?????, "This tool cannot be used")
The names within the 'AND' operation are the references to the output of the check boxes, and all three must be true. What I'm trying to figure out is what I need to put where the question marks are.
Here's what I want to happen...Once all three boxes are checked, I want a link to show up that takes them to another tab in the same spreadsheet. Here's another possible hitch though, the users will likely save this tool into who knows what directory and rename it all sorts of things.
I am trying to hyperlink a cell to a file which contains a "#" in its name e.g. "AngloGold #1.xls"
Excel converts this to "AngloGold - 1.xls"
I have tried "AngloGold%20%231.xls", but that doesn't work.
When the value of E2 changes it does not refresh the hyper link value, any thoughts why
=HYPERLINK("E2","Click to View "&E2& " Full Report")
I have more than 10 textboxes. I would like to filter the data on another worksheet base on which textbox the user clicks on. I have tried the Worksheet_FollowHyperlink event, but it does not work with the textbox hyperlink.
View 5 Replies View RelatedI am performing a vlookup in a worksheet and want to retrieve a hyperlink displayed on another worksheet in the same workbook.
The Vlookup finds the item I am looking for, but the hyperlink comes in as text. Do I need to perform the vlookup differently when trying to retrieve a hyperlink?
I want to add hyperlinks to certain cells using drag and drop. I've got a userform with a toolbar that I use as a drop zone for files (called tbDrop). In the userform, below the dropzone is a label called "label2"
The dragging and dropping works as a charm, label2 shows me the file location and adds it as a hyperlink to the cell.
However, when I click the hyperlink the file can't be opened.
I've used the result string, added it manually as a hyperlink and recorded it. That worked, but i saw no difference in the recorded macro.
VB:
Private Sub tbDrop_OLEDragDrop(Data As MSComctlLib.DataObject, Effect As Long, Button As Integer, Shift As Integer, x As Single, y As Single)
Label2.Caption = ""
Dim a As String
[Code]....
I'm trying to insert a hyperlink to another excel file such that when you click on the link it opens that file up... When i go to insert a hyperlink and i select the file.. when i click on the file it says "the adress of this site is not valid. Check the address and try again" The file is on another drive on the server and i was wondering what the restrictions are in terms of where the files have to be in relativity to each other
View 4 Replies View RelatedI created a hyperlink to a .PDF and it works when I test it. However, when I save the file, go in later, and select the hyper link I am met with a 'Cannot open the specified file' message.
I have had this prior in Excel. The hyperlink works fine in Outlook, Word, and Access...
When you click on Cell C5 (which will say "ADD") I would Like the (Computer Browse Menu) to appear
you can then search for the file and press Attach
This will then create a hyperlink in that cell (or in a different cell) Saying "File Attached"
when you click on "File Attached" it will then open that file
I completly lost on how to do this
but here is the formula i have so far when it comes to click on the cell
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim arrValues
If Target.Count > 1 Then Exit Sub
If Intersect(Range("C5:C5000"), Target) Is Nothing Then Exit Sub
End Sub
I have an Excel 2003 application that creates a new workbook and adds hyperlinks that link up to other tabs withing the same new workbook.
Issue is that if say the default workbook name was "Book1" but the user saves this workbook with any other name, the hyperlinks die.
Is there anyway to use the current name of the file (instead of "Book1" in this example) in the formula "=HYPERLINK("[book1.xls]Sheet3!A1", "test")"
I'm having a problem with the HYPERLINK function. I am trying to make jumps from an index sheet to the large worksheet with all the actual info in it. The name of the file is SKU and the large info sheet is also called SKU. First I took the SKU sheet and numbered the rows (="A"&CELL("row",A1)), then in the index worksheet I created a VLOOKUP that finds the corresponding chapter title and returns that value.
Worksheet 1
A B C
1
2 100 =VLOOKUP(A2,SKU!$A$1:$B$3,2,FALSE) ="[SKU]SKU!"&VLOOKUP(A2,SKU!$A$1:$B$3,2,FALSE)
3 150 =VLOOKUP(A3,SKU!$A$1:$B$3,2,FALSE) ="[SKU]SKU!"&VLOOKUP(A3,SKU!$A$1:$B$3,2,FALSE)
I used the HYPERLINK formula in column D: "=HYPERLINK(C2,A2)" and it returns something that looks like the right thing but the link won't open.
I'm trying to create a hyperlink that takes a user to a specific cell (or range of cells) in an external workbook, and I've run into bit of a roadblock. I've discovered that using the method:
=HYPERLINK("[\serverfolder....file.xls]worksheet!range","message")
works just fine as long as there are no spaces in the worksheet name. Unfortunately I am trying to link to an external worksheet with spaces in the name (which I am not allowed to edit).
Basically I have a folder with file names in the format:
"XXXXX characterstring"
where X is a digit
E.g.:
45627 -jdsuuuds.pdf
93823 Coates.pdf
98221 dagggiisa d sass.pdf
And I have an excel sheet with a list of the numbers at the start of these file names, eg:
45627
93823
98221
So what I want to do is have each cell link to the file with the corresponding number. So I click "45627" and it links to "C:path45627 -jdsuuuds.pdf"
I could do it if the file names matched exactly to the cell value, but when they don't.
It's super easy when the file name matches exactly:
VB: ActiveCell.Hyperlinks.Add ActiveCell, "C:path" & ActiveCell & ".pdf"
VB:
Sub makelinks() ChDrive "c"
ChDir "c:pathl"
For Each ce In Selection
filee = Dir(ce.Value & "*.pdf")
[Code]....
Is it possible to do hyperlink to a specific cell in one of the tabs of another excel file? I managed to link to another excel but can't make it go to a particular cell.
View 11 Replies View RelatedI have a spreadsheet with hyperlinks to various file types (PDFs, Docs, etc.). Is there any way that I can have the hyperlinks update themselves automatically when I move one of those files to another location?
View 2 Replies View RelatedHow can I change the text color within a cell when I am using a concatenation formula? I have the following formula;
=" Total Bonus Earned ("&TEXT(A2/VLOOKUP($A$1,PR_DB,2,False),"#0.0%")&" of 2006 Earnings):"
In the text function portion I would like to format the result in red. An example of the result of my formula I am seeking is as follows; Total Bonus Earned (10% of 2006 Earnings): Do I need to create a custom format and if so how do I call it up within the text function?
I have a excel Product database and a Data Entry Userform. I can gte this to work fine but need to make some improvements to make it look professional.....here's what I am looking to do...:
1) When a user add a new product using the Data Entry form, I want the user to be able to add a hyperlink to the datasheet of that product and this hyperlink will then be saved in my database in column M of that product alongwith all other details in other columns. The DataSheet files are PDF files that are stored on the public drive. So I am hoping to use a browse function or similar to select the file to hyperlink to...
My current hyperlinks look like this which I have created manually directly into the column M (not through userform):
V:PublicCOMBData SheetsData SheetsXXXXX.pdf.............
I have the following formula =HYPERLINK(("G:ProjectTest Project"),"Link". Now this works fine, However I have a cell "A5" containing "Test Project" And I would rather the link refernced the cell contents So the code would look something like this; =HYPERLINK(("G:Project"+A5+"),"Link"). or something to that effect, this obviously doesnt work hence why I am here.
View 3 Replies View RelatedI made an excel sheet that links to other sheets on a different drive. It works while I am making it, but upon save and reopen all the hyperlinks produce this error: The address of this site is not valid. Check the address and try again.
Auto Merged Post Until 24 Hrs Passes;Figured it out. File, Properties, Summary tab, Hyperlink Box to base Drive. Auto Merged Post Until 24 Hrs Passes;Figured it out. File, Properties, Summary tab, Hyperlink Box to base Drive. Auto Merged Post Until 24 Hrs Passes;Figured it out. File, Properties, Summary tab, Hyperlink Box to base Drive. Figured it out. File, Properties, Summary tab, Hyperlink Box to base Drive.
I'm using the following UDF to extract URLs from hyperlinks on a sheet, so that people can click the hyperlinks, but the URLs for all the links also appear (in the cells with formula =GetUrl), but in a place where they're accessible but out of view:
View 2 Replies View RelatedBasically my sheet links may appear as a cell in another tab or it might be to an http address... Here is my formula I have setup up right now.. Only problem is, no matter what I put into the logical test to get a "true" result for the http addresses it still says false..
View 2 Replies View RelatedIs it possible to use the HYPERLINK function inside of a validation list?
Presently I have a dynamically named range on another worksheet that includes a hyperlinked term. When I attempt to create a validation list using this named range the term appears in the list without the hyperlink.
On sheet4 is a list of dates and I named that range as UPDATES2013. Each cell in that range is a hyperlink. Sheet1 cell I3 is a data validation list with the named range UPDATES2013 as the list. When a selection from Cell I3 is made I can get it to follow they hyperlink with the code I have. The problem I am having is if there is no file found, then I would like my Userform1 to show. I have tried several different things with the code, but every time I think Im going to get it to work....it doesn't. It either wont show the Userform at all, or it shows it even if the file is found. I am currently putting the code to run the macro on the worksheet module using the worksheet_change event.
One last thing...I also have hyperlinks throughout Sheet1 that will lead to the same files as in the named range UPDATES2013 from sheet4. I need the same thing to happen if they click one of these hyperlinks instead of using the data validation list in Cell I3. Is there a way to make one code that will show Useform1 if a hyperlink is selected and the file cannot be located (whether it be by the individual cells on sheet1...or the data validation list in Cell I3)?Here is the code I am using right now.
VB:
Private Sub Worksheet_Change(ByVal Target As Range)
DoFollow2013 ActiveCell
End Sub [code]....
I'm trying to add code that create a hyperlink to a file in a recently created folder in the path of L:Elec Dept ProjectsRELEASED FOR CONSTRUCTION". The code below should find the newly created *BOM*.xls created and created a hyperlink in the next available row starting on row 27 and column O on my worksheet "BOM". The code currently runs with no errors, but I'm not seeing any resulting text with path / links created.
View 5 Replies View RelatedI have an Excel file that has a persons name in column A, company name in column B, email address in column C and a hyperlink to a specific file to be sent with the email in column D.
I have the code to send the email and it works fine.
I've searched the net for mail merge and hyperlinks and have only become confused.
Here is what I want to do, attach the mail merge created file to the email, then the file associated with the hyperlink, I want to attach the actual file from the hyperlink into the email.
I read about Hyperlinks in the August 2006 "OZGRID" Newsletters but found no answer.
Assume 2 workbooks - book1 and book2, both located in "c:" (root of drive C)
Now, In book1 I have declared an HL to book2 using CTRL+K and upon clicking in that cell the book2 is opened.
After MOVING(!) book1 to a new location (D:DATA) and clicking the HL - I get an Error "cannot open the specified file".
While book1 was still in root C: - I tried to force to c:ook2.xls by typing it in the HL address window but after saving, Excel deletes the "c:" and leaves "book2.xls" only – I think because both files were located I the same directory.
I am aware that my "problem" can be solved by using the function HYPERLINK – but I would like to learn (if possible) how to insert an HL using CTRL+K that will maintain the path although moving the file which contains the HL).
I'm currently working on a problem that I'm having with Hyperlinks. Basically I want to copy the destination data that the hyperlink points to onto another sheet.
The main problem I'm having here is that I cant seem to find a suitable method to do this....I had the idea of using the hyperlink.follow function and then copying the data once I'm there and then moving back to the source hyperlink. My only problem with that is that I dont know how to find the cell address that the hyperlink is in, once I have found that hyperlink.
Therefore my question is two-fold:
- Is there a way to copy the destination data using some sort of hyperlink function?
- If not, is there a way to find the cell address within a worksheet, once a hyperlink is found on that worksheet?
I've attached the spreadsheet below to give a better idea of what Im doing, along with the "findHyperlinks" macro,within that workbook, that I am currently working on.