Import BAS file

[YasserKhalil]

Hello everyone
I need a way to import a module with BAS extension to closed workbook
I have Main.xlsm in which I need to put the code
The code would open closed workbook in the same path named "Sample.xlsx" and then import the module BAS file to "Sample.xlsx" not to the Main.xlsm
Thanks advanced for help

 

[Derek Brown]

You could have a look at Post #5 in the link below to see if you can adapt that for your use.
You will need to save the file as "Sample.xlsm".
http://www.mrexcel.com/forum/excel-...ns-using-visual-basic-applications-macro.html

 

[YasserKhalil]

Thanks a lot for reply
I tried the code and got error at this line

With Application.FileSearch

 

[Macropod]

Application.FileSearch has been deprecated for about 10 years now - ever since Office 2007 was released. Andreas Killer has made a replacement class module you can download from:
http://dl.dropbox.com/u/35239054/FileSearch.cls
For a discussion of how to use the class module, see: http://answers.microsoft.com/en-us/...lesearch/9021a162-7ec5-4c16-bff8-84f28300dba4