Microsoft Project
! .
 
 FAQFAQ             
            

 
Facebook
11.000 MS Project
, Facebook
 

1, 2  .
 
           ->
::  
1901



: 15.07.2009
: 129

: , 04 2010, 15:49     :

oey p coxpae poea opae excel (c popa project a e e epeca) e coxpaec cpyypa aa oaa? Ka oo oc?
Twilight



: 06.08.2008
: 1004

: , 04 2010, 15:56     :

coye o Outline oo aa
    e-mail
1901



: 15.07.2009
: 129

: , 04 2010, 16:14     :

Moo oopoee? Bo aa coxpa a, pa coxpa ae, ce ey o -> aa pa a excel, ae oec acep copa Project a coy ye coay cxey, a o o peaaee e oa eoo Embarassed
Twilight



: 06.08.2008
: 1004

: , 04 2010, 17:44     :

B oee pa co cocey cxey coxpae ax poe Excel, a aa ec oe oopoe a epc aaec outline code, e oopaaec a ao ypoe axoc aaa: 0 - ca poe, 1 - a ..
    e-mail
1901



: 15.07.2009
: 129

: , 05 2010, 10:01     :

Macep copa
C oo acepa copa oo coa cxey copa (Cxea copa-opa. Haop cpy, aa Project ax copa opa, opo eoxoe ea oe. B Microsoft Project ec cpoee cxe opa-copa.) coxpa ae Microsoft Office Project opae, pacoaaeo py poee. Cxea copa opaye o (oe. Pacooee ce, ope apae, coepaee opeeey opa o aae, pecypce aae. Hapep, ce oe ec a coe. B ope oe oe oc a oe oe e peca eco coe.) poea a opao, o pyoe poee oe pacoa x paoa c . B acoc o paoo opaa, y ooae oe oooc copa (cop. epeaa ax Project pyy popay, apep Excel. p cope ax ooae pae coae cxey, aay coooe ey o Microsoft Project coa aa peyao.) eoopx cex oe poea. C oo acepa copa oo coppoa ae poea ceyx opaax:

Ka Microsoft Excel (XLS)
Coa aa Microsoft Excel (XLS)
Tec, paee ao ay (TXT)
Paee a (CSV)
Pacpe pae (XML)
Mecoooee aoooo oa
Opoe apye poe, ae oopoo yo coppoa. B e a epe oay Coxpa a. B oe T aa epe y opa aa (opa aa. Kope coco coxpae opa ae. Pae popa coy pae opa ao, oope yaac c oo pacpe e ao.). Hae oy Coxpa, oce eo oc aaa cpaa acepa copa. Hae oy aee.

opooe ocae
Cpaa ae
ao poea (Excel) Bpae ae p cope ax y Excel epe y ao poea (Excel) Bpae ae, o ec apao o yoa. Ec pa apa ao poea (Excel), ooeoo peopaoa e peyec. ae aoaec peopayc c oo cpoeoo aoa, papaoaoo copa ax Project Excel.

Cpaa Cxea
Hoa cxea Bepe y Hoa cxea, ec yo coa c y oy cxey copa oo opaa aa. o apa aa o yoa.

cooa cyecyy cxey Bepe apa cooa cyecyy cxey, ec yo cooa coay coxpaey paee cxey ooy cxey, peocaey Project.

Cpaa Bop cxe
a cpaa oopaaec, ec pa apa cooa cyecyy cxey a peye cpae Cxea.

Bepe cxey, oopy yo cooa. o cco ae cxe copa, peocaee Project, a ae ce paee coae coxpaee cxe.
o e cxey, ae oy aee. Hae oy ooo, o eeeo coppoa ae cooec co cxeo.
Cpaa apaep cxe
Pae Bepe ax copa
3aa aae, o ce ae aa (3aaa. ec, ee aao oe. a poeo coco aa.) poee o coppoac pao opae ao (opa aa. Kope coco coxpae opa ae. Pae popa coy pae opa ao, oope yaac c oo pacpe e ao.). ( ae e a opeee ae aa (opeee. 3aa, pecypc aae c pacpeeeo o pee opae. ooae ee oooc pocapa opeee ae a o ocy epo pee ox pao ac pecae cooa aa cooa pecypco.).)

