Copy data from one workbook to another

[dan17602]

Hi All,

I was wondering which is the fastest VBA script that would open a workbook
(This is currently based on a cell value "Workbooks.Open Cells(1, 1).Value). Copy data from the "Data" tab and paste it into "Data" on my current sheet. I have run a simple macro for this but it seems to take a long time to copy over

Any advise would be great

Thanks, Dan

 

[CharlesH]

dan17602,

If you have formulas in the worksheet you may need to turn the "Calculations" off when copying over.

At the start of the code place

Sub Test
Application.ScreenUpdating = False 
Application.Calculation = xlCalculationManual
''''' your code''''
''at the end of your code
Application.ScreenUpdating = True 
Application.Calculation =  xlCalculationAutomatic
End Sub

 

[dan17602]

Hi Charles,

Thank you for your response on this. Someone had a look at this with me today and they advised exacly the same. When this was added to the VBA the script runs in 5-6 seconds.

Thank you for your help

Dan