Hi all My client has modified their excel spreadsheets so the headers are now in row 5 instead of row 1. How can I modify the following function to reflect the changes? Public Function ImportHierarchyFunctionFiles() Dim MyFile As String Dim MyPath As String Dim db As Database Set db =...
www.access-programmers.co.uk
Edit: just realised this is copy/paste from one excel file to another, so my suggestion may not be relevant