Pecypc aae, o ce cee o pecypcax (Pecypc. coe, oopyoae aepa, coyee oe aa poee.) poee o coppoac pao opae ao. ( ae e a opeee ae pecypca.)

Haae aae, o ce cee o aaex (Haaee. Kope pecypc, aae opeeeo aae.) poee o coppoac pao opae ao. ( ae e a opeee ae aae.)

Pae apaepo Microsoft Office Excel
o pae oopaaec, ec ae coppyc y Excel.

cop ae aoo aae, o o a Excel, coepa ae poea, ye a cpoy aooo coo ca, apep Haae aa, eoc, aa aaa . . o ao ycaoe o yoa.

Ba cpo aae p oe aae, o cpo aae (Haaee. Kope pecypc, aae opeeeo aae.) o e ece c aaa (3aaa. ec, ee aao oe. a poeo coco aa.) pecypca (Pecypc. coe, oopyoae aepa, coyee oe aa poee.), ae ec ao Haae e ycaoe.

Pae apaep ecooo aa
o pae oopaaec, ec ae coppyc eco a (paee aa ay a).

cop ae aoo aae, o o eco a, coepa ae poea, ye a cpoy aooo coo ca, apep Haae aa, eoc, aa aaa . . o ao ycaoe o yoa.

Ba cpo aae p oe aae, o cpo aae (Haaee. Kope pecypc, aae opeeeo aae.) o e ece c aaa (3aaa. ec, ee aao oe. a poeo coco aa.) pecypca (Pecypc. coe, oopyoae aepa, coyee oe aa poee.), ae ec ao Haae e ycaoe.

Paee eca aae, ceye ae, oocec pa coa, pae aa ay, poea a.

co aa aae co ecooo aa, apep Windows (ANSI), ooaa eco a Windows, cooecy caapa ANSI.

Cpaa Coocaee aa (Coocaee pecypco Coocaee aae)
Pae Coocaee ax aa (Coocaee ax pecypco Coocaee ax aae)
Koeoe aae oeoo aa, oop coppyc ae.

p copa aae o p (p. Cpeco oopa oopaaeo eeo opa o aae pecypce. Oop oec o opeee yco. Hapep, oa peec p Kpece, oopaac oo pece aa.), oop ye pee coppye a. o yoa paec p Bce aa Bce pecypc. Bepe o pyo p, oop yo pe coppye a. Ec coppyc oo aae (Haaee. Kope pecypc, aae opeeeo aae.), cooae po eooo.

Taa peopaoa ax
o Microsoft Office Project oaae ea coppyex oe Project. ee ycy ey ee o epe eo cca. Ec coppyc aa (3aaa. ec, ee aao oe. a poeo coco aa.), oopaac o aa. Ec coppyc pecypc (Pecypc. coe, oopyoae aepa, coyee oe aa poee.), oopaac o pecypco. Ec coppyc aae (Haaee. Kope pecypc, aae opeeeo aae.), oopaac o aae.

B oeoe oe aae o, oopoe ye cooac a aooo coa x ax. ea o yoa aoc cpay oce oa o poea, o p eoxooc oo e. o oe ocyo, oo ec ycaoe ao cop cpo aooa cop ae aoo a cpae acepa apaep cxe.

T ax aae, a yy eppepoac ae coppyeo opae (opa aa. Kope coco coxpae opa ae. Pae popa coy pae opa ao, oope yaac c oo pacpe e ao.), apep a ec, a, ca, eee e . .

Ko oa
Bepx epeeae ooee paoo o epx a, o oo oopaaoc coppyeo ae pae pyx oe.

B epeeae ooee paoo o a, o oo oopaaoc coppyeo ae oce pyx oe.

oa ce Bcae ce ocye o poea paoo a (3aaa, Pecypc, Haaee) cxey copa.

