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.
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
Thank you for taking the time to read this, hope you can give me a suggestion. Charles