![excel font size must be between 1 and 409 excel font size must be between 1 and 409](https://venturebeat.com/wp-content/uploads/2018/11/MVIMG_20181119_113222.jpg)
Use that information to find the item in the value list and thereby extract the description, which is the email. With regard to getting the email address, the argument for the CustomFieldGetItem Method is already there. That will work okay but what I think you really intended is the following:ĭim OpeningParen as Integer, ClosingParen as Integer. For example, the Dim statementĭim OpeningParen, ClosingParen as integerĪctually declares OpeningParen as type Variant and ClosingParen as type Integer. dim statement), each variable must be individually declared.
#Excel font size must be between 1 and 409 code#
I would like to know whether this would be a feasible solutions and if some of you have implemented this kind of thing please share some code snippets.
#Excel font size must be between 1 and 409 update#
Update the MS Project file and inset a lag to match the excel file start date. Update MS Project File ( Actual Start, Actual Finish and Update % Complete 100%)Į) If Start date of the task has been rescheduled to a future date ( If Excel file start date is > that Ms project start date and excel file % complete is 0) Update MS Project file ( Actual Start date and % Complete)Ĭ) IF Task has started as Scheduled ( the excel file contain % complete and the excel file start date is equal to MS Project start date)ĭ) IF Task has started and finished as Scheduled ( The excel file start and finish dates are equal to MS Project file but excel file % complete is now 100%) Tasks in the past which have finished etc) grouped as per responsible person and create separate excel files for each responsible person.ī) the excel file will contain ( UID, Task name, start date, finish date, %complete, resource name, responsible person)Ĭ) I would like to email these excel files to each responsible person and get their updates for (start date, finish date, %complete)ĭ) Create a VBA macro to let the user to select the updated excel file and update the data back to MS Project file.Ī) Read the Excel file from Top to bottom and find the correct record based on the UID and update the "duration" in order to change dates as belowī) IF Task has started ( the excel file contains % complete and a new start date later than the MS Project start date) Their updates back in excel and update the dates and % complete back to the MS Project schedule.Ī) create a filter to list all the tasks which need to be updated based status date ( tasks which are in progress, tasks in the past which have not started yet, My thoughts are to make a solution to generate the tasks which needs to be updated based on the status date and generate a individual excel files for each responsible person and get I need to work out a good way to get schedule updates from different parties in a efficient way. I’m having a schedule which has around 3000 lines with resources names and a Responsible Person ( where individual resources
![excel font size must be between 1 and 409 excel font size must be between 1 and 409](https://www.mrexcel.com/board/proxy.php?image=http%3A%2F%2Fi568.photobucket.com%2Falbums%2Fss123%2Fjoselms%2FBorderError.jpg)
Hi - This is my first post on this forum which i see is a great way to share knowledge.