Search results for query: *

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.

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!!

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

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?

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?

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

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.

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.

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()...

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

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

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.

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

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!! :-)

Below is the program tied to a userform in EXCEL. The userform is used to get the desired clearence below a powerline and the place from the lowest pole where the desired clearance will be calculated. The problem is that the span is 25 meters long and I can't calculate the clearance at the...

Below is the program tied to a userform in EXCEL. The userform is used to get the desired clearence below a powerline and the place from the lowest pole where the desired clearance will be calculated. The problem is that the span is 25 meters long and I can't calculate the clearance at the...

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: "Foundation Design, Principles and Practices", Donald P. Coduto, PE, GE, Prentice Hall. In this...

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

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

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