Returning a distributed results sheet. 1

[Pyrrhus]

(This post is duplicated in the MS Office forum. I appologise if this confuses or annoys anyone. I am looking for the VBA user input also.)

I am distributing a bulky Excel application and I want the user to be able to return a single "results" sheet of his / her responses. Anyone know the easyiest way to do this? For example, should the results be a separate workbook to enable easy file access? Would it be possible to attach it to an embedded command button via macros or VBA? Help appreciated. Would it make more sense to return it to my web site (from where the initial app is downloaded) or by email attachment to me? Any thoughts welcome.

 

[RobBroekhuis]

Most straightforward way would be to return a single-sheet workbook. The sheet can be constructed in the original workbook, then moved to a separate (new) workbook using
activesheet.move
without any parameters. Then use activeworkbook.sendmail to send it right back to yourself.
Rob