This one is really frustrating. The following code open a text file copies the contents and pastes it into a cell on another spreadsheet.
I have two problems When I close the "ActiveWorkbook.Close" I get a message that is is a large amount of data on the clip board and I select YES, but I do not what that message. The other bigger issue is when I get to the second the the last line ".PasteSpecial Paste:=xlPasteValues" I get an error. "Run-time error '424': Object required. The workbook "quickImport" is a work book I import earlier in the code.Please Login or Register to view this content.
Any ideas??
Bookmarks