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

    CHR(13) does not work sometimes

    chr(13) (and "^p") in a VBA macro is sometimes skipped when the macro is run. The macro is intended to insert various predefined strings into a word doc. Example: istring(1) = "This is some text" istring(2) = "This is more text that appears in a new paragraph" Set objselection =...
  2. reggie55555

    Replace string with formatted bullet in word

    I'm using an excel macro to find/replace a string with a formatted bullet in word. The code I'm using inserts a symbol and the formatting does not apply (i.e., the bulleted text does not allign with an indent). I need an actual bullet. Any ideas? wdAPP.Selection.Find.ClearFormatting...
  3. reggie55555

    First blank row in Excel

    I think this is a simple one but I can't get the syntax correct. I need to find the first blank row in excel and input some data. I can do this in VB but can't quite tweak it to work with Extra. Any suggestions? Here is my macro, I want to go to the first blank row instead of "A1" Sub Main...
  4. reggie55555

    Macro counter

    I'm wondering if anyone has come up with a solution to count how many times a macro is executed. We have some macros distributed to multiple users and I'd like to know how many times they run them. I thought of including some script to have a tally produced on a central excel spreadsheet but I...
  5. reggie55555

    Control textbox in frame of 3rd party IE App

    I'm trying to scrape data from Attachmate and export to a custom screen panel on an app hosted in IE. With a little help from this forum I've got code functioning but I can't get the data to populate. Any thoughts on how to get control of the panel? Here's my code so far. The issue I have is...

Part and Inventory Search

Back
Top