![]() ObjWorkBook.SaveAs("C:\Users\mmcginn\Desktop\Software-Inventory.xls") Set objXL = CreateObject("Excel.Application") Here is the problem, be default Excel opens with 3 tabs (worksheets) and on those worksheets it works like a charm BUT it will not create any new worksheets (won't go beyond the 3rd tab). Then when it's done it creates another worksheet, names it after the next server on the list - wash - rinse and repeat. ![]() One at a time (for loop) it goes out, uses WMI and a registry check (pull actual version) and writes This script also creates an Excel spreadhseet and is supposed to create a tab named after each server (server name for the individual worksheets). ![]() ![]() I wrote this script in VB to pull software inventory from a list of servers which I stored in an array. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |