Greetings, I am trying to understand material resource usage for reusable material. My made up project is brew 3 batches of beer with 100 reusable beer bottles. Each batch needs 50 so when batch one is done the bottles start being emptied at the rate of 10 per week. Obviously batch two can...
before would or could be
0% Release X
0% Project A
0% Pre-Planning A
0% M3 (BRD work)
0% M3 BRD part one
0% M3 BRD part one step one
0% M3 BRD part one step
two...
Now state can be any view and any column width through the various inserted projects. Each project has it's own team driving. The To Be state is a full Program view of all projects and tasks in a hard copy view.
first step of macro is to set columns to the same alignment and width.
Second...
I would love to paste a picture from snipping tool.. attach a file does not work for me..
Going back to my second response.. I would like ID 5 the word task to be visible in the cell
We hold the view to specific column widths so the boss can see the text on one page wide and all words in...
Hmm that is new to me. I see if I open Visual Basic the Object Browser.. classes (task) Members of task (outlineCode 1-- 10)
How can I pull that information for a specific Task?
My skill level is record a macro figure out what it says I did and tweak to what I want.
Program Alpha (13 characters)
Project one (11 characters)
subproject
part one of subproject
task (4 characters)
task
task
Project two subproject
part two of subproject
task
task...
I have a macro to open all cells to appropriate height before printing to pdf for leader review (yes they are stuck in paper world).
My issue is on inserted projects that tab over.. e.g. different levels of outline.
Macro counts characters in cell and divides by width to set row height...
I have a massive current 3000 line program in ms project.. It will expand as we expect upwards of 1000 projects within.
We are required to weekly print out the full project (I don't know why, other than told to..)
So to have some fun I decided to create a macro to set the columns in specific...
Solved this myself, will respond so others can find if needed.
I created a library very high in the site nest and named it with a TLA
then on the "client" site I put a link to the "request form" and used the URL of the "new" button of the original TLA list.
In the URL I cut of at Source= and...
I have done this in the past and cannot remember where I change the url to redirect the submitor to a save landing page vs. the full list of items.
I will supply a link that opens directly to the create new "form" (not infopath), then when it is filled out I want to send the person back to the...
I have seen something similar, when I put an Excel document with .xlsx in sharepoint. My users did not have Microsoft Office 2007 so they could open and change but then saved as .xls
Solution is change your original to .xls or upgrade to Office 2007
I have MS excel 2007 and Adobe acrobat 9.
How do I convert the excel to PDF and keep the hyperlinks intact?
It worked once but not again.. I could recreate the links in the pdf but that is over 500 (250 one way and 250 back)
Any support appreciated
I work a group mailbox with 3 others. Currently we use signatures to reply to basic types of activities and fill in the specifics.. like date change, project number or specific names.
I would like to get either the signatures into a shared format so there is one place to update and ensure we...
I need to look for changes in data to show progression through projects. I have a report that I run in BO that basically gives me a current snapshot of all projects and their milestone dates..
I save a copy to excel on a weekly basis and then need to compare for progression / stagnation of...
We are attempting to sum several cells that are not contiguous. There appears to be a limit of 30 cells that can be added up. Is 30 cells the limit?
Has anyone seen this happen or are we just lucky?
The linking is dynamic by xl. If you click in a cell not a row the default in xl is to ask if you want all the data. All the data as I remember looks for any data that has data beside it. i.e. If you leave blank rows or colums the data will be truncated.
Another safe way is to highlight all...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.