How to automatically create and update Visio diagrams from Excel

To successfully create Visio diagrams from Excel, Visio Pro for Office 365 is required. Here you can see the prices or download trial. Open Excel (I have latest release of Excel from Office 365 suite) In the search box, type "process" and hit Enter. Among other search results, 2 Excel templates should appear with Excel … Continue reading How to automatically create and update Visio diagrams from Excel

How to start Word with a specific template

Open Word the usual way. In the template selection view, select the template you want and click Create. For example, Blog Post. When Word opened your document, click Save As and select Word Template in the Save as type drop-down box. Path should change automatically to your Custom Office Templates directory. Give your template a … Continue reading How to start Word with a specific template

Find computer name for a remote computer using PSExec

Let’s say you know the IP address of a computer but you don’t know the hostname. Seems to be an easy task with ping –a, if you have a working DNS If not, you can try the following approach: Create a cmd on client’s computer. Say in \\IP\C$\Windows\Temp\FindHostname.cmd Edit FindHostname.cmd. Type in: echo %computername% >> … Continue reading Find computer name for a remote computer using PSExec