My code imports a module (.bas file) into an excel file (code is below) but I would like it to automatically run that same module after it is imported. I try to reference the macro name (TestMacro) in teh visual basic express 2010 project that i created but of course it can not refer to it. so is tehre a way to programmably run a macro/module liek this?
thanks in advance,
ExcelApp.ActiveWorkbook.VBProject.VBComponents.Import(directory2 & "\" & fileName2)