Search results for query: *

Dear Sirs, How a specific folder can be found using excel vba. Thanks for kind help. Best regards. Tahir

Dear Sirs, How can i clean internet history or temporary files using vba in excel. Thanks in advance for your kind help in this matter. Best regards. Tahir

Dear TonyJollans, A Lot of Thanks for your help. It great helped me. In my code 0 value cell was shown as empty cell and do while loop stops. May i ask why it consider 0 value cell as empty one. Thanks again for your kind help. Tahir

Dear TonyJollans & KenWright, Thank you for your help. But my problem is that i do not know the actual selection. i use this procedure: first i select the cell "D5" the following loop apply Do While Not ActiveCell.Value = Empty If ActiveCell.Value = 0 Then...

Dear Sir, I have some data in "column D". I values are from the result of a formula. I want to delete entire rows which contain zero values. I shall be very thankful for any help Best regards. Tahir

Dear Sirs, I want to copy an object. Then i move to the other location. i want to paste the object to the location where is my mouse now. Could any can help. Thanks in advance. Tahir

Dear PHV, Thanks for your help. I tried it but, it can print only one rows data at time. Best regards. sunny

Dear PHV, I am Sorry, I think i could not explain my procedure clearly. I want a loop that can print one row's data in specific format and then the other line should start. Thanks. Tahir

Dear Sirs, I have a list in excel in 12 columns and several rows, First column contains order no's. in (text type format) When the user presses the print button on the worksheet, the cell pointer moves to first column of active Row and data of active row is copied on other worksheet (...

Dear PHV, Thanks for your prompt reply. i am new to vba and i could not understand the SKIP's about DAO, ADO, and QBE Grid. So please give me any examples to how i can understand the ODBC. Best regards. tahir

Dear Sirs, Thanks all for giving attention to my question. it helped me very much. i want to ask dear PHV that what is ODBC (a some breif note) or sites where i can find help about ODBC. i will be very thankful to you. Best regards. Tahir

Dear Sirs, I want to get data from some workbooks which are not open. is it possible? Thanks. Tahir

Dear Geoff, Thanks for your suggestion. regards. Tahir

Dear Geoff, i have three command buttons on the userform1. Userform2 contains some textboxes. when the first button is clicked on userform1 then the sheet1 is selected and userform2 gets data from sheet1. when the second button is clicked on userform1 then the sheet2 is selected and...

Dear Sirs, i use an excel vba form (userform). when a command button on userform is clicked it selects a worksheet and then display a second userform. i use application.screenupdaing=false before the sheet selection. But it displays the sheet first and then second userform is shown. Thanks...

to everyone who knows better Dear Sirs, i want to hide all command bars from the excel application and want that the user should not unhide them. please help. thanks in advance. tahir

To any one who knows better. Dear Sirs, I have some object & combo box & an image control on a worksheet which is protected. the problem is that when the user changes the value of combo box the image picture does not change. if i unprotect the worksheet the user can change the other objects...

Dear PHV, Thanks for your prompt reply. Textbox is on a userform. Tahir

to any one who knows better. Dear Sirs, i use outlook express 6 in windows xp. I want to retreive subject, date, and messages in excel using vba. thanks. tahir

Dear PHV, Thanks for your reply. I am new to vba and do not know what the validation rule should apply. Please write a hint. Thanks in advance. Tahir