![]() ![]() For that, click on the File > Save As option. ObjExcel.Rows(1).Interior.ColorIndex = 15Īfter entering the above script, you need to save the file with the. 'This code could be used to AutoFit a select number of columns Set objWorksheet1 = objWorkbook.Worksheets(1) Set objExcel = CreateObject("Excel.Application") Set objExcel = GetObject(,"Excel.Application") On Error Resume Next ' Turn on the error handling flag Below is the full script that you need to enter in the Notepad just copy from here and paste it into your Notepad: '= ![]() You now have to write a VBScript with related commands.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |