I have a workbook(MyWorkbook) with a sheet(Products) the Products sheet is hidden and becomes unhidden as soon as you enable your macros. The Products sheet contains a range of data that I get from a view in SQL. I would like to automate the refreshing of data in the Products sheet without opening the workbook. I'm not familiar with Scripting as this is probably what is going to be needed. :-)
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.