Recent content by mtroche

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