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...

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...

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

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...

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 -...

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?

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...

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...

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...

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...

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...

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 =...

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...

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"?

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...

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...

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...

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...

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...

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...