|
|
|
date: Thu, 4 Sep 2008 15:37:01 -0700,
group: microsoft.public.project.developer
back
Re: open not as read only
1) opens up the save as dialogue box
2) no, it opens as read only even then
3) FileOpen Name:="U:\Estimating Log\Est Schedule\Take-offIndividual.mpp",
ReadOnly:=False, FormatID:="MSProject.MPP.12" but it still opens as read
only. i thought maybe it had to do with permissions, but i created the file,
so i should have read/write access to it.
"Rod Gill" wrote:
> What warnings do you get if you comment out the SetWarning statements?
>
> Can you open the schedule with write access manually?
>
> What code do you get if you record a macro of you opening the project (and
> it opens in write mode)?
>
> --
>
> Rod Gill
> Microsoft MVP for Project
>
> Author of the only book on Project VBA, see:
> http://www.projectvbabook.com
>
>
>
> "theintern" wrote in message
> news:B65B8760-A4C4-485B-8482-33445898EFD4@microsoft.com...
> > Can anyone tell me how to program it to open the file, not as a read only?
> > I
> > can't use a call shell method because somepeople are running OFFICE11 and
> > others OFFICE12 so the folders for Microsoft project aren't consistent.
> > thus
> > i have to use the following method, but when doing so it opens it as a
> > readonly, not allowing me to save changes when i'm done.
> >
> > thanks!
> > scott
> >
> > Public Function TriFilter2()
> >
> > Dim pr As MSProject.Application
> >
> > DoCmd.SetWarnings False
> >
> > Set pr = New MSProject.Application
> > pr.Visible = False
> > pr.FileOpen ("U:\Estimating Log\Est Schedule\Take-offIndividual.mpp")
> >
> > DoCmd.SetWarnings True
> >
> >
> > End Function
> >
>
>
date: Fri, 5 Sep 2008 05:46:09 -0700
author: theintern
Re: open not as read only
If the file opens read-only when you open it manually, there is nothing that
Project or project VBA can do. The problem must be with the
network/folder/permissions etc.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
"theintern" wrote in message
news:4BD99CF5-62DA-4242-813D-C423DE1BF666@microsoft.com...
> 1) opens up the save as dialogue box
> 2) no, it opens as read only even then
> 3) FileOpen Name:="U:\Estimating Log\Est Schedule\Take-offIndividual.mpp",
> ReadOnly:=False, FormatID:="MSProject.MPP.12" but it still opens as read
> only. i thought maybe it had to do with permissions, but i created the
> file,
> so i should have read/write access to it.
>
> "Rod Gill" wrote:
>
>> What warnings do you get if you comment out the SetWarning statements?
>>
>> Can you open the schedule with write access manually?
>>
>> What code do you get if you record a macro of you opening the project
>> (and
>> it opens in write mode)?
>>
>> --
>>
>> Rod Gill
>> Microsoft MVP for Project
>>
>> Author of the only book on Project VBA, see:
>> http://www.projectvbabook.com
>>
>>
>>
>> "theintern" wrote in message
>> news:B65B8760-A4C4-485B-8482-33445898EFD4@microsoft.com...
>> > Can anyone tell me how to program it to open the file, not as a read
>> > only?
>> > I
>> > can't use a call shell method because somepeople are running OFFICE11
>> > and
>> > others OFFICE12 so the folders for Microsoft project aren't consistent.
>> > thus
>> > i have to use the following method, but when doing so it opens it as a
>> > readonly, not allowing me to save changes when i'm done.
>> >
>> > thanks!
>> > scott
>> >
>> > Public Function TriFilter2()
>> >
>> > Dim pr As MSProject.Application
>> >
>> > DoCmd.SetWarnings False
>> >
>> > Set pr = New MSProject.Application
>> > pr.Visible = False
>> > pr.FileOpen ("U:\Estimating Log\Est
>> > Schedule\Take-offIndividual.mpp")
>> >
>> > DoCmd.SetWarnings True
>> >
>> >
>> > End Function
>> >
>>
>>
date: Sat, 6 Sep 2008 09:18:48 +1200
author: Rod Gill rodATproject-systemsDOTcoDOTnz
Re: open not as read only
SP3 is required for Project 2003 to open Project 2007 format files. If
someone else opened the file in 2007 and saved in 2007 then that is probably
the problem. Install SP3 to see if it fixes the problem, but usually if you
don't have SP3 you can't open the file at all, even in read only mode.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
"theintern" wrote in message
news:C1FBD511-5E85-4C9A-9D05-78A2A32411AE@microsoft.com...
> Also, it opens a help box that says it detected that the file i'm opening
> was
> created in Project 2007 and might contain some features not available in
> 2003
> (which is what i'm running). i know this to not be the case since i
> created
> the file, but i think we opened it on someone else's computer, in 2007.
> did
> that screw things up? it says it can be fixed by downloading SP3 for
> Project. should i do so?
>
> thanks!
> scott
>
> "Rod Gill" wrote:
>
>> What warnings do you get if you comment out the SetWarning statements?
>>
>> Can you open the schedule with write access manually?
>>
>> What code do you get if you record a macro of you opening the project
>> (and
>> it opens in write mode)?
>>
>> --
>>
>> Rod Gill
>> Microsoft MVP for Project
>>
>> Author of the only book on Project VBA, see:
>> http://www.projectvbabook.com
>>
>>
>>
>> "theintern" wrote in message
>> news:B65B8760-A4C4-485B-8482-33445898EFD4@microsoft.com...
>> > Can anyone tell me how to program it to open the file, not as a read
>> > only?
>> > I
>> > can't use a call shell method because somepeople are running OFFICE11
>> > and
>> > others OFFICE12 so the folders for Microsoft project aren't consistent.
>> > thus
>> > i have to use the following method, but when doing so it opens it as a
>> > readonly, not allowing me to save changes when i'm done.
>> >
>> > thanks!
>> > scott
>> >
>> > Public Function TriFilter2()
>> >
>> > Dim pr As MSProject.Application
>> >
>> > DoCmd.SetWarnings False
>> >
>> > Set pr = New MSProject.Application
>> > pr.Visible = False
>> > pr.FileOpen ("U:\Estimating Log\Est
>> > Schedule\Take-offIndividual.mpp")
>> >
>> > DoCmd.SetWarnings True
>> >
>> >
>> > End Function
>> >
>>
>>
date: Sat, 6 Sep 2008 09:20:34 +1200
author: Rod Gill rodATproject-systemsDOTcoDOTnz
Re: open not as read only
i have SP3 already it turns out.
I need vba to be run in 07 that will save the file, but i need it to save it
without any of the 07 stuff. this was causing the problem. if you do it
manually, it comes up with these boxes asking if you want to save in the new
format, and if you say no to all of them then it does it correctly. however,
if i just run the vba FileSave, then it saves it in the new format and those
running 03 can only open it in read-only mode. i tried recording a macro of
me clicking No in all those boxes, but all it recored was FileSave.
thanks
scott
"Rod Gill" wrote:
> SP3 is required for Project 2003 to open Project 2007 format files. If
> someone else opened the file in 2007 and saved in 2007 then that is probably
> the problem. Install SP3 to see if it fixes the problem, but usually if you
> don't have SP3 you can't open the file at all, even in read only mode.
>
> --
>
> Rod Gill
> Microsoft MVP for Project
>
> Author of the only book on Project VBA, see:
> http://www.projectvbabook.com
>
>
>
> "theintern" wrote in message
> news:C1FBD511-5E85-4C9A-9D05-78A2A32411AE@microsoft.com...
> > Also, it opens a help box that says it detected that the file i'm opening
> > was
> > created in Project 2007 and might contain some features not available in
> > 2003
> > (which is what i'm running). i know this to not be the case since i
> > created
> > the file, but i think we opened it on someone else's computer, in 2007.
> > did
> > that screw things up? it says it can be fixed by downloading SP3 for
> > Project. should i do so?
> >
> > thanks!
> > scott
> >
> > "Rod Gill" wrote:
> >
> >> What warnings do you get if you comment out the SetWarning statements?
> >>
> >> Can you open the schedule with write access manually?
> >>
> >> What code do you get if you record a macro of you opening the project
> >> (and
> >> it opens in write mode)?
> >>
> >> --
> >>
> >> Rod Gill
> >> Microsoft MVP for Project
> >>
> >> Author of the only book on Project VBA, see:
> >> http://www.projectvbabook.com
> >>
> >>
> >>
> >> "theintern" wrote in message
> >> news:B65B8760-A4C4-485B-8482-33445898EFD4@microsoft.com...
> >> > Can anyone tell me how to program it to open the file, not as a read
> >> > only?
> >> > I
> >> > can't use a call shell method because somepeople are running OFFICE11
> >> > and
> >> > others OFFICE12 so the folders for Microsoft project aren't consistent.
> >> > thus
> >> > i have to use the following method, but when doing so it opens it as a
> >> > readonly, not allowing me to save changes when i'm done.
> >> >
> >> > thanks!
> >> > scott
> >> >
> >> > Public Function TriFilter2()
> >> >
> >> > Dim pr As MSProject.Application
> >> >
> >> > DoCmd.SetWarnings False
> >> >
> >> > Set pr = New MSProject.Application
> >> > pr.Visible = False
> >> > pr.FileOpen ("U:\Estimating Log\Est
> >> > Schedule\Take-offIndividual.mpp")
> >> >
> >> > DoCmd.SetWarnings True
> >> >
> >> >
> >> > End Function
> >> >
> >>
> >>
>
>
date: Mon, 8 Sep 2008 07:25:01 -0700
author: theintern
Re: open not as read only
Project 2003 SP3 can read 2007 files.
Or, in 2007 save as Project 2000-2003 format. Record a macro of you doing it
manually to see the code needed.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
"theintern" wrote in message
news:B07AEA00-1E77-41C5-9885-CB1DF0C62899@microsoft.com...
>i have SP3 already it turns out.
>
> I need vba to be run in 07 that will save the file, but i need it to save
> it
> without any of the 07 stuff. this was causing the problem. if you do it
> manually, it comes up with these boxes asking if you want to save in the
> new
> format, and if you say no to all of them then it does it correctly.
> however,
> if i just run the vba FileSave, then it saves it in the new format and
> those
> running 03 can only open it in read-only mode. i tried recording a macro
> of
> me clicking No in all those boxes, but all it recored was FileSave.
>
> thanks
> scott
>
> "Rod Gill" wrote:
>
>> SP3 is required for Project 2003 to open Project 2007 format files. If
>> someone else opened the file in 2007 and saved in 2007 then that is
>> probably
>> the problem. Install SP3 to see if it fixes the problem, but usually if
>> you
>> don't have SP3 you can't open the file at all, even in read only mode.
>>
>> --
>>
>> Rod Gill
>> Microsoft MVP for Project
>>
>> Author of the only book on Project VBA, see:
>> http://www.projectvbabook.com
>>
>>
>>
>> "theintern" wrote in message
>> news:C1FBD511-5E85-4C9A-9D05-78A2A32411AE@microsoft.com...
>> > Also, it opens a help box that says it detected that the file i'm
>> > opening
>> > was
>> > created in Project 2007 and might contain some features not available
>> > in
>> > 2003
>> > (which is what i'm running). i know this to not be the case since i
>> > created
>> > the file, but i think we opened it on someone else's computer, in 2007.
>> > did
>> > that screw things up? it says it can be fixed by downloading SP3 for
>> > Project. should i do so?
>> >
>> > thanks!
>> > scott
>> >
>> > "Rod Gill" wrote:
>> >
>> >> What warnings do you get if you comment out the SetWarning statements?
>> >>
>> >> Can you open the schedule with write access manually?
>> >>
>> >> What code do you get if you record a macro of you opening the project
>> >> (and
>> >> it opens in write mode)?
>> >>
>> >> --
>> >>
>> >> Rod Gill
>> >> Microsoft MVP for Project
>> >>
>> >> Author of the only book on Project VBA, see:
>> >> http://www.projectvbabook.com
>> >>
>> >>
>> >>
>> >> "theintern" wrote in message
>> >> news:B65B8760-A4C4-485B-8482-33445898EFD4@microsoft.com...
>> >> > Can anyone tell me how to program it to open the file, not as a read
>> >> > only?
>> >> > I
>> >> > can't use a call shell method because somepeople are running
>> >> > OFFICE11
>> >> > and
>> >> > others OFFICE12 so the folders for Microsoft project aren't
>> >> > consistent.
>> >> > thus
>> >> > i have to use the following method, but when doing so it opens it as
>> >> > a
>> >> > readonly, not allowing me to save changes when i'm done.
>> >> >
>> >> > thanks!
>> >> > scott
>> >> >
>> >> > Public Function TriFilter2()
>> >> >
>> >> > Dim pr As MSProject.Application
>> >> >
>> >> > DoCmd.SetWarnings False
>> >> >
>> >> > Set pr = New MSProject.Application
>> >> > pr.Visible = False
>> >> > pr.FileOpen ("U:\Estimating Log\Est
>> >> > Schedule\Take-offIndividual.mpp")
>> >> >
>> >> > DoCmd.SetWarnings True
>> >> >
>> >> >
>> >> > End Function
>> >> >
>> >>
>> >>
>>
>>
date: Tue, 9 Sep 2008 08:40:13 +1200
author: Rod Gill rodATproject-systemsDOTcoDOTnz
Re: open not as read only
FileSaveAs Name:="U:\Estimating Log\Est Schedule\Take-off.mpp",
FormatID:="MSProject.MPP.9"
does the trick. the important part is the .9 at the very end.
"Rod Gill" wrote:
> Project 2003 SP3 can read 2007 files.
>
> Or, in 2007 save as Project 2000-2003 format. Record a macro of you doing it
> manually to see the code needed.
>
> --
>
> Rod Gill
> Microsoft MVP for Project
>
> Author of the only book on Project VBA, see:
> http://www.projectvbabook.com
>
>
>
> "theintern" wrote in message
> news:B07AEA00-1E77-41C5-9885-CB1DF0C62899@microsoft.com...
> >i have SP3 already it turns out.
> >
> > I need vba to be run in 07 that will save the file, but i need it to save
> > it
> > without any of the 07 stuff. this was causing the problem. if you do it
> > manually, it comes up with these boxes asking if you want to save in the
> > new
> > format, and if you say no to all of them then it does it correctly.
> > however,
> > if i just run the vba FileSave, then it saves it in the new format and
> > those
> > running 03 can only open it in read-only mode. i tried recording a macro
> > of
> > me clicking No in all those boxes, but all it recored was FileSave.
> >
> > thanks
> > scott
> >
> > "Rod Gill" wrote:
> >
> >> SP3 is required for Project 2003 to open Project 2007 format files. If
> >> someone else opened the file in 2007 and saved in 2007 then that is
> >> probably
> >> the problem. Install SP3 to see if it fixes the problem, but usually if
> >> you
> >> don't have SP3 you can't open the file at all, even in read only mode.
> >>
> >> --
> >>
> >> Rod Gill
> >> Microsoft MVP for Project
> >>
> >> Author of the only book on Project VBA, see:
> >> http://www.projectvbabook.com
> >>
> >>
> >>
> >> "theintern" wrote in message
> >> news:C1FBD511-5E85-4C9A-9D05-78A2A32411AE@microsoft.com...
> >> > Also, it opens a help box that says it detected that the file i'm
> >> > opening
> >> > was
> >> > created in Project 2007 and might contain some features not available
> >> > in
> >> > 2003
> >> > (which is what i'm running). i know this to not be the case since i
> >> > created
> >> > the file, but i think we opened it on someone else's computer, in 2007.
> >> > did
> >> > that screw things up? it says it can be fixed by downloading SP3 for
> >> > Project. should i do so?
> >> >
> >> > thanks!
> >> > scott
> >> >
> >> > "Rod Gill" wrote:
> >> >
> >> >> What warnings do you get if you comment out the SetWarning statements?
> >> >>
> >> >> Can you open the schedule with write access manually?
> >> >>
> >> >> What code do you get if you record a macro of you opening the project
> >> >> (and
> >> >> it opens in write mode)?
> >> >>
> >> >> --
> >> >>
> >> >> Rod Gill
> >> >> Microsoft MVP for Project
> >> >>
> >> >> Author of the only book on Project VBA, see:
> >> >> http://www.projectvbabook.com
> >> >>
> >> >>
> >> >>
> >> >> "theintern" wrote in message
> >> >> news:B65B8760-A4C4-485B-8482-33445898EFD4@microsoft.com...
> >> >> > Can anyone tell me how to program it to open the file, not as a read
> >> >> > only?
> >> >> > I
> >> >> > can't use a call shell method because somepeople are running
> >> >> > OFFICE11
> >> >> > and
> >> >> > others OFFICE12 so the folders for Microsoft project aren't
> >> >> > consistent.
> >> >> > thus
> >> >> > i have to use the following method, but when doing so it opens it as
> >> >> > a
> >> >> > readonly, not allowing me to save changes when i'm done.
> >> >> >
> >> >> > thanks!
> >> >> > scott
> >> >> >
> >> >> > Public Function TriFilter2()
> >> >> >
> >> >> > Dim pr As MSProject.Application
> >> >> >
> >> >> > DoCmd.SetWarnings False
> >> >> >
> >> >> > Set pr = New MSProject.Application
> >> >> > pr.Visible = False
> >> >> > pr.FileOpen ("U:\Estimating Log\Est
> >> >> > Schedule\Take-offIndividual.mpp")
> >> >> >
> >> >> > DoCmd.SetWarnings True
> >> >> >
> >> >> >
> >> >> > End Function
> >> >> >
> >> >>
> >> >>
> >>
> >>
>
>
date: Tue, 9 Sep 2008 11:56:00 -0700
author: theintern
|
|
