ExcelBanter - Open Excel file from VB and open MACRO

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Open Excel file from VB and open MACRO (https://www.excelbanter.com/excel-discussion-misc-queries/269555-open-excel-file-vbulletin-open-macro.html)

no1jimmyman

Open Excel file from VB and open MACRO

Hello there,

Is there a way to open an external excel file from a Visual Basic program and scan the file for the macros it contains?

The user will select a excel file and then it will list the macros available in that file?

Thanks,

All times are GMT +1. The time now is 06:42 PM.