Hi Manish, Thx a lot for your quick reply. I searched for file you mentioned but couldnt get it.May be I will try again.Mean while if you can send me that file in email then it is good.
I will check your file and let the group know whether all my queries are resolved or not. Thx a lot for your reply. Wish you all very happy new year. Regards, Premal On Dec 30, 11:43 am, Manish <pansari.man...@gmail.com> wrote: > Hi Premal, > > Today, i uploaded one new file on our group "Excel_tutor.xls" > Try this, it will help you... > > Regds, > Manish > > On Dec 30, 9:32 am, Premal <premalpanc...@gmail.com> wrote: > > > > > Hi, > > I am very new to VBA. I know C++.I have few questions related to Excel > > programming. > > 1) I have two xls files Rate.xls and Bill.xls. Rate.xls file contains > > two columns which has heading ItemNo and ItemRate.Now I want that in > > bill.xls when I enter ItemNo and quantity then final price should be > > calculated. For this I need that when I enter ItemNo it takes its rate > > from Rate.xls (I mean program should search itemNo and take row number > > so same number can be used to find rate from second column by giving > > proper cell ref) and multiply with quantity and put final price in > > next column.So how to do this?I dont need to make rate.xls visible to > > user(if possible). > > 2)Where shound I find complete documentation of All APIs.I didnt find > > good book which covers some functionalities like finding particular > > value in xls file and return row or column or cell ref for that, find > > first empty row and column. > > 3)How to use C# for excel programming. What should be installed for > > this. I have visual studio 2008 and Office 2003. Apart from that what > > I need to install.I heard about Office Tools,but I dont know how to > > install. > > > If these questions are already answered then pls send me link to that > > post so I can read and understand it. > > > I hope some expert will reply asap. > > > One can also send reply to premalpanc...@gmail.com > > Thak you very much in advance.- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts