' Creates an Excel spread, extracts data from ' Tests for file exists and deletes if exists. Test if a folder exists and creates one if not. The mixed (yours and my code) is as follows.
#Excel worksheets sheet1 activate verizon code#
I have tried to merge your code with what I had working and I am at a loss. I can upload my working code, or atleast as far as I have it, if that will assist. all TX (Texas) records.Ĥ) Create a worksheet and name it based on that criteria (ex TX)ĥ) Add all records meeting that criteria to the worksheet,ħ) Loop back to 3 until all worksheets needing to be created, named and records added to it.Ĩ) Close the objects openned at their appropriate time.ĩ) Any error trapping one would deem necessary.
What I need is help, code preferably that will:ģ) Use a filter or other means to determine a records from the recordset that need to be added to a specific worksheet. I can currently load everything into one spreadsheet within a workbook. They provide insight into the options internal to the MS apps (vba and other techniques) and external (vbs and ADODB).ĪDODB is the solution I want. Been out of town and away from a terminal. Have built a process that can do one sheet, format it and everything, my problem is developing or finding code examples that can be adapted to dynamically create sheets. if Worksheet.Name("PAC") then last line on that Worksheet would be a COUNT of the # of records. Want a count of the # of records on each WORKSHEET. When the script is run, I want to end up with one WORKBOOK, and however many WORKSHEETS that I have region data for. Source Recordset has data for multiple regions (PAC, FLC, FLI, GL, TX, etc)įields contain Request Type, Store#, Date Requested, Date of Report, who requested. Used for retraining of cashiers that don't close out correctly and to raise issues with local mngmnt. Purpose: Report user requests for report reprints each month. Source is Access (SamirKumars source was Lotus Notes and I don't or cannot figure out equivalents of LotusScript in VBS).
I need to be able to dynamically create multiple spreadsheets via VBScript (not VBA within Access and Access specific commands, as was the solution for Mathiv's problem). Have a problem similar to Mathiv 9/21/01 Dynamically exporting Access report to separate excel sheets (MS Access) and SamirKumar's 1/16/02 Creating multiple worksheets in excel (Lotus Notes)
0 kommentar(er)
