Need this done in next few hrs, basically i have a project that needs to be edited a bit. I have the code already but need changes instead 1. Do not insert filename into the excel document 2. Basically need a tab delimited dump of the excel file into a flat file(will provide code), this includes each row of data, even if its empty. The flat file should keep same filename and add .txt to extension. 3. need to insert a column heading as the first line, basically first column should say "DELETE ME" then tab delimited 20 spaces, then next column is record count of excel sheet minus first column heading row and any blank rows that may be inbetween, then third column is record count of flat file minus the header and column heading rows. the data then insert same space and column so it matches the rest of the rows. since there are 8 columns of data, first three is 'DELETE ME' tab20 rowcountexcel tab20 rowcountflat tab20 space tab20 so that it makes 4. Archive excel file with date/time stamp appended on it and save in archive folder. Delete existing excel file That's it. I need it fast, should be simple. providing old code and such for example. example of code that need to switch too, see how utilize the [url removed, login to view] feature, just dump all data to flat file, the name needs to keep inbound name and make .xls to .txt Const xlText = 20 Dim oExcel = CreateObject("[url removed, login to view]") [url removed, login to view]("C:\temp\[url removed, login to view]") Dim ws = [url removed, login to view](1) [url removed, login to view]() [url removed, login to view]() [url removed, login to view] = False [url removed, login to view]("C:\temp\[url removed, login to view]", xlText) [url removed, login to view]() [url removed, login to view]()
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
[url removed, login to view]