morinia
asked on
Copying Excel spreadsheet without query
In VB code, how can copy Sheet 1 to Sheet 2 without the query? I would like to keep all vaues and formatting. I just don't want the query?
or Excel vba
Sub test()
Worksheets("sheet2").Cells .Copy
Worksheets("sheet1").Range ("a1").Pas teSpecial
End Sub
Sub test()
Worksheets("sheet2").Cells
Worksheets("sheet1").Range
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
workbook.LoadFromFile("tes
Dim worksheet As Worksheet = workbook.Worksheets(0)
Dim newsheet As Worksheet = CType(worksheet.Clone(work
workbook.Worksheets.Add(ne