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: *

  • Users: coswa
  • Order by date
  1. coswa

    Keyboard Maps and Toolbars

    I'm going to have to edit their existing keyboard maps or toolbars. Enough of them have customized settings that a new ekm file would be counter productive.
  2. coswa

    Keyboard Maps and Toolbars

    In the near future, I'm going to distribute a macro to a large number of users. I'd like to have this macro ran from either a keyboard remapping or from a toolbar icon. I'd rather not have to this manually. Is there any way to do either of these with nothing more than VBA? I'm planning on...
  3. coswa

    Macro counter

    Try using Access Sub Add_To_DB(MyThing1 as string, MyThing2 as string) Dim cmd as object Dim conn As Object, rs As Object, db As String, sql As String dim iCount as integer Set conn = CreateObject("ADODB.Connection") Set rs = CreateObject("ADODB.Recordset") set...
  4. coswa

    Overflow error using a CVDate function

    I am coding from attachmate: I'm exporting info to excel at the moment to research a parser for a notes screen. The set sys= CreateObject("Extra.System") statement is part of the boilerplate for setting up objects -- I've never had any problems with this on any other script before. the lines...
  5. coswa

    Overflow error using a CVDate function

    I'm getting an overflow error from a CVDate function. I have no idea what's causing it ... when I write a test program using input boxes instead of getstring, etc it works fine. I'm sure that there is something I did earlier in the listing that's messing it up somehow, but i really can't say...
  6. coswa

    Printing format for an Excel spreadsheet

    I just tried this, but I get an error message: Micosoft Office Excel: Unable to set the Zoom Property of the PageSetup class Taking it out results in nothing happening. Also, all the properties that include the letters "xl" that I got from recording/ pasting an excel macro result in unable...
  7. coswa

    Printing format for an Excel spreadsheet

    I'm trying to clear up a minor nuisance I'm having. I have several macros, running from Attachmate, that output Excel spreadsheets that print out slightly too wide to fit on one page. Obviously, it's not hard to just change it myself after the macro's done, but I'd like to be able to be...

Part and Inventory Search

Back
Top