VBA Syntax

[MadCallidus]

Trying to get this reference to work to a closed workbook on another drive. I just want to copy data plus cell formatformatting:

Sub CopyWithFormatting()
Workbooks("\\harddrive\driveletter\folder\[XLworkbook.xlsm]").Worksheets("sheetname").Range("c6:ak27").Copy
With ActiveSheet.Range("c6")
.PasteSpecial xlPasteFormats
.PasteSpecial xlPasteValues
End With
End Sub

Can you please help with the syntax of the reference.

Thanks,


Andy

 

[RoryA]

Re: VBA Syntax help please

You can't copy from a closed workbook - you have to open it. (you can extract values from a closed workbook but that is all)

 

[MadCallidus]

Re: VBA Syntax help please

OK, understood.

I think I'm gonna have to find another way around this, then.

Thanks for your response.