tags

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

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

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

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

Good afternoon Guru's, I've a question for you all. First, some history. I was here years ago to get some assistance with an offset code that had me spun, it took someone minutes to figure it out and it began journey down excel lane. Years later I am still not strong with complex formula...

Hi, I have an excel spreadsheet and in column A lists the photo name, such as Smith, John.jpg and so forth. In column B, I have the ID that is assoicated with that photo name. Each ID is different and there are never two ID's that are the same for a photo name. The goal is to have excel go...

Hi Everyone, I recently downloaded some data from Medi Tech and received the following date information. I have never seen the icon in front of the date. What is it? I cannot click on it or drill down into the date but it does not allow me to use the date as a date. it...

Hi, I am utilizing tags that are imported using a 3rd party program, and they gradually change over time. What I want to do is set up my program so that I can leave this workbook up continuously, and have the sub run every time the tag is updated. There are a variety of locations where these...

Hi, I am just a beginner in VBA. Appreciate your help in modifying the code below: Public Sub CommandButton2_Click() Call Sheet1.CommandButton1_Click Sheet8.Activate '101-WP-101 Sheets("Data Normalize").Range("T19:T30").Copy Destination:=Sheets("summary").Range("B12")...

Hi. I need to: - Import all files and file properties including but not limited to path and tags for a specific directory (including subdirectories) - Then I need to add tags to files manually on the tags column - And then add those tags back to the files.(excel or batch for csv file created...

Hi all, I am trying to extract a specific value from a static webpage. so far I come up with the following script: Sub Macro1() my_url = "http://www.investopedia.com/search/default.aspx?q=rog" Set my_obj = CreateObject("MSXML2.XMLHTTP") my_obj.Open "GET", my_url, False my_obj.send my_var =...

Hi Everyone, I have problem putting up html tags to every specific word in a cell. Let's say this praise. The above is a conversation and I'd like to put <'b> <'/b> at the beginning and end to make the talking character's name in bold format when i uploaded it in the internet. I target this...

Greetings, I would like help creating a document to harvest information (metadata) from digital images (jpegs and others) from within specific folders. Specifically, I want columns with Filename - Keywords - Title - Date Modified - Description. I appreciate any help you can provide. I am using...

I have created a form that when printed will be used as a rejection tag for isolating damaged or on-hold parts. Each tag that is printed must have a unique ID number. Is there a way to have excel automatically populate a field, giving each saved/printed tag a unique ID? For example, I open...

Hi, I need the VBA script in excel that will do a SQL Query, for this case I need to select a value where there are 2-3 tags and between certain period then display the result as a table in a worksheet. Example I have a database with 3 types of tags "Tag A", "Tag B", and "Tag C", and each tag...

I am trying to use a variable which will take the (string) value of a cell and update the "tags" on a SaveAs routine. I have been looking everywhere for a way to reference the "tags" field, under file, save as, but I cannot find it any references to it. I must be calling the field by the...