vbproject

I have written this macro below. I get an error on the Workbooks(ThisWorkkBook).VBProject.VBComponents("Module1").Export strTempFile. How do I define this? Sub CopyModule() Dim wb1 As Workbook Dim ws1 As Worksheet Dim Path As String Dim FName As String Dim wb2 As Workbook...

Hey Guys, My problem: I have a userform launched on the workbook open event for the user to input the names and tech data for a range of fans. For example, they enter 5 fans. Once they enter the data into the form and click start, 5 sheets named,for example Fan1, Fan2.... to Fan5 are...

Hello! I have 2 files. File A will open FIle B at some point through code. I need file B to open and add the VBProject in file A as a reference. At the same time I need File B to remove that reference on the BeforeClose event. Both files are .xlsm and have their own VBproject I tried...

Thanks for reading this post. I am programmatically looping through N workbooks (open workbook, process, close workbook). When I close the workbook, I am left with a "footprint" of workbook in project explorer, even though the workbook itself is closed. This is causing problems as well as...