Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("\\Server\share on server\test.xls") Set objWorksheet = objWorkbook.Worksheets(1) objExcel.Visible = True objExcel.DisplayAlerts = True objWorksheet.Protect"password" objWorkbook.SaveAs "\\Server\share on server\test-123.xls" objExcel.Quit
|Pivot a table with 3 coulmns with two layers of header columns||3||36|
|VBA Delete selected Worksheets of each Workbook in a Folder||4||31|
|how to create a batch file with textfield and a submit button.||3||11|
Is there a Excel version of this http://blog.nkadesign.com/