Thanks to the help from this Forum and its members: I can now open a file and copy two sheets but need to close the second file...
In wkb "C*commissions database.xls" I have this code which directs the user to open the current month's commissions. And with it open I can copy two sheets (always named the same). but now I need to close the current month's workbook, so I can continue working with the data in my permenant workbook.
Code
Sub CopySheetsToHereFromCurrentdownloadxls()
'
' MoveSheetsToHereFromCurrentdownloadxls Macro
' Macro recorded 1/27/2007 by Charles
'
' open the download for this month
'
Application.Dialogs(xlDialogFindFile).Show
' lets try an Array to copy both sheets at one time
Sheets(Array("MANUAL ADJUSTMENTS", "TRANSACTIONS")).Copy Before:=Workbooks( _
"C* COMMISSION DATABASE.xls").Sheets(1)
' okay I've got the new sheets in my database workbook
' now I need to close the download for this month
' but the name of the file changes each month
End Sub
Display More
Thank you for taking the time to read this, hope you can give me a suggestion. Charles