There is a VB program that generates data and dumps it to an Excel spreadsheet. I have some macros that I would like to run after the data is generated. However, VB does not open Excel normally so the macros in my personal.xls workbook are not available.
Is there a way to get around this programmatically without having to open the personal.xls workbook?
The VB program is not my program, so I was trying to do this from the Excel side. If anyone knows of a way to do this in VB, I could relate that to the programmer.
Thanks,
Is there a way to get around this programmatically without having to open the personal.xls workbook?
The VB program is not my program, so I was trying to do this from the Excel side. If anyone knows of a way to do this in VB, I could relate that to the programmer.
Thanks,