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 TugboatEng 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. mtroche

    Calling procedure from a sheet in Excel

    Thanks for ypur reply, ivymike. You are right! The problem was inside the TRET procedure not in how I am calling it. Thanks again for your help.
  2. mtroche

    Calling procedure from a sheet in Excel

    I am calling a procedure called TRET from an UserForm. TRET is located in sheet6. Here is part of my code: If A=1 then sheet6.TRET else call SUGAR end if The problem is that I can't call TRET from sheet6!! It says that there is a "Type mismatch". What I am doing wrong!!
  3. mtroche

    Checking if a file exists.

    I have this SUB to look if a file exists. If the file exists it's supposed to do nothing, but if it doesn't exists the file is created. The problem is that if the file already exists the following error occurs: "Path not found." Of course, the file "X" does exists in "c:\". Sub test() If...
  4. mtroche

    Printing a form with caption

    I have a userform and inside it there is a form with a caption; you know, those letters that cosses the line of the frame. Well, the thing is that I can see the caption in my monitor but, when I print it, it just print everything but the frame's caption. Any help?
  5. mtroche

    Sewerage Vacuum System

    I'm searching information on the Sewerage Vacuum System for a main sanitary sewage but I can't find any information even at http://www.usepa.gov Do anyone knows where can I get any inforamtion on this?
  6. mtroche

    Delete or Clear RowSource

    How do I delete or clear a rowsource from a combobox? I have a userform called "A" and a combobox called "B". I am trying to use this command, but it doesn't works: A.B.RowSource = " " Any suggestion will be very helpful because I have no idea on how to do that. Att. MTroche
  7. mtroche

    Deflection for Concrete Prestressed Power Pole

    What is the recomended deflection for a concrete pole? I am working with them and I don't want to make my design too expensive neither too frightening to the people looking the poles too inclined, although it's safe. Thanks for any help.
  8. mtroche

    calculate transmission monopole

    But.. what is the recomended deflection for a concrete pole? I am working with them and I don't want to make my design too expensive neither too frightening to the people looking the poles too inclined, although it's safe. Thanks for any help.
  9. mtroche

    [b]Copying cells' values to a page in a multipage.[/b]

    I want to copy some cells' values from a worksheet to a page in a multipage, but I can't find how to do this. Note that the worksheet and the multipage is at the same workbook. Following is the code I'm trying to use, but it desn't works. Private Sub CommandButton6_Click()...
  10. mtroche

    Working with a MultiPage.

    Hallow Everyone: I want to open a page from a MultiPage thru a VBA Program in Excel, but I have no idea how to do it. Also, I want to make, let's say the page #2, available in some occasions. How can I do it? Att. MTroche
  11. mtroche

    Reading Excel File Properties Using VBA in Excel

    Thanks, joerd: I'll try it and see how it works for me.
  12. mtroche

    Reading Excel File Properties Using VBA in Excel

    Hellow Everyone, I need help in making a VBA program in Excel to read the Created, Modified and Accessed Date and Time of an Excel file when the same Excel file opens. I know it can be done reading the file properties, but how can I do it? I'll appreciate any help.
  13. mtroche

    "CommandBars" not recognized in EXCEL.

    I am trying to automatically hide all toolbars when I open this workbook, but the program always says that CommandBars is empty. What I am doing wrong?! Below you can see my program. 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Private Sub Workbook_Open() Call HideAllToolbars...
  14. mtroche

    [color #ff0000]Problems with IF.. .Then

    Hi, MSmith: Thanks for requesting my posting, but I have already fixed the problem... It should be a "bug" in EXCEL. Everything is Bullet Proof until the gun fires!! :-)
  15. mtroche

    [color #ff0000]Problems with IF.. .Then

    ...If TensionDistance <> &quot;At the Lowest Point&quot; Then Worksheets(&quot;(TSag)2&quot;).range(&quot;ap30&quot;) = TensionDistance * 3.28 Sheet6.Iterating_For_ClearanceB Else Worksheets(&quot;(TSag)2&quot;).range(&quot;ap30&quot;) = &quot;&quot...
  16. mtroche

    Variable not accepting a range of values.

    ...If TensionDistance <> &quot;At the Lowest Point&quot; Then Worksheets(&quot;(TSag)2&quot;).range(&quot;ap30&quot;) = TensionDistance * 3.28 Sheet6.Iterating_For_ClearanceB Else Worksheets(&quot;(TSag)2&quot;).range(&quot;ap30&quot;) = &quot;&quot...
  17. mtroche

    References for laterally loaded pole foundation

    I have the same problem that you have but for a power concrete pole foundation and there is a book that should be the reference that you are searching for. Check out the following book: &quot;Foundation Design, Principles and Practices&quot;, Donald P. Coduto, PE, GE, Prentice Hall. In this...
  18. mtroche

    How to analize the lateral forces in a soil due to a pole?

    Searching in my soil mechanic books I didn't find any information and formula about how to analize the forces that the wind or any other lateral force acting on the pole causes the pole itself to drift. I am trying to analize the lateral forces in the soil due to the forces acting on a...
  19. mtroche

    How do I show a list of unique items in a ComboBox?

    I have a ComboBox showing the items from an array, but there are some repeated items and I don't want to show the same item twice or more in the ComboBox. How can I do it? How can I make the ComboBox to show each item from the same array just one time and don't show repeated items? I will...
  20. mtroche

    How do I show a list of unique items in a ComboBox?

    My program is in VBA. I have a ComboBox showing the items from an array, but there are some repeated items and I don't want to show the same item twice or more in any ComboBox. How can I do it? How can I make the ComboBox to show each item from the same array just one time and don't show...

Part and Inventory Search

Back
Top