R
Rik
How can i get to 'analyse time phased data' (wizard), working to export data from Project 2000 to Excel 97
Is this possible
Regard
Rik
Is this possible
Regard
Rik
R
Rob Schneider
What error messages are you getting?
Hope this is useful to you. Let us know.
rms
Hope this is useful to you. Let us know.
rms
R
Rob Schneider
I have a vague recollection that I had the same problem a few years ago
with Project 2002 and Excel 97. I had done an upgrde from 98 to 2002 an
somehow or another the global.mpt file didn't get handled correctly.
The fix (suggested in this forum), as I recall was to remove the
global.mpt and reinstall Project so that it would put it's own
global.mpt file in place. this fixed the links to this Excel add-in. I
manually moved stuff from the old global.mpt into the new global.mpt.
Hope this is useful to you. Let us know.
rms
with Project 2002 and Excel 97. I had done an upgrde from 98 to 2002 an
somehow or another the global.mpt file didn't get handled correctly.
The fix (suggested in this forum), as I recall was to remove the
global.mpt and reinstall Project so that it would put it's own
global.mpt file in place. this fixed the links to this Excel add-in. I
manually moved stuff from the old global.mpt into the new global.mpt.
Hope this is useful to you. Let us know.
rms
J
John
Rik,
Do you in fact have Excel resident on your PC? If so, you can try a
little experiment to see if Excel will open when called from the
"analyze timescale . . ." add-in. Try running the following code
snippit. It is a slightly modified version of the code in the add-in. If
Excel is successfully opened after running the snippit, then the problem
has something to do with your Project file or the full add-in is corrupt
and should be reloaded.
Sub Test_Excel_Open()
Dim XL as Object
On Error Resume Next
'set up existing instance of Excel, or if Excel is not running, start it
Set XL = GetObject(, "Excel.application")
If Err <> 0 Then
On Error GoTo 0
Set XL = CreateObject("Excel.Application")
If Err <> 0 Then
MsgBox "Excel app not available on this PC", vbCritical
Set XL = Nothing
On Error GoTo 0
Exit Sub
End If
End If
XL.Visible = True
End Sub
Let us know what happens.
John
Do you in fact have Excel resident on your PC? If so, you can try a
little experiment to see if Excel will open when called from the
"analyze timescale . . ." add-in. Try running the following code
snippit. It is a slightly modified version of the code in the add-in. If
Excel is successfully opened after running the snippit, then the problem
has something to do with your Project file or the full add-in is corrupt
and should be reloaded.
Sub Test_Excel_Open()
Dim XL as Object
On Error Resume Next
'set up existing instance of Excel, or if Excel is not running, start it
Set XL = GetObject(, "Excel.application")
If Err <> 0 Then
On Error GoTo 0
Set XL = CreateObject("Excel.Application")
If Err <> 0 Then
MsgBox "Excel app not available on this PC", vbCritical
Set XL = Nothing
On Error GoTo 0
Exit Sub
End If
End If
XL.Visible = True
End Sub
Let us know what happens.
John
M
Mike Glen
Hi Rik,
Welcome to this Microsoft Project newsgroup
Please see FAQ Item: 46. Analysis Toolbar (Project 2000+)
FAQs, companion products and other useful Project information can be seen at
this web address: http://www.mvps.org/project/
Hope this helps - please let us know how you get on
Mike Glen
Project MVP
Welcome to this Microsoft Project newsgroup
Please see FAQ Item: 46. Analysis Toolbar (Project 2000+)
FAQs, companion products and other useful Project information can be seen at
this web address: http://www.mvps.org/project/
Hope this helps - please let us know how you get on
Mike Glen
Project MVP
J
John
Rik,
It sounds like it worked. The code I posted only opens Excel, it did not
create a Workbook so all you would see briefly is a blank Excel window
with a toolbar. Also, if the code executes fully, the instance of Excel
disappears. Add the following line immediately after XL.Visible = True
XL.Workbooks.Add
You should now see Excel open with a blank Workbook. If you do then
there is no reason to upgrade to Excel 2000 (unless you plan to do that
anyway), Exel 97 will work fine. Something is either wrong with the
Project file or you need to reload the "Analyze timescale ..." add-in.
Try that and let me know what happens.
John
It sounds like it worked. The code I posted only opens Excel, it did not
create a Workbook so all you would see briefly is a blank Excel window
with a toolbar. Also, if the code executes fully, the instance of Excel
disappears. Add the following line immediately after XL.Visible = True
XL.Workbooks.Add
You should now see Excel open with a blank Workbook. If you do then
there is no reason to upgrade to Excel 2000 (unless you plan to do that
anyway), Exel 97 will work fine. Something is either wrong with the
Project file or you need to reload the "Analyze timescale ..." add-in.
Try that and let me know what happens.
John