Get Excel To Open MS Project File And Then Run Project Macro On It

Jul 30, 2013

I am trying to get excel to open a MS Project file and then run a project macro on it.

What is happen is that when I run my code it works, and then excels VBA window freezes up and the run arrow goes away, and if I try to open project I just get a chiming noise and it won't open.

For now I have to select the MS Project file from a directory, but in the future I would like it to go through the folder and open all of the file in the folder

EXCEL CODE
Sub ImportMSProject()
Dim FileToOpen
Dim mpApp As MSProject.Application
Dim prjmacro As Object
'Identify the File to Open - START
FileToOpen = Application.GetOpenFilename("Microsoft Project Files (*.mpp), *.mpp")
If FileToOpen = False Then
Exit Sub
End If
'Identify the File to Open - END

[code].....

View 9 Replies


ADVERTISEMENT

Consolidate 4 Excel Project Lists (Workbooks) To New Master Project List Using VBA

Sep 5, 2013

My task is to consolidate 4 Excel Project Lists (Workbooks) to a Master Workbook. The Project Lists has a different structure and almost different content. The relevant information is always on Sheet1 but it has completely different ranges. The only constant is the Project Number, which should be used to sort the information. Every Project should be listed only once with all the existing information.

I found a code written by Ron de Bruin which has already some components that I want to have in my VBA but I think there are still a lot of necessary adjustments to do.

Code:
Sub MergeSelectedWorkbooks()
Dim SummarySheet As Worksheet
Dim FolderPath As String
Dim SelectedFiles() As Variant
Dim NRow As Long
Dim FileName As String
Dim NFile As Long
Dim WorkBk As Workbook

[code]....

The Master Project List should has the headers in Row1 and the information listed below. The Macro should automatically places the correct information to the correct column. Some of the information are in 2 or more of the lists but they should be listed only once in the Master List.

Project Number

Project Description
...
1111E.000000001

[code]....

I guess a problem is that the structures of the Lists are quite different so there must be a kind of sorting process.

In the end I want to have an Excel File with the Macro and a Command Button and by clicking the Macro creates a new Workbook with the Master List.

It would be better if there is a variable range instead of a defined. Like the Macro searches the last row and starts at this row and column.

View 4 Replies View Related

Macro: Open Workbook From Microsoft Project

Dec 14, 2006

I have discovered that I can write a macro in Microsoft project that opens Excel

ActivateMicrosoftApp(pjMicrosoftExcel)

but this call does not allow me to specify a file to open, it just opens an instance of Excel (or activates the open instance). What I ultimately want to do it to, from a Project macro, open a particular workbook and then execute a macro in that workbook.

View 6 Replies View Related

Generating List Of Project Parts Based On Project Duration And Time Window

Aug 4, 2014

I have a table of projects with 1) duration in year, 2) time window (number of years of our planning cycle), and 3) start year of the project. I want to generate a list of project parts of all projects where they may take place. This will serve as an input to an optimization program.

So a project of 2-year duration should have 2 parts over any year within the time window. I am including the "impossible" ones for my developer to tag them as "0" when we run it through his code.

View 5 Replies View Related

Protect VBA Project Or Lock Project For Viewing By VBA

Apr 27, 2007

I have tried to record macro to protect VBAProject / lock project for viewing. But can not success by that way.

View 9 Replies View Related

Tally Report Of X: Count On Column B (project $) Depending On The Criteria On Column A (project Description)

Aug 28, 2007

I need to write a couple of functions. Firstly I want to do a count on column B (project $) depending on the criteria on column A (project description). For example a total count of all values in col B if project description is "P" or "A". [I can do sumif functions but this is a countif and I cannot get this right].

View 4 Replies View Related

Excel Macro From 2003 To 2010 - Can't Find Project Or Library

Feb 8, 2013

I have got an issue. in MSE 2003, this beginning of macro worked:

Sub Consolide()
MYFOLDER = "D:DATAMypath"

In MSE 2010, it gives me an error: "Can't find project or library"

I really know that my path is defined fine, because it worked perfect before MS update.

View 1 Replies View Related

Reset Project On Open

Mar 24, 2009

I'm a noob to programming in XL, and am teaching myself through a project for manipulating vectors. One thing that has me stumped is that when I open the file in which I'm working, I get a "This action will reset your project..." message.

View 7 Replies View Related

Excel 2010 :: Macro To Upload SharePoint Project List Then Copy To Existing Workbook?

Jul 11, 2014

I need to be able to export a project list to Excel and overwrite the contents in an existing Summary Report with the exported list. Is this possible? I am using SharePoint 2013 and Excel 2010.

View 4 Replies View Related

Save A File When Vba Project Is Protected

Feb 8, 2007