Oc ce ae ce o, eee ay cxe copa, o oo o aa ce caaa.

Bca cpoy oae oy cpoy a pao cpoo. a oa ocya, oo ec oac cocee pae o, a e ce o.

a cpoy ae pay cpoy a cxe copa.

aoa aa Opae aoooe oo Bop aoo a coocae oe. C oo oo aoooo oa oo coppoa o, aee ceao ae Project.

Oo Opae
MS Project Oopaae ea coppyex oe Project.

Koee o oaae cooecye ea oe coppyeo ae. o oe oopaaec, oo ec ycaoe ao cop cpo aooa cop ae aoo a cpae acepa apaep cxe.

Opae Oopaae opae aecx ax o e, oopo o yy coepac coppyeo ae.

Koe cpa opeee cxe
Coxpa cxey Opae aoooe oo Coxpaee cxe, c oo oopoo oo coxpa cxey oceyeo ee cooa o pyx poeax. o copoa y cxey oa ao poea (oa a. a Project (Global.mpt), coepa opa, oopy oo cooa pax poeax. oa a oe coepa apaep acpo pecae, aeape, op, oeo, a, po, aee cpyeo, cpo e, apoco, a ae pye apaep.) pyo a poea, oo cooa Opaaop.

ooo 3aepae poecc copa.
1901



: 15.07.2009
: 129

: , 05 2010, 10:02     :

oey y e a e o cpo e oo ypo yaa, Ec paa ee o aa epc project excel?
Twilight



: 06.08.2008
: 1004

: , 05 2010, 13:59     :

Bpaee Ka Excel

Bpaee Hoa cxea, ae o aaax oec aa opa, oopo a peaaec pa ae o MS Project o aaa xoe coppoa Excel. Bo o ao ac o pa o OutlineCode a e a paec oe Haeoae aa ..
    e-mail
1901



: 15.07.2009
: 129

: , 05 2010, 14:39     :

o a pycco epc o cpyyp, oc coe oopo acao 1,2,2 -o ec aaa e 2 oaa, po o e y?
Twilight



: 06.08.2008
: 1004

: , 05 2010, 17:07     :

a o. Too Ko cpyyp oopaae ypoe aa poee.
1. - o aa, 2 - o aaa o a - B ae pepe.
    e-mail
1901



: 15.07.2009
: 129

: , 05 2010, 22:39     :

Me eo pyoe yo o, o cee aoe e o oopaee cyapx aa p x paepa oa( o o aepo a e, oo oo pyy cee. Ho ce poo ooe caco a oe)
TechMike



: 15.01.2011
: 3

: , 16 2011, 0:00     :

Tpeyec pe poey oo oa, a a ce oe o poea y Excel eaeo 2003 2007 epc.

Bpy Project 2010 excel 2003 co coo "poe" oyoc, o oo eo yo cpeca Excel peopaoa epeo.

Moo project 2010 py poe Excel ye c ocpoeo yao epapxe (ypo), o o o Excel ae y aa ec oaa?
nnickname



: 20.10.2011
: 11

: , 13 2012, 6:40     :

! .
, . , . .
TechMike



: 15.01.2011
: 3

: , 13 2012, 8:05     :

Excel, Excel 97-2003,
:


_




_
_


Alt-F11 :

:

Function countInstr(a As String) As Integer
Dim i As Integer
Dim s As String
i = 0
s = a
 Do While (1)
  If InStr(1, s, ".") <0> k) Then
  k = s
 End If
 If (Worksheets.Item(1).Cells(i, 10).Value = Empty) Then
  all = i
  Exit For
 End If
Next
Worksheets.Item(1).Cells(1, 11).Value = "% "

' main circle from count dot with group cells
For i = 1 To k
 For j = 2 To all
 Worksheets.Item(1).Cells(j, 11).FormulaLocal = "=(H" & j & "*100;2)"
 
  If (st = 0 And countInstr(Worksheets.Item(1).Cells(j, 10).Value) = i) Then
  st = j
  End If
  If (st > 0 And sp = 0 And countInstr(Worksheets.Item(1).Cells(j, 10).Value) < i) Then
   sp = j - 1
   Worksheets(1).Rows(st & ":" & sp).Rows.Group
   st = 0
   sp = 0
  End If
 
 Next
