Opening Project Plans with VBA from Server???

[Shawn]

I've used the following VBA code to work with Project
Standard 2003... my company is now using Project Server
2003. I use the following code to open project plans by
referencing a cell in an excel workbook (for example...
cell 1,1 = "C:\Test\1.mpp"). How do I, through VBA, open
a project from Project Server?

I've run a macro.. and I get "
<>\"FileName".Published....

But when I use this format.. I'm told that "The project I
want to open is saved to project server and I need to be
online to open the project." I've set up my Project Pro
to automatically detect connection state by default to
project server...

Sub Concrete()
Dim y
Set y = Workbooks(1).Sheets("1").Cells(1, 1)

Dim x
Set x = CreateObject("MSProject.Application")
x.Visible = True
x.FileOpen (y)

End Sub

What am I doing wrong?

TIA!