There are many cases where we need to get the document property without the file being opened in VBA. This can be achieved by using the objects available in DSOFile.dll…. Read more »
PDF is always the universal format for sending the files. With lot of versions of MS Office and other Office suites around, it is always better to circulate the Deck… Read more »
PIVOT tables are a great way to summarize data but sometimes it is important to be able to split a PIVOT table out, generating multiple reports based off all the… Read more »
There are many cases where we want to have a Hyperlink on a cell that opens a document / image etc. In the following snippet we can see how that… Read more »
Here is a simple code that moves all the files from one folder to another using XCOPY. You can use all the options of XCOPY with VBA Sub Copy_Bunch_Of_Files() Shell… Read more »
Word Documents are everywhere – proposals, tenders, notes, technical papers. In many cases there are more than one authors and more than five reviewers. Just in case you get a… Read more »
Three factors affect the scheduling of a meeting in Outlook: The computer’s clock setting (time). The computer’s local time zone setting, which consists of an offset value to Greenwich mean… Read more »
There are many times when you need more than three sheets in a workbook. But when you use Workbooks.Add, it creates a New Workbook with three sheets (default for Microsoft… Read more »
You may have template sheet which you need to copy multiple times and rename these sheets according to the list (maybe on another sheet). Suppose you have a sheet named… Read more »
At times we set/reset registry settings/environment variables as part of the program logic. If another instance of the application uses this concurrently it would become a mess. The best is… Read more »