how do I create lotus type macros in excel?
90752
Hi.  Like you, I too miss the days of the Lotus macros/scripting.  Lotus macro language was far simpler to understand.  It was so intuitive.  I tried writing scripts in Excel the first few years after Microsfot conquered the office space (~1994-1998), and after hours upon hours of trying to understand its heiroglyphics in an attempt to create a macro for a repetitive task that would have taken me ~60 second to write in Lotus, I gave up and have since only been tempted into this highly cryptic world on a handful of occassions.   I have little idea still of what I am doing in teh Microsoft Excel Macro Edior.  However, I think I do at leats kmow how to bang out something to do what wish.  Try this:\n\nSub Macro1()\n    var1 = ActiveCell.Value\n    ActiveCell.Value = "'" & var1\n    ActiveCell.Offset(1, 0).Select\nEnd Sub\n\nI think it does exactly as the keystrokes you described does, except it sounds as though you may want one more "DOWN" command, i.e., "ActiveCell.Offset(1, 0).Select".\n\nHope this helps.
618409
http://www.presentersonline.com/tutorials/powerpoint/macros.shtml
550410
There are a lot of software libraries that do that:\n\nhttp://tinyurl.com/k9zah\n\nincluding some for Excel:\n\nhttp://tinyurl.com/hrda7
1105719
In Excel, functions and macros only can do this. Try the functions PROPER, UPPER and LOWER.\n\nCtrl+Shift+A is another Word keystroke for changing case, it doesn't work in Excel.\n\nCheck out:\nhttp://www.mvps.org/dmcritchie/excel/proper.htm#upper
825954
You need the following:\nOpen your file\nGo to \nTools > Macro > Visual Basic editor\nIn the left window section (Project Explorer) double click on what says "Workbook"\nPaste this in the white code area that shows\n\nPrivate Sub Workbook_Open()\nWorksheets("Main").Activate\nEnd Sub\n\nThis is a macro so you will need to enable macros every time you opened this file.\nGo to\nTools > Macro > Security\nAnd change the settings to Medium\n\nEnjoy my profile, I am the VBAXLMan
1104463
yes sort\nyou have to highlight it and\nin excel \nData --> Sort --> Assending order\n\nin word\nTable --> Sort
233468
I've uploaded a simple spreadsheet to the link below.  Anything else and you should probably find someone in the office who knows Excel.
801000
http://www.officerecovery.com/excel/\n\nTry here if the help in Excel doesn't help.\n\nRegards\n\nRob
417607
I don't know if this is exactly what you need, but it sounds like you are getting an error when you compile macros in VBA because of a bad reference.\n\nTake a look at the reference dialog box on the VBA Tools menu.  There may be something there that you need to check off.  These kinds of links sometimes get lost when you change versions of Excel.
990843
You can call it from VB6 using\nWorksheetfunction object\nthis object has all the functions in Excel\n\nenjoy\n\nXLMan
610232
Make one on a spreadsheet
708608
Here's a macro for what you want (you can replace the periods with spaces, I only put them there for appearance)\n\nSub Swap2Cells() \nIf Selection.Count <> 2 Then \n.....MsgBox "Select 2 cells only." \n.....Exit Sub \nEnd If \nSet trange = Selection \nIf trange.Areas.Count = 2 Then \n.....temp = trange.Areas(2) \n.....trange.Areas(2) = trange.Areas(1) \n.....trange.Areas(1) = temp \nElse \n.....temp = trange(1) \n.....trange(1) = trange(2) \n.....trange(2) = temp \nEnd If \nEnd Sub
986040
If you are talknig about the VBA of Excel, then\nYes\nThere is a way\nI answered this one 2 days ago\n\nIt is by using the object "WorksheetFunction"\nType\nWorksheetfunction.\nin your code and, you will see the list of available functions that you can use from VBA in XL.\nThis list will not have some big functions like OFFSET, or ADDRESS\nany way\nAbout the other solution (Putting function in your worksheet), actually, you can do the function in another worksheet and link the result to the one that you need.\nThis technique is better, just to allow your user to see what function you used for this result\n\nMail me if you need more info\n\nEnjoy my profile, I am the VBAXLMan
900055
http://www.vba-programmer.com/
919347
Try a convert tool:\n\nhttp://www.bestsoftware4download.com/software/t-free-abc-amber-lotus-1-2-3-converter-download-ufyhxitx.html
258298
Excel uses VBA (Visual Basic for Applications).  It's a subset of Visual Basic.  A good way to get started with it is to record a macro and then look at the macro's source code.
341465
Here are 3 ways...\n1. You don't need code if you just set your startup form under the TOOLS, STARTUP option.\n\n2. You can create an AutoExec macro the has an OpenForm command in it.\n\n2. If you really want to do this in a module.  Create an AutoExec command that has a RunCode statement.  The function for the RunCode would be a function you create like:\n\nOpenStartForm()\n\nIn a module you would then need:\n\nFunction OpenStartForm()\nDoCmd.OpenForm "frmMyForm"\nEnd Function