1. A

    Search Files by Tags

    I am very new to VBA and have been learning as I go on a work project. One of the things that was requested was to have a search bar to find other files of a similar problem solving event. What I want to be able to do to have a vba program that opens file explorer and searches by tags. but all...
  2. F

    VBA optimisation - takes too long to process

    Hi guys! first time posting here. I'm french canadian so sorry about my poor english. So basically i wanna make like a little database on Excel with notes/jurisprudence/doctrine/laws and for every entry that i add on this sheet, i'm giving the notes/jurisprudence/doctrine/laws a tag on the...
  3. D

    XML Maps and Empty Tags

    This is part of my xml I can map everything just fine except <Lost_agreement /> After i export mapped XML, <Lost_agreement /> is missing. it becomes But <Lost_agreement /> part is crucial and must be. How can i achieve it? Quote Reply Report
  4. V

    Scheduling Sheet

    Anyone able to provide some quick help? I have a worksheet I am working with to schedule fabrication. I need two macros to format the sheet and a background process. Macro 1: Button Labeled "Fab Start"; sorts by Column I "Planned Start" oldest to newest creates...
  5. 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 -...
  6. 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?
  7. 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...
  8. 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...
  9. 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...
  10. sakrams

    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...
  11. 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...
  12. 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 =...
  13. 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...
  14. 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"?
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back