Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. FrenchCAD

    how to check via VBA if a custom column exists in tasks view?

    Hi all, I wrote a VBA macro in MSP to insert a column (TaskColumn Flag20) to display specific indicator. It works well except that it creates the column each time I open the project file. Hence I am looking for a way to check if the column exists and is visible when opening file to disable...
  2. FrenchCAD

    Looking for a file in a folder and creating associated hyperlink

    ...FilePath, FileName, FileSearch As String For ligne = 4 To 400 FilePath = "V:\ERP-doc\Doc archive" FileName = Dir(FilePath & "\*.pdf") FileName = CStr(FileName) FileSearch = Left(Range("B" & ligne).Value, 15) If Len(FileSearch) > 14 Then...
  3. FrenchCAD

    Looking for a file in a folder and creating associated hyperlink

    ...LoopThroughDrawingFiles() Dim FilePath, FileName, FileSearch As String FilePath = "V:\ERP-doc\Doc archive" FileName = Dir(FilePath & "\*.pdf") FileName = CStr(FileName) For ligne = 1 To 400 FileSearch = Left(Range("B" & ligne).Value, 14) Do While (FileName...
  4. FrenchCAD

    Importing Excell Worksheet into Project

    I would say that I suspect Visual Basic macro to be the sole solution as I never heard/saw about this. I know you can export to Excel for sure but I wouldn't bet you can easily import from it. Cyril Guichard Defense Program Manager Belgium
  5. FrenchCAD

    Changing Data Values

    I don't have any issue either Cyril Guichard Defense Program Manager Belgium
  6. FrenchCAD

    Converting meters into Trimble acceptable unit

    sounds like you have figures in millimeters rather than kilometers, no? Cyril Guichard Defense Program Manager Belgium
  7. FrenchCAD

    MS Project Server Slow

    MSP 2003 is a bad piece of software so far with regards to performances. MSP 2003 Server is a little bit better but still it has poor performances (We also use both of them at office). I heard that MSP 2007 is alot better on this topic. Cyril Guichard Defense Program Manager Belgium
  8. FrenchCAD

    New Open Source Project Management Tool

    In a perfect tool, you shall have the ability to modify your local or your online data as you wish and be able to synchro both of them in both ways (online <> offline). Not to mention the fact it shall be multiusers, which I am aware of, would make it alot more difficult. Cyril Guichard Defense...
  9. FrenchCAD

    New Open Source Project Management Tool

    Hi babynus, Sorry, but it wasn't me proposing to make an Open Office add-on, it was PeterStock :) I'll have a look at your link. Does your offline version offer synchro with your online version? Cyril Guichard Defense Program Manager Belgium
  10. FrenchCAD

    New Open Source Project Management Tool

    huh, sounds like a huge project you know? but I like the idea as I've been looking for this kind of solution for awhile as well. I'd be glad to help for anything related to alpha-beta testing and so on. Cyril Guichard Defense Program Manager Belgium
  11. FrenchCAD

    Multi resourec for one task

    Did you try to allocate hours of work to your ressources? Cyril Guichard Defense Program Manager Belgium
  12. FrenchCAD

    Calling it a day....but at what time?

    you guys oversea are really questionning about this matter. in my company, as long as I do -at minima- my 40 paid hours a week, no matter if it is 5 x 8 or any other arrangement. so I for sure can leave at 3 on monday, long as I put the 2 missing hours anywhere else in my week. And even if I...
  13. FrenchCAD

    Calling it a day....but at what time?

    Since I usually perform 45/50 hours a week and am paid for only 40, I don't bother much asking me this kind of question and leave earlier if needed Cyril Guichard Defense Program Manager Belgium
  14. FrenchCAD

    unexpected formula update when referenced cells are moved

    Well, Excel is programmed in such a way that if you move a cell which is referenced elsewhere in a formula, then the formula is automatically updated. That's the way it works. One has to admit it can be kind of useful to avoid updating formulaes each time we make a change on our spreadsheet. Of...
  15. FrenchCAD

    why don't these loops work?

    Why don't you use a for loop? something like : For changeCell = 1 To 10 changeCell.GoalSeek Goal:=seekValue, changingCell:=changeCell.Offset(0, -4) seekValue = seekValue + (seekValue * Inflation) End For Cyril Guichard Defense Program Manager Belgium
  16. FrenchCAD

    Are machining marks required in all views in a drawing?

    I would second Peter and say that it is only required once except for clarity purposes Cyril Guichard Defense Program Manager Belgium
  17. FrenchCAD

    Where are all of the master tradesman?

    One thing I notice though amoung all your statements, to which i give alot of credit by the way, is that the master tradesman you're all looking for may not be as far as you think, as there is alot of competence amid people in this forum. If you are like me, you probably feel lower than those...
  18. FrenchCAD

    Temperature rise as K? &amp; ANSI/UL 875

    as it sates "temperature rise", it means that your temperature increase is acceptable up to 140°C (delta temperature between min and max) Cyril Guichard Defense Program Manager Belgium
  19. FrenchCAD

    Temperature rise as K? &amp; ANSI/UL 875

    K stands for Kelvin. Typically, 1°K = 1°C, just that 0°K is absolute zero in °C, i.e. -273 °C. Look for Kelvin in Wikipedia. Cyril Guichard Defense Program Manager Belgium
  20. FrenchCAD

    Excel format question

    I am not sure you will have any mean to do this in Excel, except maybe via the equation editor Cyril Guichard Defense Program Manager Belgium

Part and Inventory Search

Back
Top