Tag Archive


accdb repair access recovery access repair Data Backup Database Data Loss Data Recovery Excel corruption excel recovery Excel tips Excel VBA fix zip Hard Drive mdb repair mdf recovery MDF repair Ms Access outlook outlook contacts outlook recovery Outlook repair outlook VBA pst recovery pst repair Quick Access Toolbar recover access recover excel recover outlook recover PST recover sql Registry Editor repair access repair excel repair outlook repair pst repair zip SQL recovery SQL Server sql server recovery VBA View Settings Word Macro word tips zip recovery zip repair

How to Create a Project Schedule with “Click-and-Drag” in Excel

The following article shows how to mark out and interrogate a calendar with the mouse. *In the real world, we’d open a form to read and write meaningful diary entries to a database. This exercise simply reveals the mechanics of right_clicking, and finds the details from the worksheet itself. Before we begin, a few words […]

How to Standardize the Texts in Your Spreadsheet with Excel VBA

We’ve all seen spreadsheet names and addresses with a mix of formats like JAMES JONES, sARAH bERNARDT or clint eastwood, all of which look amateurish on a report. This article shows how to standardise text in the proper way in a worksheet. This article assumes the reader has the Developer ribbon displayed and is familiar […]

How to Call a SQL Server Stored Procedure from Excel VBA

Data on a server can be modified by examining the records ‘client-side’ in Excel VBA, changing them as required, and saving them back to the server. A more efficient way of doing this, particularly if the database is at a remote location and there’s a lot of traffic involved, is to do the work ‘server-side’. […]