Replies

One very easy, yet overlooked feature is the ability to copy a value from Excel and paste-Link it into the desired field in Project. Perhaps this could get you started…

Rich P.

You may want to take a look at this site:

http://www.mvps.org/access/strings/str0008.htm

It has lots of useful code ready to go. Might be just the type of thing Charlotte is talking about.

Hope this helps.

Rich P.

Sounds like a pretty straight-forward Mail Merge operation from within Word.

You just need to separate the Merge Fields in Word with a carriage return. That will give you one field per line, and one document per record.

Good Luck.

Rich P.

Have you tried something crazy like this:

How about creating a mapped drive with the same letter as your network drive at the office. Under that drive, recreate the path your links point to. Then copy the files to their respective locations. Whether you are working on them at home or the office, it should not matter. At least this sounds good in theory. Worth a try.

Good luck.

Rich P.

Excel does not allow 3d references in arrays. So as a workaround, I did the follwing:
I wrote a module to create named formulas for each of the sheets in the workbook that takes the C2/C5 for each sheet.

I also created a named formula that sums the 3d range of the Population cells from each sheet in the workbook.

Then it doesn’t seem so bad to use these formulas on the summary sheet.

It appears that the bulk of the work would be to produce each of the individual formulas for the sheets. So the following tid bit of code may save you some time.

Hope it helps.

Regards,

Rich P.

Sub MakeFormulaNames()
‘

Dim shtName As String

For Each sht In ActiveWorkbook.Sheets

shtName = sht.Name

ActiveWorkbook.Names.Add Name:=shtName & “_Prod”, RefersToR1C1:= _
“=” & shtName & “!R2C3*” & shtName & “!R5C3”
Next sht
End Sub

I see –

Try this mini macro and attach it to a new button on your toolbar. When you hit the new button, it will bring you to today’s date based on your sysem’s settings. Make sure you copy this into the Global.mpt file so it is available on all sunsequent files you create. You will have to add it to the existing files manually.

Regards,
Rich P.

Sub GoToToday()
‘ Scrolls the current View to the current date.
EditGoTo Date:=Date
End Sub

This is from the on-line help within Project:

1 On the View menu, click Gantt Chart.
2 In the Task Name field, select the tasks you want to reschedule.
If you want to reschedule all remaining work in the project, do not select any tasks.

3 On the Tools menu, point to Tracking, and then click Update Project.
4 Click Reschedule uncompleted work to start, and then type the date from which you want to reschedule all remaining work.
5 To reschedule the entire project, click Entire project.
To reschedule only the selected tasks, click Selected tasks.

1 On the View menu, click Gantt Chart.
2 In the chart portion of the view, position the pointer over the incomplete part of the task.
3 Drag the task bar to the right to split the task and to start the incomplete part on the date you want.
Do not drag the finished part of the task. If you drag it, you’ll move the entire task.

4 If necessary, reapply any constraint.

Prety straight forward, either way you do it.

Good Luck.

Rich P.

If you go to Project>Project Information, there is a field for the Projet Start Date. Filling this in will set the overall timeframe for the project plan.

This normally defaults to your system’s date when starting a new project. But you can force it to any date you wish.

Hope that helps.

Rich P

The last post from ‘greisc’ was right on the mark. Using the select method option is right on the money.

I have found that using that method, along with defining a DSN to the Access Database allows me to have Word merge documents permanently linked to queries in the database.

Rich P.

Ron – No one seemed ask what, if anything you are using to manage your projects. If you are using MS Project, as more and more people are, you may want to take advantage of the built-in workgroup features, or Project Central.

Definately worth looking at to save you from reinventing the wheel.

Just a thought.

Rich P.