My syntax is this: VBE.ActiveVBProject.VBComponents(1).Export filename Why am I getting this error?
J jaslegume Aug 3, 2007 #1 My syntax is this: VBE.ActiveVBProject.VBComponents(1).Export filename Why am I getting this error?
J Jonathan West Aug 3, 2007 #2 jaslegume said: My syntax is this: VBE.ActiveVBProject.VBComponents(1).Export filename Why am I getting this error? Click to expand... Various possibilities. 1. "filename" doesn't include a valid file name 2. Your security settings (Tools Macro, Security), do not trust access to the Visual Basic project 3. The VBA project in the template is locked for viewing.
jaslegume said: My syntax is this: VBE.ActiveVBProject.VBComponents(1).Export filename Why am I getting this error? Click to expand... Various possibilities. 1. "filename" doesn't include a valid file name 2. Your security settings (Tools Macro, Security), do not trust access to the Visual Basic project 3. The VBA project in the template is locked for viewing.
