Is there a way to place data to a closed workbook from a VBA form? I have a form in one workbook where users will be entering data and hitting a command to save. Upon hitting the command button, I'd like the data to be placed into a sheet in a closed workbook. Is this possible? Can you provide an example if it is?
Thanks in advance,