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...
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 =...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.