Project Not Launching
Hi All, Not sure if anyone else has come across this yet seems to be a new "Feature" few users have raised a issue where they can't open project files by clicking on the file and opening it, you get the project splash screen and it just stays like that indefinitely The users are open the files from a OneDrive sync and its not a isolated issue 3 people have reported the exact same issue, the workaround I have found at the moment is launching Project by its self and opening the documents from within Project The Project version effected is: 16.0.17126.20132 Hoping this is just a broken MS update that can be patched out sooner rather than later.
Accessing SharePoint Text file via VBA
I originally posted this query in the SharePoint community a while ago but didn't get a response so I'm posting here. I have a VBA macro in MS Project that needs to read a text file located on SharePoint. I have tried two different methods of opening the file (code below [https replaced with xxxxs as it wouldn't let me post]), both of which work fine on a local copy but fail when using SharePoint. The SharePoint I'm using is not an in-house system but is using Microsoft's SharePoint service offering. I have tried names using %20 instead of spaces and just using spaces with the same result. In my searches I have found multiple old references (10 years plus) about mapping drives or using UNC names. But mapping drives or using UNC are not possible with the SharePoint we use (I have tried). I have also found this - https://learn.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/ms470176(v=office.14) that originally gave me some hope, but that is for VB and not VBA. I did consider OneDrive but the location of the file differs depending on whether the user has set up OneDrive sync or OneDrive shortcut from SharePoint. Plus, I need an option that will work regardless of a OneDrive connection being set up or not. Thanks in advance for any assistance. ======================================================= 'Const strLookup As String = "xxxxs://xxx.xxx.com/sites/xxxx/Shared%20Documents/xxxxx/xxxxx/My%20Text%20File.txt" ' Const strLookup As String = "\\xxx.xxx.com/sites\xxxx\Shared Documents\xxxx\xxxx\My Text File.txt" ' Const strLookup As String = "C:\Temp\My Text File.txt " intOutFileNum = FreeFile Open strLookup For Input As #intOutFileNum Line Input #intOutFileNum, strDataLine ' read in first line MsgBox (strDataLine) Close #intOutFileNum Const ForReading = 1, ForWriting = 2, ForAppending = 8 Const TristateUseDefault = -2, TristateTrue = -1, TristateFalse = 0 Set objFileSystem = CreateObject("Scripting.FileSystemObject") Set objFileSystem = CreateObject("Scripting.FileSystemObject") Set objTextStream = objFileSystem.OpenTextFile(strLookup, ForReading, False, TristateFalse) strDataLine = objTextStream.ReadLine MsgBox (strDataLine) objTextStream.Close
PWA missing from our SharePoint Online tenant
We have 26 "Project for Office 365" licenses which I believe are now called Project Online Professional. We are supposed to have a PWA option within SharePoint online to setup and direct our Projects to be stored in the cloud plus setting up shared enterprise fields like resources etc. I am the SharePoint Admin yet I don't see this PWA anywhere on our tenants. If I click on New > I only have Private Site Collection and nothing about PWA. I also cannot configure an existing site collection to use it as it's just not there. We own this software and subscribe to it, so how do we simply setup a "SharePoint Server" online to host all of our project data?
Problems with Microsoft Project office 365 Visual reports MSOLAP$cubes
Problems with Microsoft Project office 365 Visual reports MSOLAP$cubes Hi We have some problems with our Microsoft Project while trying to generate a Visual report: When we check the event viewer, we find following informationals: We tried the following: Reinstall and update the office 365 applications (we are running Version 2102 Build 13801.20960) Installed https://docs.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions drivers. Tried to repair office installation Tried to update Visual C++ redistributables + tried to repair Informational: We are running a Horizon VDI setup W10 enterprise Build 19042.1237
Actual number of days working on the task VS period of time to complete the task
Hi All, You may find my question stupid, but after a long hassle, I decided to ask for help. Given: Say I input a new summary task for the project and say this summary task has 5 tasks. The time period for each task is 1 week (5 days) and the time gap between tasks is 3 weeks (15 days). I set the project time to be calculated in days. After all that, my summary task shows that the total amount of working time is 100 days (working + gap), instead of 25 days of actual work. Pop-quiz: how can I set the summary task to show the actual amount of working time instead of the total time including gaps? Sorry if it all sounds confusing, I tried to be as specific as I could. Thanks to everyone in advance! P.S. I use MP 365
