I think you mean
![]()
Dim oWBS As Workbook Dim oNewWb As Workbook '<-not really necessary use Thisworkbook to refer to workbook with code Set oWBS = ThisWorkbook Set oNewWb = Workbooks.Add ActiveWorkbook.SaveAs "NewWorkBook.xls"
I think you mean
![]()
Dim oWBS As Workbook Dim oNewWb As Workbook '<-not really necessary use Thisworkbook to refer to workbook with code Set oWBS = ThisWorkbook Set oNewWb = Workbooks.Add ActiveWorkbook.SaveAs "NewWorkBook.xls"
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks