Opening the VBA Project in this file requires a component that is not currently. The versions listed above are not compatible with Excel 2007. Mar 17, 2011 I get 2 msgs when I try and open a file in Excel 2007. Firstly, 'FinCal 2.31 - 2006' and then 'Opening the VBA project in this file requires a component' etc. How can I fix these problems? This file will be opened without the VBA project. For more information, search Microsoft Office Online for 'VBA converters'." Then this message appears, "Excel was able to open the file by repairing or removing the unreadable content. This workbook has lost its VBA project, ActiveX controls and any other.
SheetName1 = 'Raw Data'start MS ProjectSet appProj = CreateObject('Msproject.Application')Prompt2 = 'What is the name of the project plan you are using?' FileName = Application.InputBox(Prompt:=Prompt2, Type:=2)'verify the filename has the extension.mppIf Right$(FileName, 4) '.mpp' ThenFileName = FileName & '.mpp'End IfPrompt2 = 'What is the full PATH of your project plan?' Location = Application.InputBox(Prompt:=Prompt2, Type:=2)'verify the location includes the final slash prior to the filenameIf Right$(Location, 1) ' ThenLocation = Location & 'End IfLocation = Location & FileName' This is a MS Project File. Change path as applicable.appProj.FileOpen Location 'C:UsersSoniaDocumentsOne Mazda Chicago20160810Macro Copy.mpp'Set aProg = appProj.ActiveProject.
The VBA Editor, VBA projectand how they are used.The VBA Editor is where you view, type, edit, debug and run your VBAcode. VBA code is typed in what are called modules. You can also use theEditor to build userforms which are basicallyfloating screens that display ActiveX controls. The VBA Editor has manywindows that can be displayed dependingon your coding tasks. You activate the VBA Editor in Excel by pressing the Alt+F11 keys on your keyboard.When observingVBA code in the Editor, you will see the code is organized in what arecalled projects.A VBA project in Excel is defined as a collection of VBA modules,userforms andvarious other programming elements, there is only one VBA project perworkbook file. VBA projects are automatically created in Excel when aworkbook file is created so you do not have to create one.
How Can I Open An Excel 2007 File With Excel 2016
To save a VBA project andits modules, you save the workbook file that contains them.Projects are viewed in theProject Explorer window in the VBA Editor. The Project Explorerwindow is presented in the picture below and is labeled Project -VBAProject. It'sdefault position is in theupper left-hand side of the Editor window and looks like a file tree. If you have multiplefiles open at once, then you will see multiple projects in the Explorer window.To display any project item, just double click on its icon in theProject window. When first starting, it isbetter to have just one workbook file open so you do not get your projects confused.