Erlandsen Data ConsultingOn this web site you will find:
- Information about services from EDC.
- Useful tips about Excel and VBA programming.
- Other more or less interesting computer stuff that might be helpful.
Use the Search-functionality, the Categories list or the Archives dropdown on the right-hand side of the page to find the information you are looking for.
Recent Posts
- Save Multiple PDF Files In Shorter Time
- Retrieving Filenames From A Folder
- Import Data From Multiple Workbooks
- Error Message “Data source reference is not valid”
- Retrieve A Worksheet Based On The Worksheet Contents
- Retrieve A Worksheet Based On The Worksheet Name
- Break Links To Embedded OLE Objects In PowerPoint Presentations
- Calculate Date Differences
- A Couple Of Useful Workbook Functions
- Getting Filenames In Other Applications Than Excel
- Quickly Delete Rows In A Worksheet
- Remove Missing PivotField Items
- Protect all cells containing formulas in a worksheet
- Update All PivotTable Reports In A Workbook
- Delay Code Execution And Get Elapsed Time
- How To Run Macros In Another Workbook
- Save Persistent Settings In A Workbook
- Aligning strings within a fixed width
- ADO Connection Strings
- Send to and retrieve from Windows Clipboard