I am using Excel to compile an MS PowerPoint presentation using VBA to gather information from various Excel files on the companys SharePoint store. That side is going well and the resulting PowerPoint is good. Now I hit the problem: I need to capture an MS Project timeline from a .mpp file...
Hello everyone,
I have ran into an automation issue that I cannot seem to figure out.
Currently, I have a worksheet,("Project") that contains data in columns "A"(Project Name) & "B"(Project File Location).
Column "B" contains the string location of each MS Project file.
My VBA macro loops...
Good morning all, i have scoured through MR Excel, and many others but have not had any luck. This maybe due to not using the right keywords in google. Alas, i have had to create this post for help.
The best way to describe this issue is something that is done automatically within MS Project...
The following VBA segment reports run time error when MS Project is not Open. It works as it should when MS Project IS open. Any education on what is causing it and how could it be amended to NOT to require opening MSP, shall be greatly appreciated.
fPath = Cells(4, "L")
If fPath = ""...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.