Thread: VBA-How to insert vba code file in a project using coding rather than manual import
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default VBA-How to insert vba code file in a project using coding rather than manual import
You can add the files to a project with code like

ThisWorkbook.VBProject.VBComponents.Import _
Filename:="C:\temp\module1.bas"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Excel4Engineer "
wrote in message
...
I have several vba code files (*.vba, *.frm).
How can I add, not import, them to another project using VBA
coding,
just like insert API functions? Am I clear?

BTW, how to using vba code to add reference (like solver)?

Thanks.


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote