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. -- ---------------------------------------------------------------------------------- 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