I have an Excel File and I have created some code. I locked the VBA Project where that code is contained..... However when I work with the excel executing the mentioned code and after that I try to save it with the information resulting, Excel shows me the following message: "YOU CAN NOT SAVE TO THIS FILE FORMAT WHEN THE VBA PROJECT IS PROTECTED. YOU MAY UNPROTECT THE VBA PROJECT BY CHOOSING THE PROPERTIES COMMAND ON THE VISUAL BASIC EDITORS TOOLS MENU, AND ENTERING THE PASSOWORD FOR THE ACTIVE PROJECT....."...

View 4 Replies View Related

Excel Export To MS Project?

Oct 21, 2011

If i have a table full on excel data, date, names etc, and I have a userform where someone has filled all that in. On that particular userform I was wondering if their's a way I can get it to write each column over to a sample MS project document.

To save me having to manually change it over?

so on clicking a button, what ever's in sheet1 say it writes out out to specific ms project strips, e.g. start date(excel) written out to data(project)

View 8 Replies View Related

Excel 2010 :: Project Status Report

Nov 24, 2013

Uses excel 2010 to track the project in the form of project status report. Basically it has to look simple yet tracking should be in the form of progress bar etc.. Our aim is to track a 3month project.

View 1 Replies View Related

Copy Excel Data To MS Project Fields

Apr 28, 2014

Writing a macro in excel where you can use the data in your excel file to copy data to microsoft project.

I have an excel file of task name, deadline, time remaining, and assigned to and I want to copy those 4 columns to a correlating column in project. So basically I would loop through these fields on each line til I reach a blank which could be entering a varied amount of tasks.

The full macro would change ms project start date to today's date then copy the 4 columns from excel to project to add a new task for each line in my file and then save the project file.

I've seen some links on macro with project but most are more advanced then this or are exporting data from project to excel.

View 1 Replies View Related

Excel 2003 :: VBA Project Absent And Coverage

Aug 30, 2012

I'm a basic user of excel 2003. I recorded a macro that copy a teacher absent schedule to a daily cover schedule as follow:

Sub ABS_M1()
'
' ABS_M1 Macro
' Absent teacher monday 8/29/2012 by Oscar
' Daily cover schedule
'
Range("A65:J67").Select
Selection.Copy
Sheets("Covers").Select
Range("B5").Select
ActiveSheet.Paste

End Sub

Using the same VBA: What function should I use to make the Sub ABS_M1 move down 4 rows to a new range on the cover sheet if the first Range ("B5") is already used and so on?

View 4 Replies View Related

Excel 2007 :: Cannot Find Project Or Library

Aug 15, 2013

Why does this code no longer work? It gives me the error code Cannot find project or library and MyMsg = is highlighted in blue. This worked in 2003, but does not seem to like 2007 version of excel.

Sub Send2()
'This is the "Send to XX" button

MyMsg = "Did you remember to name and save this file to your computer?"
Response = MsgBox(MyMsg, vbYesNo, Attention)
Select Case Response
Case Is = vbNo

[Code] .....

View 9 Replies View Related

Software / Excel Add-in To Provide VBA Project Documentation?

Jun 8, 2014

Is there any Software / Excel Add-in to provide VBA Project Documentation? I'm looking for something that can tell me which code does what? Which codes and functions are related. What are the references (with Other MS Office products / foreign-objects if any). How many codes and code names

View 8 Replies View Related

Converting Excel Formula To MS Project Custom Field?

Mar 20, 2014

A coworker is setting up an MS Project...project, and adding a custom field that would convert the Start date field into our Fiscal Quarter Fiscal Week schema, to display as FQFW, e.g. Q1W1. I've written the formula in excel, but I've never even touched Project until this week. Apparently it doesn't take formulas quite the same way as Excel does. I tried using the ''Switch" function in Project, and it worked, but it only accepts 14 arguments, and there are obviously 52 weeks we're dealing with. Would there be a way to do this using VBA? (I know next to nothing here as well.)

Formula where A1 is the Start Date:

