PDA

View Full Version : Exporting info from a VBA custom Dialog Box



The"Truth"
11-18-2008, 09:22 AM
Is there a way to export info gathered from several Custom Dialog(Aka User Form) boxes in VBA to a different excel file? Example I want info gathered from Press 1 Downtime.xls, Press 2 Downtime.xls, and Press 3 Downtime.xls<---These have the custom dialog boxes, and i want the info to be exported to Report card.xls. Is this possible?

lucas
11-18-2008, 09:51 AM
Almost anything is possible but I don't know what you mean by "custom dialog box"

Also It might be easier to run from the report card.xls and retrieve the info from the other files if we can figure out where it is in each file.