Free for PREMIUM members
Dim xlApp as Excel.Application
Dim xlWB Excel.Workbook
Dim xlWS as Excel.Worksheet
Set xlApp = New Excel.Application
Set xlWB = xlApp.Workbooks.Open("C:\Yourfilename.xls")
Set xlSH = xlWB.Sheets("YourWorkSheet")
if xlWS.AutoFilterMode = True then xlWS.AutoFilterMode = False
' clear up objects
set xlwb = nothing
set xlapp = nothing
setxlws = nothing
Open in new window
A B grade means the solution given lacked some information or required you to do a good amount of extra work to resolve the problem. When closing the question, the asker should explain why a B grade was awarded.
Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.