Copy

[Peter Quill]

open the file and copy using used range (but without the header)

 

[cheekybuddha]

Is this specifically all in Excel?

You have posted in a board 'Microsoft Access Discussion > Modules & VBA' and don't mention Excel in your post!

Perhaps the mods can move this to the Excel board if Access isn't involved.

Wouldn't you need to re-calculate LR2 before each paste?

 

[CJ_London]

Rather than copy/paste, use transferspreadsheet or a sql query as suggested here

Importing from excel column headers in row 5

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