Method 'FileOpen' of object '_MSProject' faile

[ellebelle]

I get this error message when I try to run a macro to merge fields from an
ecell sheet into projet

2147417848
Method 'FileOpen' of object '_MSProject' faile

here is the code

Sub Import2()

FileOpen Name:="\\Whale\user_data\Project Admin\Schedules\MSProject\Company
Schedule\SP Schedule Working\import.xls", ReadOnly:=False, Merge:=1,
FormatID:="MSProject.XLS8", map:="Import_Text7"
FileOpen Name:="\\Whale\user_data\Project
Admin\Schedules\MSProject\Company Schedule\SP Schedule Working\import.xls",
ReadOnly:=False, Merge:=1, FormatID:="MSProject.XLS8", map:="Import_Text4"
FileOpen Name:="\\Whale\user_data\Project
Admin\Schedules\MSProject\Company Schedule\SP Schedule Working\import.xls",
ReadOnly:=False, Merge:=1, FormatID:="MSProject.XLS8", map:="Import_Start"

End Sub

It always errors on the final line of code ie. the thrid time I do a
'FileOpen'.

After I shut the macro off it then comesup with an error saying there is not
enough memory to complete the operation. I am trying to merge a lot of data.

Ellen

 

[Rod Gill]

What do you mean by a lot of data?
How much memory does your PC have?
What other applications do you have open?
What version of Windows with what service pack level?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

I get this error message when I try to run a macro to merge fields from an
ecell sheet into projet

2147417848
Method 'FileOpen' of object '_MSProject' faile

here is the code

Sub Import2()

FileOpen Name:="\\Whale\user_data\Project
Admin\Schedules\MSProject\Company
Schedule\SP Schedule Working\import.xls", ReadOnly:=False, Merge:=1,
FormatID:="MSProject.XLS8", map:="Import_Text7"
FileOpen Name:="\\Whale\user_data\Project
Admin\Schedules\MSProject\Company Schedule\SP Schedule
Working\import.xls",
ReadOnly:=False, Merge:=1, FormatID:="MSProject.XLS8", map:="Import_Text4"
FileOpen Name:="\\Whale\user_data\Project
Admin\Schedules\MSProject\Company Schedule\SP Schedule
Working\import.xls",
ReadOnly:=False, Merge:=1, FormatID:="MSProject.XLS8", map:="Import_Start"

End Sub

It always errors on the final line of code ie. the thrid time I do a
'FileOpen'.

After I shut the macro off it then comesup with an error saying there is
not
enough memory to complete the operation. I am trying to merge a lot of
data.

Ellen


__________ Information from ESET Smart Security, version of virus
signature database 4634 (20091124) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4634 (20091124) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Joy]

i use fileopen to import data in a csv file to project file and I also got
the same error
the trick part is it usually occurs the first time the function runs, and
after that, if you rerun it, it works all right.
and it is pretty random. the error doe not happen to all files
another funny thing is always happens with Project 2007.

really a pain

and no alternates to the function. I mean, seems the only way to import data
from csv file to project