Hello Dear, Try to use tools-->macro-->vbaeditor-->insertmodule
and try to run simple programe http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm Hope it Will Help Happy To Help :) Prashant Tripathi On Fri, Apr 9, 2010 at 9:46 AM, nikhil deshpande <deshpande...@gmail.com> wrote: > > Kindly guide me to work in macros, how it works and how to use it. > Nikhil. > On Fri, Apr 9, 2010 at 4:58 AM, <excel-macros+nore...@googlegroups.com> > wrote: >> >> Today's Topic Summary >> >> Group: http://groups.google.com/group/excel-macros/topics >> >> Allow row hiding /unhiding with password protection [2 Updates] >> time management VBA code for txt file [2 Updates] >> Upload Excel data to Access, but Access not installed [5 Updates] >> Need Passward Cracker [1 Update] >> Urgent Help [3 Updates] >> Need urgent help. [7 Updates] >> Plz Help me urgent [5 Updates] >> IMPORT FIXED WIDTH TXT FILE TO EXCEL [3 Updates] >> Selecting cutting combinations of fabric [1 Update] >> Count number of times a part is out of stock without counting all days >> part is out of stock [1 Update] >> Need Help to find a date and time calculation [1 Update] >> how can protect the excel sheet in VBA Passward. [1 Update] >> Does anybody have games [2 Updates] >> Excel, go through Column B [1 Update] >> How to use logical expression in find method? [3 Updates] >> : HELP [1 Update] >> HELP: Appending multiple sheet into one [3 Updates] >> Single Data Type Number Length Growing [4 Updates] >> Access 2007 Bible [1 Update] >> >> Topic: Allow row hiding /unhiding with password protection >> >> Hanum <harsha...@gmail.com> Apr 08 07:57AM -0700 ^ >> >> I have an Excel report. The sheet needs to be password protected, at >> the same time users should be able to hide/ unhide rows and columns. >> >> Is there a way to do it? >> more... >> >> Paul Schreiner <schreiner_p...@att.net> Apr 08 10:41AM -0700 ^ >> >> Hide/Unhide is considered "formatting" of rows/columns >> When you protect the sheet, select the >> Format Rows >> Format Columns >> >> checkboxes. >> >> >> >> >> ________________________________ more... >> >> Topic: time management VBA code for txt file >> >> OSAVentures Calamba <osav...@gmail.com> Apr 08 05:58PM +0800 ^ >> >> *Dear VBA Experts,* >> >> I'm wondering if there is a code possible to summarize the contents of a >> text file as partly shown below. >> I received this file at a certain period. Thousands rows of records. >> more... >> >> paulwillekens <paul.johan.willek...@gmail.com> Apr 08 10:11AM -0700 ^ >> >> Hi Grace, >> >> Let's start with this... If any changes are needed, just tell me... >> >> Kind regards, >> >> Paul Willekens >> '======================================================================= >> more... >> >> Topic: Upload Excel data to Access, but Access not installed >> >> Chechu <cecic...@hotmail.com> Apr 07 06:24PM -0700 ^ >> >> Hi, I need some help in an export from Excel to Access macro. I have >> an Excel tool which will be used by many users. In this Excel, I have >> a range, let's say in Sheet 1, A1:B20, that I need to more... >> >> rf1234 rf1234 <rfhyd1...@gmail.com> Apr 08 10:20AM +0530 ^ >> >> Hello Dear, >> It is possible to import export using ADO Controls,I am bit Confuse, >> How i can send excel data to access when access is not install. >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> Hope it Will Help more... >> >> paulwillekens <paul.johan.willek...@gmail.com> Apr 08 02:19AM -0700 ^ >> >> Hi Chechu, >> >> Why not export that particular range in a .csv file, that would be >> stored in a dedicated folder on the network, and imported by Access on >> its own time... >> You need the macro to export more... >> >> Chechu <cecic...@hotmail.com> Apr 08 06:38AM -0700 ^ >> >> Hi Paul, >> >> I'm glad that you have an option to deal with this. Yes, I am fully >> open to your suggestion, each user exports as .csv in a shared drive >> and then I import in my Access database, in my more... >> >> paulwillekens <paul.johan.willek...@gmail.com> Apr 08 09:01AM -0700 ^ >> >> There are two sides: >> a) the user side: if a1:b20 is all the sheet contains, the user could >> save his sheet as "user.csv" in a particular folder >> but if the range to import in access is only part of more... >> >> Topic: Need Passward Cracker >> >> Jai <jaihumtu...@gmail.com> Apr 08 06:14PM +0530 ^ >> >> Dear All, >> >> Can you Give me VBA Passward Cracker, >> -- >> Thanks For Mail. >> more... >> >> Topic: Urgent Help >> >> sudhir kumar <bluecore...@gmail.com> Apr 08 01:50PM +0530 ^ >> >> Hi Madhu >> >> Please solve this attachment. >> >> >> >> -- >> Sudhir Verma >> Asstt. Mngr. A/c's >> 9211219649 >> more... >> >> Dilip Pandey <dilipan...@gmail.com> Apr 08 05:56PM +0530 ^ >> >> Dear Sudhir, >> >> Attached file has been solved per your requirements. >> >> Get back to me in case of any queries. >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY >> MBA-HR,B.Com(Hons),BCA more... >> >> Suryaprasad <suryaprasad...@gmail.com> Apr 08 06:22PM +0530 ^ >> >> Hey Sudhir, >> >> No need of a Look up....Only thing u can do a formulae for Transpose is >> required..please find the attachement. >> >> Surya >> >> more... >> >> Topic: Need urgent help. >> >> rf1234 rf1234 <rfhyd1...@gmail.com> Apr 08 11:41AM +0530 ^ >> >> Hello Dear, >> Hope u have got some call,if not i have approx 100 consultancy e mail id. >> if necessary reply,hope all vba job searcher will be also benefited. >> >> >> >> >> >> >> >> >> >> >> >> >> more... >> >> rf1234 rf1234 <rfhyd1...@gmail.com> Apr 08 12:00PM +0530 ^ >> >> Hello Dear, >> Go through,attached zipped. >> >> >> >> >> >> >> >> >> >> >> >> Hope it Will Help >> Happy To Help >> :) >> Shyam >> >> >> >> > the learning and support from the group.Let friends and co-workers know >> > they more... >> >> "saroj.32006" <saroj.32...@gmail.com> Apr 08 12:23PM +0530 ^ >> >> Thank you...........................Its really a life saving help for the >> needy people. >> >> Thank you once again. >> >> >> >> more... >> >> rf1234 rf1234 <rfhyd1...@gmail.com> Apr 08 01:35PM +0530 ^ >> >> Hello Dear, >> Carry on Hard Work,Group is here to Help Needy People... >> But Only for Excel,Vba >> :) >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> Hope It Will Help >> Happy To Help >> :) >> Shyam >> >> > the learning and more... >> >> ashish koul <koul.ash...@gmail.com> Apr 08 01:47PM +0530 ^ >> >> hello sham >> >> your zip file is not woring at my place can u please send it in some other >> format >> >> more... >> >> rf1234 rf1234 <rfhyd1...@gmail.com> Apr 08 03:38PM +0530 ^ >> >> Hello Dear, >> Here is the files without zipped. >> >> >> >> >> >> >> >> >> >> >> >> Hope it Will Help >> Happy To Help >> :) >> Shyam >> >> > the learning and support from the group.Let friends and co-workers know >> > they more... >> >> "saroj.32006" <saroj.32...@gmail.com> Apr 08 05:25PM +0530 ^ >> >> Thank you...............If possible can u also help us on Finance domain >> side. Completed MBA-Finance and having 4 yrs of Exp. in the Financial >> Services & Microfinance. >> >> >> more... >> >> Topic: Plz Help me urgent >> >> Dilip Pandey <dilipan...@gmail.com> Apr 08 02:40PM +0530 ^ >> >> Hi Anil, >> >> Attached file is solved as per your requirements. Formula is also there. >> Let me know if you have any queries. >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY >> MBA-HR,B.Com(Hons),BCA more... >> >> Vikas Chouhan <vikask...@gmail.com> Apr 08 02:48PM +0530 ^ >> >> hi,, >> >> dear i have one problem......... how to copy and paste formula because >> this >> is array formula function.. >> >> > the learning and support from the group.Let friends and co-workers know >> > they more... >> >> Abhishek Jain <abhishek....@gmail.com> Apr 08 03:34PM +0530 ^ >> >> I guess you can drag it down/across. Or select the target area after >> copying >> the formula and press Ctrl+V >> >> >> more... >> >> Dilip Pandey <dilipan...@gmail.com> Apr 08 05:08PM +0530 ^ >> >> You are always welcome..!! >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY >> MBA-HR,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> >> >> more... >> >> Dilip Pandey <dilipan...@gmail.com> Apr 08 05:24PM +0530 ^ >> >> Dear Vikas, >> >> Try following options:- >> 1) Copy the formula and move the desired cell, press Enter >> 2) Select the formula and select the desired cell while pressing shift key >> (select the desired more... >> >> Topic: IMPORT FIXED WIDTH TXT FILE TO EXCEL >> >> "vivek jain" <vivek.j...@gmail.com> Apr 08 09:34AM +0530 ^ >> >> From: vivek jain [mailto:vivek.j...@gmail.com] >> Sent: Saturday, April 03, 2010 8:04 AM >> To: 'excel-macros@googlegroups.com' >> Cc: 'excel-macros+nore...@googlegroups.com' >> Subject: IMPORT FIXED WIDTH more... >> >> paulwillekens <paul.johan.willek...@gmail.com> Apr 08 02:32AM -0700 ^ >> >> Hi Vivek, >> >> No need to make a .csv >> >> Open the .txt and Excel will ask whether there is a separator or fixed >> length... Choose the latter and on the sample you move the vertical >> "separator" lines so more... >> >> rf1234 rf1234 <rfhyd1...@gmail.com> Apr 08 03:39PM +0530 ^ >> >> Hello Dear, >> Nice Article.Appriciate your team spirit. >> >> >> >> >> >> >> >> >> On Thu, Apr 8, 2010 at 3:02 PM, paulwillekens >> > HELP US GROW !! >> >> > We reach over 6,800 subscribers worldwide and receive many more... >> >> Topic: Selecting cutting combinations of fabric >> >> paulwillekens <paul.johan.willek...@gmail.com> Apr 08 01:42AM -0700 ^ >> >> Hi Hugo, >> >> Total width for the 4 first samples seems 3300mm to me, which is >> greater than 3000mm... Or do I not understand your explanation well? >> >> Please confirm and correct if necessary... >> more... >> >> Topic: Count number of times a part is out of stock without counting all >> days part is out of stock >> >> paulwillekens <paul.johan.willek...@gmail.com> Apr 08 01:19AM -0700 ^ >> >> Here it comes... >> >> Please feedback ! >> >> Kind regards, >> >> Paul Willekens >> '====================================================================== >> Sub BOcount() >> >> Dim lBO >> >> Dim nBO >> Dim nCol more... >> >> Topic: Need Help to find a date and time calculation >> >> paulwillekens <paul.johan.willek...@gmail.com> Apr 08 12:55AM -0700 ^ >> >> Here it comes... >> >> greetings >> >> Paul Willekens >> '====================================================================== >> Sub Kleuren() >> >> Dim nRow >> >> nRow = 2 >> >> While Len(Cells(nRow, 1).Value) > 0 more... >> >> Topic: how can protect the excel sheet in VBA Passward. >> >> rf1234 rf1234 <rfhyd1...@gmail.com> Apr 08 01:56PM +0530 ^ >> >> Hello Dear, >> >> Following is the Code to Protect Unprotect Excel Sheet Using VBA. >> >> >> >> more... >> >> Topic: Does anybody have games >> >> rf1234 rf1234 <rfhyd1...@gmail.com> Apr 08 10:33AM +0530 ^ >> >> Hello Dear, >> Here are some,I think you will enjoy it. >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> Hope it will Help >> Happy To Help >> :) >> Shyam >> >> > the learning and support from the group.Let friends and co-workers >> > more... >> >> ツ∂J∂Ÿ <ajay.trivand...@gmail.com> Apr 08 08:15AM +0300 ^ >> >> Hi Frndz, >> >> DEAL ???? OR NO DEAL ???? [?] >> >> >> >> >> >> >> -- >> ~ajaY~ >> more... >> >> Topic: Excel, go through Column B >> >> paulwillekens <paul.johan.willek...@gmail.com> Apr 07 11:04PM -0700 ^ >> >> Hi Shawn, >> >> Question: are cells in column B always with content, up to the last >> "used" row? >> >> In that case... see below... >> >> Kind regards, >> >> Paul Willekens >> more... >> >> Topic: How to use logical expression in find method? >> >> Liu Yunxia <thomas.yunxia....@gmail.com> Apr 07 10:57AM -0700 ^ >> >> Hello all, >> >> I'm trying to do a search in Excel for a cell that contains "Apple" or >> "Orange". How can I do that in Cells.Find method? Thanks. >> >> Liu Yunxia >> more... >> >> Dave Bonallack <davebonall...@hotmail.com> Apr 08 12:45PM +0800 ^ >> >> Hi Liu, >> >> Turn on the macro recorder, then do the search manually using Find from >> the Edit menu. >> >> When the desired cell is found, stop the macro recorder and go have a look >> at the code. >> more... >> >> rf1234 rf1234 <rfhyd1...@gmail.com> Apr 08 11:50AM +0530 ^ >> >> Hello Dear, >> I have attached to Macro >> 1.Search Special >> 2.Search & Replace >> >> >> >> >> >> >> >> >> >> >> >> Hope it Will Help >> Happy To Help >> :) >> Shyam >> >> >> >> > HELP US GROW !! >> >> > We reach over 6,800 more... >> >> Topic: : HELP >> >> rf1234 rf1234 <rfhyd1...@gmail.com> Apr 08 10:48AM +0530 ^ >> >> Hello Dear, >> I am unable to understand your problem,Is it if *SEC STS CD have any >> value* >> *Then concatenate STAT DESC value ?* >> >> ** >> >> If it is then,please let me know. >> >> >> >> >> >> more... >> >> Topic: HELP: Appending multiple sheet into one >> >> janet dickson <janetdicks...@gmail.com> Apr 07 09:00PM +0300 ^ >> >> All, >> >> Paul, all my files are in one folder and if necessary I can put master >> .xls >> in the same folder. >> >> Seema, much appreciation for your assistance. Your codes worked well, but >> more... >> >> ashish koul <koul.ash...@gmail.com> Apr 08 08:58AM +0530 ^ >> >> hi janet use this code to get the file names of all folders in the >> directory then use seema's code to append >> >> >> Public Sub ListWorkbooks() >> Dim Directory As String >> Dim FileName As String more... >> >> rf1234 rf1234 <rfhyd1...@gmail.com> Apr 08 10:16AM +0530 ^ >> >> Hello Dear >> Attached is the macro and sample xls,you can append or import, >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> Hope it Will Help >> Happy To Help >> :) >> Shyam >> >> > the learning and support from the group.Let more... >> >> Topic: Single Data Type Number Length Growing >> >> ashish koul <koul.ash...@gmail.com> Apr 07 11:26PM +0530 ^ >> >> try using this >> >> >> >> Format( result , "#,##0.000") >> >> example >> Sub a() >> >> Dim i As Integer >> i = 3.000567 >> MsgBox Format(i, "#,##0.000") >> End Sub >> >> >> >> more... >> >> ashish koul <koul.ash...@gmail.com> Apr 08 08:26AM +0530 ^ >> >> try for >> >> Range("a1").NumberFormat = "0.000" >> >> more... >> >> elit <arthurwlit...@yahoo.com> Apr 07 06:04PM -0700 ^ >> >> Try storing results or using double. >> >> Sub test() >> Dim d As Double >> Dim s As Single >> >> d = 0.004 >> Debug.Print "d", d, d + 0.1 >> s = 0.004 >> Debug.Print "s", s, s + 0.1 more... >> >> elit <arthurwlit...@yahoo.com> Apr 07 07:35PM -0700 ^ >> >> My "debugging" in a prior response was intended to show how numbers >> are displayed. Your single values may always contain some "fuzz". >> >> I believe that unless declared otherwise, values within more... >> >> Topic: Access 2007 Bible >> >> Hemant K <hemantkora...@gmail.com> Apr 07 11:45PM +0530 ^ >> >> Dear Ajinkya & Vikas >> >> Thanks for providing download link. >> >> Hegards >> Hemant >> >> >> -- >> Regards >> >> Hemant Koranne >> Check out my web site for learning excel >> http://exceltnt.blogspot.com/ >> more... >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our Facebook Group @ >> http://www.facebook.com/group.php?gid=287779555678 >> 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 >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe > > > > -- > Nikhil > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Thanks Regards Shyam Software Engineer '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.
