copy destination values only

[spq24]

Hello,

I have one sheet that has access connections in it so it obviously puts this data into a table. I am looking to copy the values from 6 different queries on 6 different sheets from this workbook to another workbook into 6 different sheets.

Is it possible to use the copy destination: between two workbooks and paste special values only?

 

[Sthrncali]

Yes. For the destination you can use:

Workbooks.Open("")
or
Workbooks.Add

 

[spq24]

what would be the code for copy destination: but only values

 

[Sthrncali]

I use this code quite frequently:

Sub CopyPasteValues()
Set wbsource = ThisWorkbook
Set wbDestination = Workbooks.Open("FilePath")
'Could Also Be Workbooks.Add()
 
wbDestination.Sheets("Sheet1").Range("A1:A1000").Value = wbsource.Sheets("Sheet1").Range("A1:A1000").Value
 
End Sub