Microsoft Office Forums import of extended resource info into Project 2013 from Excel

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-12-2015, 10:53 AM
amaken amaken is offline import of extended resource info into Project 2013 from Excel Windows 7 64bit import of extended resource info into Project 2013 from Excel Office 2013
Novice
import of extended resource info into Project 2013 from Excel
 
Join Date: Nov 2015
Posts: 1
amaken is on a distinguished road
Default import of extended resource info into Project 2013 from Excel


We are building up resource calendars in a outside tool and wish to export in xls format for use in schedule leveling in Microsoft Project.

Can resource calendars be imported into MS Project 2013 from Excel? I'm able to import task and basic resource info (resource sheet data) into Project, but I haven't seen a way to import either full resource calendars, resource group calendars, or multiple available.from & available to combinations.

Thanks in advance.
Reply With Quote
  #2  
Old 11-29-2015, 10:12 AM
JulieS JulieS is offline import of extended resource info into Project 2013 from Excel Windows 7 64bit import of extended resource info into Project 2013 from Excel Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

To the best of my knowledge you're going to have to resort to VBA to extract the data. The resource calendars are not exportable objects through the UI. A quick search turned up:
http://www.waldherr.org/howto-import...in-ms-project/

I have not tested nor tried the code.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
import of extended resource info into Project 2013 from Excel [Project 2013] More accuracy with resource, unit %, and cost? cag8f Project 18 01-02-2016 01:51 PM
MS Excel - SQL Data Query Connection to MS Project - Resource Displayed in Multiple lines not in one AKent Excel 3 08-26-2015 01:34 PM
Project 2013 - resource capacity column and Project 3 02-11-2015 07:10 AM
Remove resource name from Gannt Bar in Project Professional 2013? nick@johansens.eu Project 1 10-16-2014 05:58 AM
MS Project able to import actual start and or actual finish date from Excel? mhacker Project 0 04-26-2010 11:29 AM


All times are GMT -7. The time now is 09:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft