Search results for query: *

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

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

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

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

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

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

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

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

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.

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

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?

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

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

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?

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?