eagle4life69 Posted March 1, 2006 Share Posted March 1, 2006 Okay here is my problem and need some help getting it going. (just a start) first What is UDF. second on my job we set up a nightly schedule and it has most of the same thing in each night. what we do is look to see what needs to be ran and compile a huge list of what is to be ran. each job can have up to 30 lines in excel. Question: How would I compile many differant excel sections into 1 excel sheet. if you need some examples of what I mean let me know. I do know how to do check marks and stuff like that but I have never tried to write excel I do need to have some boxs with lines around it. Please help Thanks again. Link to comment Share on other sites More sharing options...
seandisanti Posted March 1, 2006 Share Posted March 1, 2006 Okay here is my problem and need some help getting it going. (just a start) first What is UDF. second on my job we set up a nightly schedule and it has most of the same thing in each night. what we do is look to see what needs to be ran and compile a huge list of what is to be ran. each job can have up to 30 lines in excel.Question:How would I compile many differant excel sections into 1 excel sheet.if you need some examples of what I mean let me know.I do know how to do check marks and stuff like that but I have never tried to write excel I do need to have some boxs with lines around it.Please help Thanks again.sample data would help. Link to comment Share on other sites More sharing options...
eagle4life69 Posted March 1, 2006 Author Share Posted March 1, 2006 I'll post some around 7:00 PM PST Link to comment Share on other sites More sharing options...
seandisanti Posted March 1, 2006 Share Posted March 1, 2006 I'll post some around 7:00 PM PSTthat's when i'm out of here, and won't even be home before 10pm; going out for my birthday. Smoke should be on shift by then though i'm sure, and he's more than capable. i'll try to remember to check back in whenever i do get home Link to comment Share on other sites More sharing options...
Stumpii Posted March 2, 2006 Share Posted March 2, 2006 that's when i'm out of here, and won't even be home before 10pm; going out for my birthday. Smoke should be on shift by then though i'm sure, and he's more than capable. i'll try to remember to check back in whenever i do get homeWell HAPPY BIRTHDAY “Give a man a script; you have helped him for today. Teach a man to script; and you will not have to hear him whine for help.”AutoIt4UE - Custom AutoIt toolbar and wordfile for UltraEdit/UEStudio users.AutoIt Graphical Debugger - A graphical debugger for AutoIt.SimMetrics COM Wrapper - Calculate string similarity. Link to comment Share on other sites More sharing options...
eagle4life69 Posted March 2, 2006 Author Share Posted March 2, 2006 Here is an example. The file only has 2 examples in it but normally we have about 46 pages worth of these type of instruction. we also add other text that fixs with some of these instructions. it is in a PDF my excel format will not upload but you should get the Idea (I hope) pretty much it will be my schedule createrexample.pdf Link to comment Share on other sites More sharing options...
flyingboz Posted March 2, 2006 Share Posted March 2, 2006 If you don't have au3 3.1,current beta, SciTE DOWNLOAD it/them. If necessary, INSTALL it/them. READ THE BETA HELPFILE, especially wrt COM/OBJ functions / explanations (this will help you understand a little about what you are trying to do. Functions ... (This will help you understand what kinds of things you can do.) Examples... These demonstrate how the syntax operates. PERUSE the Excel Object Model from MSDN PERUSE THE FORUMS , in particular, searches like +COM +EXCEL or +OBJ +EXCEL will prove useful. Using the macro recorder in Excel, examine the code created for clues to properties / methods that have a bearing on what you are trying to accomplish. You will notice, randallc, myself, and others who have posted various UDFs and snippets that have some bearing an what you are trying to do. EXAMINE these for clues about syntax, as well as properties/methods you have not yet mastered. EXPERIMENT w/ the sample code, and EXTEND it to accomplish your tasks. Reading the help file before you post... Not only will it make you look smarter, it will make you smarter. Link to comment Share on other sites More sharing options...
randallc Posted March 2, 2006 Share Posted March 2, 2006 Hi, I agree; if you want to try the Excelcom UDF, start with [Link in my signature; install beta/ excelcom.au3 toyour "include" directory as per instructions] "XLsyntaxshort1.au3" Then look at XLReadLine (ie from one sheet/ address) and XLPasteLine (XLWriteLine not working at present?)(ie to another sheet/ address) this should get you started. Best, Randall ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now