Search results

Actually i have a list of dealer with their TIN Number But i need to Verify these TIN Number on this website that is :http://rajtax.gov.in/vatweb/dealer/dealerMain.jsp?viewPageNo=13 so problem is this it takes so much time so i need a vba code with loop so that Name of dealer will show...

Actually i have a list of dealer with their TIN Number But i need to Verify these TIN Number on this website that is : http://rajtax.gov.in/vatweb/rightMenu.do so problem is this it takes so much time so i need a vba code with loop so that Name of dealer will show automatically in next...

i m inserting a .xls file here for your observation. in this file i have a ( picture in which some text are mentioned). basically this is a code i want that code will be get in cell f1 as a text. so is it possible to get text from a picture. Any help will be much appreciated. Thanks &...

suppose i have 15 items in Column A of sheet1. now i filtered A column on some criteria and 7 items are showing on sheet 1 column A. now i want to add only filtered (7) items on combobox 1 but how? Thanks in advance Regards CA Mahaveer Somani

Actually i m using EXCEL 2007. i made a very important userform for my organisation using excel vba on a excel file , now i want to change the icon of this excel file. Can i do it ? i know we can do it but how i dont know..bcoz several times i downloaded "Sir J B7" answer sheet and those...

is it possible that any vba code can search all the .xls file in my computer and then cut them and paster to my destination place......? thanks in advance... Regards CA Mahaveer Somani

actually i have a button on sheet1. when i press it then userform1 open. and on userform1 i have 4 labels... but all are unvisible now my problem is that... i want when my userform open then after 1 second the first label visible = true...and the same after next 1 second the second label...

actually i m trying to build an excel file with animated pictures for my wife for the occasion of my anniversay. i insert the animated picture. but it is not animated on userform...so how can i do this...any body can help me? Regards CA Mahaveer Somani

actually i want to import data from one site therefore when i goto "DATA tab" and click on "from web" and it opens internet explorer. now i want there will open google chrome it is possible? becoz from which site i want to import data does not support internet explorer. any help will be...

i had a problem regarding fifo method.......can anyone help me on this.....i have put my file on the following link........and had write my problem in the same file...... i had tried so much but i did not get any solution on this......any one can help me..... Thank in Advance...

i want to put a formula in attached file for calculation of profit as per First in First out method...(FIFO) method... if is there any vba module you can provide me then also i can manage that one... any one can help me...? my sample query data and expected output (profit) manually done in...

i have two workbook in D drive path is as follows: D:x.xlsx [have data in sheet1 range(A2:A15)] D:y.xlsx i want to make data validation in y.xlsx sheet1 range("A2:A15") from the source of D:x.xlsxsheet1!$A$2:$A$15 is it possible to make data validation if the source list is in another...

Hi, I have two columns of address, and I need to compare with these two columns and find the difference of the word. Example:- 1105 W Riverside Dr 1105 West Riverside Drive I need the difference between these two columns as est rive. Do we have any functions to do so? I have attached...

actually i have very huge data row wise and column wise so i need a macro for the following:Sheet1: A B C D E F G H I J K L M N LIKE THIS SO ON... 1 J K H K K K J K I U 2 H K U P R G H J K F G B N Y LIKE THIS SO ON... like this so on...row wise too..this is now upto 25000 rows...data...

Problem: if usr ID 1 is reapeated Twice and degree of both are "yes" then output of degree also "yes",if usr ID 2 repeat twice and correspondence degree one is "yes" another is "no" then output degree is "yes".in the cause both are "no" then o/p is "no" same thing applicable for N/A. file...

I have five issues regarding inventory valuation...... almost i have done but still i have to find out some thing more.....so i am attaching a file in which i m following FiFo Method of inventory. http://www.2shared.com/document/zneWMfaz/datafile.html Thank you very much in advance Regards...

what is use of dropbox....? actually i have an excel sheet and i want that my users which are living in another city can access my file via internet is it possible through dropbox or via any other application. but my excel file contains some userform.

in Cell A1 - 01-01-2013 in cell f1 - 'F:data[EMPLOYEE7.xlsx]EMPLOYEE7'!$A$2:$C$31 in cell b1 - =VLOOKUP(A1,F1,2,FALSE) but i m getting my answer b1 = #N/A my path is accurate i already checked it but what is the problem in vlookup formula?

i want to put data entry in closed excel file from open excel file userform. but how?

i have two excel file one is datafile.xls in "f" drive which is closed another file is workingfile.xls on desktop this is open file now i want to paste the data from sheet1 range column A to datafile.xls without open the datafile.xls is it possible?

i have one userform on which there are 5 textbox textbox1 = serial number textbox2 = invoice textbox3 = suplier name textbox4 = item name textbox5 = amount and i have one command button = save. when i click on save then data from all textbox will save in sheet1 on coloumnA,B,C,D,E now i...

I have put the following code m i right ? Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) msgbox "Do you want to add one more text box",vbYesNo If ans = Yes then textbox3.visible = true textbox3.setfocus else commandbutton1.setfocus end if end if End Sub If i m right...

i have a userform with multipage1. On multipage1 there are 3 pages. 1 page = Creation 2 page = Suppliers (visible = false) 3 page = Inventory (visible = false) on 1 page i have two command button. 1 command button = Add suppliers 2 command button = Add Inventory the command on 1st...

can i add tool strip on my userform1. Is it possible?

i want that my excel file will open automatically on 12/20/2012 at 3:00 pm. is it possible?