tags

  1. JackDanIce

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

    Count if unique and tag, else create new tag based on criteria

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

    Placing an ID into a Photo Tag

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

    Never saw this before - What is it?

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

    Automatic sub run using external data tags

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

    Summing up Duplicate Values in Excel Using VBA

    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")...
  7. A

    File Tags

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

    VBA Parsing the webpage for a specific value between tags

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

    Html Tags for Specific Words in a Cell

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

    Collecting metadata from photos

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

    Giving a form a unique ID number

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

    Create SQL Query in VBA and display result as table in Worksheet

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

    Finding Tags inside of VBA coding.

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

Some videos you may like

This Week's Hot Topics

Top