Next

    Range("1:1,B:B,G:G").Select
    Range("G1").Activate
    With Selection
        .HorizontalAlignment = xlGeneral
        .VerticalAlignment = xlBottom
        .WrapText = True
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
    End With
    Range("H:H,J:J").Select
    Range("J1").Activate
    Selection.EntireColumn.Hidden = True
    Range("A1:K" & all).Select
    Selection.Borders(xlDiagonalDown).LineStyle = xlNone
    Selection.Borders(xlDiagonalUp).LineStyle = xlNone
    With Selection.Borders(xlEdgeLeft)
        .LineStyle = xlContinuous
        .ColorIndex = 0
        .TintAndShade = 0
        .Weight = xlThin
    End With
    With Selection.Borders(xlEdgeTop)
        .LineStyle = xlContinuous
        .ColorIndex = 0
        .TintAndShade = 0
        .Weight = xlThin
    End With
    With Selection.Borders(xlEdgeBottom)
        .LineStyle = xlContinuous
        .ColorIndex = 0
        .TintAndShade = 0
        .Weight = xlThin
    End With
    With Selection.Borders(xlEdgeRight)
        .LineStyle = xlContinuous
        .ColorIndex = 0
        .TintAndShade = 0
        .Weight = xlThin
    End With
    With Selection.Borders(xlInsideVertical)
        .LineStyle = xlContinuous
        .ColorIndex = 0
        .TintAndShade = 0
        .Weight = xlThin
    End With
    With Selection.Borders(xlInsideHorizontal)
        .LineStyle = xlContinuous
        .ColorIndex = 0
        .TintAndShade = 0
        .Weight = xlThin
    End With
    Range("A1:K1").Select
    Selection.Borders(xlDiagonalDown).LineStyle = xlNone
    Selection.Borders(xlDiagonalUp).LineStyle = xlNone
    With Selection.Borders(xlEdgeLeft)
        .LineStyle = xlContinuous
        .ColorIndex = 0
        .TintAndShade = 0
        .Weight = xlMedium
    End With
    With Selection.Borders(xlEdgeTop)
        .LineStyle = xlContinuous
        .ColorIndex = 0
        .TintAndShade = 0
        .Weight = xlMedium
    End With
    With Selection.Borders(xlEdgeBottom)
        .LineStyle = xlContinuous
        .ColorIndex = 0
        .TintAndShade = 0
        .Weight = xlMedium
    End With
    With Selection.Borders(xlEdgeRight)
        .LineStyle = xlContinuous
        .ColorIndex = 0
        .TintAndShade = 0
        .Weight = xlMedium
    End With
    With Selection.Borders(xlInsideVertical)
        .LineStyle = xlContinuous
        .ColorIndex = 0
        .TintAndShade = 0
        .Weight = xlThin
    End With
    Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
    Range("A1").Select
    Columns("D:D").EntireColumn.AutoFit
    Columns("E:E").EntireColumn.AutoFit
    Columns("H:H").ColumnWidth = 7.29
    Columns("B:B").ColumnWidth = 67.29
    Cells.Select
    Cells.EntireRow.AutoFit
    Range("A1").Select
    Columns("A:A").EntireColumn.AutoFit
    Columns("H:H").Select
    Selection.EntireColumn.Hidden = True
    Columns("I:I").Select
    Selection.EntireColumn.Hidden = True

msgbox("Done")
End Sub
nnickname



: 20.10.2011
: 11

: , 13 2012, 9:02     :

- .
, , ..
TechMike



: 15.01.2011
: 3

: , 13 2012, 9:07     :

nnickname ():
- .
, , ..


, Worksheet_Change, .. - Enter. , .
.http://rn3aig.ru/excel_macros.txt
:   
           -> : GMT + 3
1, 2  .
1 2

 
 






© 2003 - 2009, MicrosoftProject.ru. .