tags

  1. C

    I'm going to try this again... IF/THEN issue

    I need a formula for cell D2. I apologize but not using excel frequently I have lost so much knowledge I had before with an IF/THEN statement. I'm making a spreadsheet (simple) with B2 being a validation cell with LIST. In the list are the following... TAGS - Metal Detectable Hardback TAGS -...
  2. S

    Error when posting - Number of tags exceeded maximum amount

    Hi All Trying to post a question and I have included two tables, but for some reason I get the error message "The number of tags you tried to add exceeded the maximum number of tags by 1" Is there anything I can do to fix this?
  3. trishcollins

    Concatenate array elements based on search results of a single cell

    I have a table with a column named "Description" and another column "Tags". I have a named range "tag_data" that lists all the tags I want to search for in the description, and then concatenate the tags into the Tag Column: I am using a function I named ConcatenateArrary based on a...
  4. J

    Can't find META tags in HTML when using WinHTTP Request

    Hi all, I am trying to locate Meta tags from the following URL: https://england.shelter.org.uk/professional_resources/policy_and_research/policy_library/policy_library_folder/2020_group_-_fiscal_stimulus_paper However, what is passed from the result string to HTMLDoc.body.all is only a...
  5. S

    Windows Explorer tag search

    I would like to set up a link from a cell to open an Explorer window and search for tags that match the cell's contents. An example would be: 1. Click a cell that reads "Golf". 2. An Explorer window opens and automatically searches for any files tagged with the word "Golf". I already have a...
  6. S

    Formula to Switch places

    Good Afternoon Excel Gurus, Need help from the gurus with a quick formula to achieve the following result. I have a lot of sheets to fix and all sheets have 1000's of rows. Column A has tags starting with numbers and some starting with characters. I am trying to write a formula that can...
  7. I

    copying all details of scanned tags

    Please help me to make a program using excel which I can use in my current work. As you can see I have a series of inputs from column A to column F. What I want to happen is when I input a tag or series of tags on column H starting at H3, it will scan all tags at column C and all similar tags...
  8. A

    JSON Converssion Question

    I can successfully parse the CA Agile Rally API to return information into a worksheet, but the information returned in the description field is full of HTML tags. Is there any way to pull or publish the data in that field without the HTML tags? Sample Code: URL =...
  9. K

    Excel 2016 Mac vs. Windows (Adding Tags)

    This post is regarding the addition of tags to spreadsheets on Macs vs Windows, Excel 2016. For my Excel Spreadsheet class, one of our directions after every assignment is to add some words in the 'tags' section based on the assignment. When I create a spreadsheet on my desktop, which has...
  10. H

    make cumulative total

    Frank here. Can anyone help me work out how to: A1 to A60 are numeric. I want Column 'B' to make a progressive descending total of Column 'A' figures. New at this so yes help would be great, Thanks, F PS: What does it mean when it says here something about 'Tags"?
  11. D

    Moderator please fix

    Hi Guys, don't know what the poster has done here: https://www.mrexcel.com/forum/excel-questions/1048832-excel-vba-website-tr-td-loop.html but it looks as though the whole page is inside a set of code tags (or two) My response is 'trapped' in there too. It's a pain to scroll through the...
  12. P

    VBA to Create PDF File on Sharepoint and set .ContentTypeProperties() values

    HI, Using VBA I'm able to create and save an excel file to SharePoint and set relevant tags using the .ContentTypeProperties() value. In order to publish the spreadsheet I want to create a PDF version in the same location, but seem to be unable to do so because the 'tags' aren't set...
  13. D

    Convert AB RSLogix tags

    Good morning! I have a need to convert Allen Bradley RSLogix tags from one format to another. I can save the tags into a .csv and open in Excel. I would like to write a macro to convert them into another format. Here's an example: Old format: New Format: N11:0/0...
  14. K

    Auto-Create Worksheets

    I have a file that creates barcodes in a specific format. The trouble is, you can only make 24 at a time before you have to print them. I'd like to have a way that you can crate as many as needed and, as the sheet fills up, another sheet gets created and so on... You scan on 'Scan Sheet' It...
  15. H

    CODE and HTML tags

    Hello; Because of the CODE and HTML tags used for posting codes in the forum, the VBA code i have posted in the link below is not the same as i have posted. https://www.mrexcel.com/forum/excel-questions/1033472-extract-text-span-element-xml.html I tried to turn OFF and ON the tags but...
  16. R

    Scrape li tags tat shares the same class name

    Hi Everyone. i am trying to scrape li tags that shares the same class name the HTML cods looks like this: <ul class="top-section-list" data-selenium="highlightList"> <li class="top-section-list-item">sample text# 1</li> <li...
  17. F

    Convert HTML option tags into Excel

    Does anyone know how I can take a text file with html option tags and convert them into two columns with multiple rows in Excel? Any assistance is greatly appreciated!!
  18. D

    Modifying the custom ribbon with VBA

    Hi, I have a custom ribbon with controls that I have tags associated to. I can change visibility of groups and controls by changing the tag property: Call RefreshRibbon(Tag:="MyGroup1") I was wondering if there is a possibility of making the same by not changing the tag property, but directly...
  19. A

    Excel macro to find words in all caps then surround them in an html tag (e.g., <b> and </b>

    Hello! I need an Excel macro that finds words or phrases in uppercase, then surrounds them with the html tags for bold. The uppercase words can have as few as 2 letters like "NO", and there can be more than 1 word in uppercase, in which case I want the tags to surround all uppercase words that...
  20. J

    Formatting issues when using [code] tags to post code to threads

    Hi, I use code tags to post code in threads aka Sub Macro1() 'Some code End Sub Usually, I write the code in the VBE to test, then copy and paste to the thread inside the code tags. Unfortunately, it seems to add extra "lines" in between the code, usually after Sub, which means I then edit...

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