![]() ![]() ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |