Billy Pang
tuxedoman888 at gmail.com
Tue Sep 12 13:18:48 CDT 2006
Hello: >From Access, I'm trying to make a copy of a worksheet within an instance of Excel that is created at runtime in VBA. xlsheet.copy after:=activesheet However, I get the following error message. Run-time error '5' Invalid procedure call or argument Any ideas? Many thanks in advance, Billy -- Billy Pang http://dbnotes.blogspot.com/ "Once the game is over, the King and the pawn go back in the same box." - Italian proverb