Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can VBA (Excel) be used to create COM objects
Dear Fumei and skipvought, Many thanks for your valuable time in responding to my query. Regards, Sugena- shsu
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Can VBA (Excel) be used to create COM objects
Hello, Could you please tell me how to write a VB script using/with COM to open an excel sheet, modify the data and close the excel sheet. Is it possible to create COM objects/add-ins with VBA? I have used Excel VBA script to open an Excel sheet, modify/insert the data and close the Excel...- shsu
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
