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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
Autofill in Excel
Const xlEdgeTop = 8 Const xlEdgeRight = 10 Const xlContinuous = 1 Const xlThin = 2 Set objXL = CreateObject("Excel.Application") objXL.Visible = Visible Call NewSpreadsheet(x) objXL.Quit Function NewSpreadsheet(numPLC) objXL.Workbooks.Add objXL.Worksheets(1).Name = "PLC1"... -
Autofill in Excel
Thanks for the quick response PHV, I know about the macro recorder. I'm not sure how to adapt the following to VBScript, because I keep getting errors: Range("A3").Select ActiveCell.FormulaR1C1 = "I 0.0" Range("A3").Select Selection.AutoFill Destination:=Range("A3:A17")... -
Autofill in Excel
This should be easy, but I'm having a hard time getting the format correct. I just want to select say cells(1,1) and do a default autofill from Range("A1:A10"), but I'm not sure how to write it in VBScript. Thanks -
-
Outputting to com ports
I was hoping to avoid paying for an ActiveX DLL in which I'm only using a small portion of it. -
Outputting to com ports
I can output a string to com port 1 with the following code: Dim fs, b Set fs = CreateObject("Scripting.FileSystemObject") Set b = fs.CreateTextFile("COM1:",True) b.Write &hFFFFFF I'm trying to send data to COM1's base address, 0x3F8 (to send data) and an offset address 0x3FC (to control the...
