I have 2 files (file1.xls and file2.xls). File1 has a Command Button that triggers a VB Macro in it. Clicking this button processes a certain set of data in this file and populates a set of fields. File2 reads the output in file1 after the click of the button. However, instead of manually clicking on the button and getting the results, I would like to simulate the clicking on the Command Button in file1 from file2. Can anybody help, please?
I tried to invoke by calling the worksheet.calculate function of file1 from file2. But seems like it is stepping over this line without doing anything.
I tried to invoke by calling the worksheet.calculate function of file1 from file2. But seems like it is stepping over this line without doing anything.