Search results for query: *

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

I have a vb6 frontend that uses ADO to connect to access2000 mdb. I have a tblJobNo in my mdb. I want to search for a specific jobno in the mdb and don't know where to start. Is there a sample vbp that i could look at or some code. Thanks a lot for the help.

I want to have a form that enters records into my tblProject table in access. On this form I want to have a dropdown listbox that contains the JobNo's from tblJobNo and another one that has the clients from tblClient. (all 3 tables are in main.mdb) I will enter the ProjDesc, choose a JobNo and...

I have an excel file that has many links to a ppt file. I need to write a macro that will open ppt and then update the links and then break the links. When i use the macro recorder it doesn't give me any code? can anyone help me? thanks office xp, w2000

I have 3 tables; tblProject (ProjectID*, ProjDesc, ClientID*, JobNo*), tblClient (ClientID*, ClientName), and tblJobNo (JobNo*) in my access mdb. I used VB6's wizard to make a form. I can scroll thru my projects and view them fine. When i hit the "add" key i can add new projects but i...

I just created a 50mb slide show to music in powerpt xp (2002). I now have to burn to a CD for people without xp so i saved it as a pps and tried to play it on a machine with office 2000. The music was gone and the animations were different. I then downloaded the ppt viewer from the microsoft...