Recent content by pe

wowie! thank you very much

I need a formula that if the value of the cell is a hyphen then it looks at the letter in parens in column A of the matching row and deletes that letter from the column one right of where it found the hyphen. For instance, if a hyphen appears in F15. In A15 there is a (N) at the end of the text...

Thank you so much for this. I am not expert enough, however, to know how to make it work. I have test.xls and test.ppt. In A1:A30 i have file names such as west.jpg, east.jpg... The jpg's are in C:/test/images/test.xls (worksheet is called images) The excel and ppt files are in C:/test From...

I have an Excel sheet with 40 files names in column A. Cell A1 is C:\main\images\4279.jpg, Cell A2 is C:\main\images\37.jpg, Cell A3 etc. down to A40. I want to write a macro to put these logos in 40 matching powerpoint files. For instance, the 4279.jpg goes 1" down and 2" to the left...

Hey, that's a good one. It works and thanks so much

I need to search 5000 rows for "Q1. " ... "Q71. " and delete the question and numeral part. Then i need to make the font underlined in the cell and "proper case", it's now all caps. Something like... for i=1 to 5000 search for Q.## delete Q.## activecell.select...

I need to search 5000 rows for "Q1. " ... "Q71. " and delete the question and numeral part. Then i need to make the font underlined in the cell and "proper case", it's now all caps. Something like... for i=1 to 5000 search for Q.## delete Q.## activecell.select...

ok, thank you. I need to add this to a much larger macro and that's why i was looking for code. thanks

I need to make a macro that will hide any rows in a range that includes columns A, B, C and D where B, C AND D have a hyphen in them. Something like if rows("B:B") AND rows("C:C") AND rows ("D:D") = "-" then hide that row. I don't know the vba code to do...

I have a worksheet named "data". i am entering date, qty, job#, and staff. On the next sheet i want to automatically calculate for each month the count of job#'s and total qty by month. I don't know how to sort and calculate the data sheet to give me these totals. On another worksheet...

I have an access 2000 mdb and a vb6 application that connects to it using ADO. I want to show the "postponed" field from my mdb in my vb6 form but it won't check or uncheck the checkbox according to the different records in the mdb. this is my code... chkPostponed.Value =...

Is it possible to take a column from Excel xp/2000 and import it into an Access xp/2000 as a row. The headers (fields) reside in excel as a column and there are too many to put as excel column heads so we want to take the row of 5,000 labels and put them into access as the first row of a new...

I'm confused. I set a reference in VB6 to MS Data Report Designer SP4 (MSDBRptR.dll) and added the component msdbrpt.dll to my VB6 project. When I Add a Data Report from the Project menu i get the error Class not registered. Looking for object CLSID... Can anyone ask me why I get this error...

I have a field in my tblProject table called JobNo. I'm trying this code from a command button on my form. I have an ado control on my form called adoProject which is connected to tblProject. Private Sub cmdSearch_Click() Dim JobNoInput As String Dim sqlText As String JobNoInput =...

wow! thanks so much