link

  1. A

    VBA Select the excel file for your Vlookup Link

    Hello Guys. Please help me with my little Project. I have this project where i needed to link a database(Process2.excel) to another database(Process1.excel) so that it can automatically compute the offset adjustment(CNC Machinining) based from the Part ID's data from the previous process. The...
  2. V

    Turning 1 workbook link into a table

    I have 200 links to different workbooks that I need to turn into tables/data. =+'https://onedrive.com/Documents/[File1]Sheet1'!E1 =+'https://onedrive.com/Documents/[File2]Sheet1'!E1 =+'https://onedrive.com/Documents/[File3]Sheet1'!E1 ... =+'https://onedrive.com/Documents/[File200]Sheet1'!E1 I...
  3. J

    Extract href link from source code using VBA

    Below is the source code which i am getting after browsing a website I just want to copy link /search/Listing/45678489?source=results in excel and want to know how to click it class="details" is same for all href links that i want copy while id keep on incrementing mk:1:mk, ms:2:mk and so on
  4. L

    fonts names list (range.font.name)

    Hi Where can I find a list of all fonts? the link below does not give me the list https://docs.microsoft.com/en-us/office/vba/api/excel.font.name Thank you very much.
  5. M

    VBA to get content from internet

    Hi Need a help. In column A of sheet 1, I have links of certain section of company websites. I need to copy all the content from that section to sheet 2 of excel once all content got copied from first link move to 2nd link and copy all content and so on. however i also need an identifier...
  6. E

    Help needed to correct the formula

    Hi, I am sure, that I am missing something silly which is stopping me from getting the desired result. This formula is a small part of a project that I am working on. Can someone please look at the screenshot, and tell me what I am doing wrong? Condition: If C3 = NA and D3 ="" then E3 should...
  7. D

    Replace HYPERLINK formula with button

    I've created a link with the HYPERLINK formula which is using customer IDs from another cell inside the Hyperlink. Works like a charm. Now I've been trying to make the Excel a bit nicer looking. Is there any way to replace the links with a button or a button-like graphic so it doesn't just look...
  8. J

    VBA email with hyperlink to shared drive

    So I have a spreadsheet that sends an automated email - no problems there. I've run into a small issue when I want to insert a link to a folder on a shared drive. I have the code set up so the message body writes, ... update your training file at: S:\Training\Staff Training... where the S:\...
  9. P

    Graph help (Data Table)

    Hello experts, I am having difficultly graphing the attached. The original file in excel is a a data table (What If Analysis). link to file is below. <tbody> Price per Chair 500 750 1000 1250 Cost per Chair $200 $15000 52500 90000 127500 $175 $2500 33750 65000 96250 $150...
  10. L

    Insert Images to Excel Linked Word Table

    I have a VBA code that copies a seelction of cells from Excel and creates a Word table that is linked to the original document. I need to be able to insert images into the created word table. The table will allow me to do this, but each time the link to excel is refreshed the images disappear...
  11. M

    VBA Hyperlink

    Hi Guys, I am asking about hyperlink function in VBA, I have the following Label1 = "Link from excel cell" I need to add hyperlink to it and i did the following ThisWorkbook.FollowHyperlink Label1 and it works perfect, but what i need is (Friendly name) not to put the link shown in excel cell...
  12. L

    how to become excel 365 insider

    Hi I have office 365 student version. I went to to file-->acct as per the link below but I do not see Insider option. https://insider.office.com/en-us/join
  13. J

    VBA for Copy/Paste

    Hello! I am struggling with a function to link to a macro that requires me to copy a set of values from one sheet to another, while these values depending on a certain month that I link, and then asking the user a Yes or No question on if they want to replace these stored values for that month...
  14. M

    Multiple Pivot Charts With Linked Filter

    I have 3 pivot charts each with their own data source. The tables are all set up the exact same way. They have the exact same layout, just different numbers whether it's referencing a 6 month, 12 month, or 2 year projection. What I am trying to accomplish is I have all 3 pivot charts displayed...
  15. L

    I need creating vba code.

    red cells I want a vba code that only go that area Get File from Link before https://1drv.ms/x/s!AnJwxxiz0Ezpg8d44doit5nmxCco9A?e=b7ucl2 Ty Thomas
  16. S

    Scroll/Drag check boxes down and link to the new cell

    I am making a rather large list with checkboxes which is working well. When I want to expand the list, I have to individually edit each check box to be linked to the new cell. Is there a better way for when I drag a cell down by the bottom right corner that the new check boxes are linked to the...
  17. D

    Grabbing HTML data from hyperlinks in excel

    Hi all, I have a document with a column of 400 hyperlinks for different companies. Each link is to a website with a description of each company. The link leads to the same sight and while the description changes for each company the format and location of the description does not change from...
  18. Z

    Extracting YouTube views online using getElementsByClassName in VBA

    Hi there. My code is running and generating the necessary timestamps to viewership data from a YouTube link, however I can't seem to get the viewership to copy and print. Any help to extract this information from the YouTube code would be much appreciated. Thanks Here is a link as an example...
  19. F

    Trying to replace content in cells linked to another spreadsheet

    Have an odd problem when using excel in my computer. Everytime I try to update a cell in a spreadsheet that is already connected to another one, I being asked to find the file again and link it for every cell, this means that I need to go one by one selecting the file, rather than doing it...
  20. M

    Website Scrapping in excel

    I need query to scrape following website link data into excel spread sheet https://urlzs.com/11Wc9 There are 18,839 properties results appearing on above link. Fields I am looking to be exported into excel are price, location, telephone, square meters and the link of that property. 1st case...

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Syntax errors
    Good Morning, Trying to compile a workbook, I keep getting a few errors. Here are the first two: [code=rich]Syntax Error: Function...
Top