ProteanBeing
02-12-2010, 01:13 PM
I am using Excel 2003
I have several workbooks (one for each department) that store the same type of data in a table format. For this example let's call one of these Data.xls. I am creating a workbook that the user will enter raw data and the program will update the applicable Data.xls file (Let's call this Interface.xls). Each Data.xls has a sort method defined in the BeforeClose event for the workbook. When I open and close the Data.xls manually the event works. When I close it remotely from the interface using workbooks("Data.xls").close SaveChanges:=True, it does not. Any insights would be welcomed.
Thanks.
I have several workbooks (one for each department) that store the same type of data in a table format. For this example let's call one of these Data.xls. I am creating a workbook that the user will enter raw data and the program will update the applicable Data.xls file (Let's call this Interface.xls). Each Data.xls has a sort method defined in the BeforeClose event for the workbook. When I open and close the Data.xls manually the event works. When I close it remotely from the interface using workbooks("Data.xls").close SaveChanges:=True, it does not. Any insights would be welcomed.
Thanks.