Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. icepirates1234

    Deleting Macro's

    Hello, I have a Macro that runs, and saves a document with whatever today's date is...The next step is when a user closes the Word application by clicking on the Red-X, I need all the VBA/(Macros) to delete from the visual basic editor. What would be a code to do that? Here is my current code...
  2. icepirates1234

    Can you have a dropdown pop-up box in Excel?

    Hey Groves, No worries, if I can help Ill definately do my best! Good luck! - J
  3. icepirates1234

    Can you have a dropdown pop-up box in Excel?

    Even though you were quite rude to me in my thread, I wanted to add something in here...PHV Suggested PHV (MIS) 3 Mar 09 15:12 Why not an UserForm ? I think he meant a user form - created in the VBE, would that work for you? Allow the user to select from a box that would pop up? If not...
  4. icepirates1234

    VBA - Retrieving Information From Excel (Displaying In Word)

    Hey you guys...Some of you dont have to be quite so rude...but Ive read the information about cross-posting, and I agree with it. Ill be more careful in the future before doing a cross post, and if I do, Ill provide links! Thanks to everyone
  5. icepirates1234

    VBA - Retrieving Information From Excel (Displaying In Word)

    Ive had an identical thread going here: http://www.mrexcel.com/forum/showthread.php?p=1859589&posted=1 A fellow has helped me out re-arranging the code to use a string like this: Selection.TypeText (CStr(myWB.Sheets("PayHist").Range("B" & 5))) Thread Solved! Thanks to everyone!
  6. icepirates1234

    VBA - Retrieving Information From Excel (Displaying In Word)

    Is it bad that I ask in more than one place for suggestions? The assistance on VBA Express has not been sufficient, so Im asking around to see what others think of my problem here... Regards,
  7. icepirates1234

    VBA - Retrieving Information From Excel (Displaying In Word)

    Hello, What Im trying to develop is this: (I have a Word document, that pulls information from an Excel document) (Thats essintially what this script does) A Macro that upon opening of a Word Document, a Macro executes and updates the information a Word Document from a source file which is an...
  8. icepirates1234

    CountIf Access

    Ok, now that I have tested a few things out, I also made some sample data with 9 rows, and attached it to this post. All the attempts and suggestions I tried failed... Im thinking this could work: UPDATE WELLS SET VolumeNum = DCount("*","WELLS","Number='" & [Number] & "' AND RowID<=" &...
  9. icepirates1234

    CountIf Access

    Hey, Thanks for your time...Ill explain a little more... There is a ID column that automatically gets assigned when a new record is entered. The data is already in order...but there can be three instances of a number like this: RowID Number VolumeNum 1 10-02-003-04-W5...
  10. icepirates1234

    CountIf Access

    Hello, Im in 'Table' view right now...and in Column 23 (Column Letter W) if you had to assign a letter, in my list there are sets of numbers like this: 02-03-005-09-W2 02-03-005-09-W2 The reason there is two numbers is because one is volume 1, one is volume 2... The table Im using is 100,000...

Part and Inventory Search

Back
Top