Code:
=IF(AND(A1>=DATE(2014,2,1),A1=DATE(2014,5,3),A1=DATE(2014,8,2),A1=DATE(2014,11,1),A1

View 2 Replies View Related

Error Message Say Macro In This Project Are Diasable.

Jan 13, 2009

when i tries to run the macro, it display the following error message. I have attached the screenshot of the error message. The details of the system:

OS - windows vista Business, SP1
office - Office 2007
excel Version - Excel 2007.

View 2 Replies View Related

Excel 2003 :: Can't Find Project Or Library Error With VBA Script

May 25, 2014

It works fine with several versions of Excel (2003, 2010, and 2013). But the problem arises when I move from Windows XP to Windows 7 or 8.

I use a scanner to scan barcode serial numbers into a textbox, and then populate these serial numbers with other associated data into a spreadsheet. The serial numbers are supposed to be separated by each line and placed into an array.

I get a compile error "Cant find project or library" with CHR highlighted in blue from this line of code...

SNs = Split(Str, Chr(10))

Once again, it works fine on many machines with XP, but not on Win 7 or 8.

[Code] .....

View 4 Replies View Related

Excel 2010 :: Compile Error - Can't Find Project Or Library

Mar 4, 2014

One of our employees has wrote a VB project in excel 2010 which works on some machines and not others, it comes up with the below error message.

I have checked VB and there are no missing references.

Compile Error: Can't find project or library

Private Sub UserForm_Initialize()
'Empty ClientCodeComboBox
Me.ClientCodeComboBox.Clear

[Code] .....

View 14 Replies View Related

Excel 2013 :: VBA Error When Upgraded - Cannot Find Project Or Library

Jun 29, 2014

I have the below code which was working at work using Excel 2010. We have upgraded to Office 2013 and it no longer works

Error: Compile Error. Cant find Project or Library

It does highlight this : If Right(varFile, 4) = ".xls" Then

Code:
Sub PropertyName_SAVEAS()
Sheets("Menu").Select
Range("I27").Select
Dim varFile As Variant
Dim strFileNameDefault As String

On Error Resume Next

[Code] .......

View 2 Replies View Related

Excel Function Required To Allocate Project Cost Between Two Date Range

Dec 9, 2013

Attached is a spreadsheet wherein I'm trying to extrapolate project costs across various months based on working days in a month subject to start and end dates of the project. Need an accurate formula to spread the cost.

Days & Cost Allocation Example.xlsx‎

View 2 Replies View Related

Excel 2010 :: Hide Worksheet Password In VBA Code Without Project Protection

Nov 5, 2012

I have a 2010 excel workbook with several locked worksheet (to which I manage the PW). I and another staff member manage different section of the macro but the other staff member doesn't have access to the locked areas.

Is there a way I can encrypt the password within VBA so it's not visible to the other staff member?

Locking the VBAProject doesn't work as the other staff member has to be able to edit his VBA section.

Many staff run the macro (via a button) and don't need to access the Macro and don't have access to the protected sheets.

I understand excel isn't ideal with PW protection for people wanting to bypass the protection and this isn't an issue.

View 3 Replies View Related

Excel 2010 :: Checking If (Trust Access To Visual Basic Project) Ticked

Sep 17, 2012

I have a macro that seems to work okay for older versions of Excel - I use Office XP (2002) tell me if this will work for newer versions (2007 / 2010)?

KB1017 - Trust access to VBA project

Code:
Function VBATrusted() As Boolean
On Error Resume Next
VBATrusted = (Application.VBE.VBProjects.Count) > 0
Exit Function
End Function
Private Sub Workbook_Open()
If Not VBATrustedAccess() Then

[code]....

I was thinking that i should probably have

VBATrusted = -1

as the third line so that it is negative unless the tick is there. No way of checking older versions right now though.

View 3 Replies View Related

Library File Name: "Complier Error: Cann't Find Project Or Library

Mar 22, 2007

I am using Mid function in my program. During execution, i am getting the waring message of "Complier Error: Cann't find project or library".I am not able to find the what is the reason behind on it. If really the library file missing.

View 3 Replies View Related

Vba For Project

Jun 30, 2007

I am looking for a forum or where I can find advice on using VBA with MS Project.

View 2 Replies View Related

VB Project Protection

Feb 12, 2009

I'm trying to protect my project so that others can't unhide a sheet I have tagged as veryhidden within VB.

I followed these steps:
1. Select project in the projects window
2. choose Tools
3. Project Properties
4. Protection tab
5. checked lock porject for viewing
6. entered passwords twice
7. clicked ok and saved

On another file this has worked perfectly as I wanted it to.

However on another very large file with multiple VB projects it is not "taking" on the project I need it to.

I can open the file, the VB project and change the setting on any sheet I need to without entering a password.

View 14 Replies View Related

Add Project To 'database'

Mar 9, 2009

Add Project to 'database' I recorded my marco.

View 3 Replies View Related

Project Not Closing In VBE

May 7, 2008

I have a macro in a workbook (WB1) that opens another workbook (WB2). After performing several other macros through user invocation with buttons, I close WB2 with the following statement:

Windows("WB2.xls").Activate
ActiveWorkbook.Close (False)

While the WB2 workbook closes okay, the WB2 project is still open in the VB editor. Does anybody know why this code isn't closing the project in the VBE?

The WB1 process can occur multiple times while Excel is open and each time a separate occurrence of the WB2 project is left open in VBE.

View 9 Replies View Related

Start And Name A New Project Using VBA

Nov 28, 2007

how to start and name a new project in Excel VBA. Will someone explain how to?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved