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!

Register Log in
  • Congratulations Chriss 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. mkjp2011

    Where is this thing getting it

    Hello I created two kourne scripts on our Unix Systems. The first script (fileListener) is called by the CRON every minute. This program waits for the existence of a trigger file (.trg). This trigger file has three lines in it, (1) Email address, (2) data file name, (3) schema file. Once it...
  2. mkjp2011

    Add new Sheet

    Hello, I am trying to add a new sheet to an active workbook. Below is the code that I am trying to use, but I keep getting a error that reads invalid object. Set excelReport = CreateObject("Excel.Application") excelReport.Workbooks.Add Set excelSheet1 =...
  3. mkjp2011

    Dialog Problem

    I keep getting this error _______________________________________________ Statement is not available for this control Line Number: 1120 Stopping Macro Playback. _______________________________________________ Why am I getting this error. Here is the Dialog code and its function code: Sub...
  4. mkjp2011

    Dialog Box Problem

    That actually pointed me into the right direction. Thank you for helping. The thought behind the process was really simple thank you!
  5. mkjp2011

    Dialog Box Problem

    Hello, I made this dialog box. However How do I check what the values were after the user goes through that dialog box? Here is the dialog box Begin Dialog selectionsDialog 200,235, "Select Attributes Desired" CheckBox 15,16,64,12, "Customer Name", .Checkbox1 CheckBox...
  6. mkjp2011

    Renaming a Sheet

    How would I set the name of an excel sheet. I would use the following code to access the sheet object Set excelReport = CreateObject("Excel.Application") excelReport.Workbooks.Add Set excelSheet1 = excelReport.ActiveWorkbook.WorkSheets(1) Set excelSheet2 =...
  7. mkjp2011

    Formatting a cell

    Hello, How would you change the formatting of a cell from Number to Custom 0? Also, how would you add borders to the cell? Here is how I instantiate the excel object: Set excelReport = CreateObject("Excel.Application") excelReport.Workbooks.Add Set excelSheet1 =...
  8. mkjp2011

    Manipulating Excel: How to change cell Color

    Set excelReport = CreateObject("Excel.Application") excelReport.Workbooks.Add Set objSheet1 = excelReport.ActiveWorkbook.WorkSheets(1)
  9. mkjp2011

    Looking at Attachmates values

    How can I reference the number of keys pressed and saved? You can find this value in the bottom right hand section of the toolbar.
  10. mkjp2011

    Manipulating Excel: How to change cell Color

    How can I change the background color of one cell within a EXTRA! Basic Macro?
  11. mkjp2011

    Searching Column for text in Excel

    I tried that yesterday and it worked. However once I do this, if it comes across something that is not in that column then the macro stops the macro and says Object value is set to Nothing; stopping macro playback. How could I avoid this?
  12. mkjp2011

    Searching Column for text in Excel

    I tried that already. Still the same error. Yes I am a programmer and I usually don't have to use forums.
  13. mkjp2011

    Searching Column for text in Excel

    I tried this, however Range must not be supported. Because it tells me 'Range' is not a record type. What could be the reason?
  14. mkjp2011

    Searching Column for text in Excel

    This works great! However now I run into the problem, where if that certain text is not found then it returns an unknown value and stops my script. How do I handle the situation if the value is not found?
  15. mkjp2011

    Searching Column for text in Excel

    I am trying to search the first column of my excel document using EXTRA! Basic. How would I search that column for a specific text value and then return the row it was found out? Is this possible?

Part and Inventory Search

Back
Top