Coding for Visual Basic to create Macro in Excel?
921724
Here's the command I use:\n\nNewFileName = "My_File_" & Replace (Str (Format(Now, "yyyymmddhhmmss")), " ", "")\n\nI have it formatted down to hours, minutes and seconds.  I do this so that I can save the file as often as I want and get a new file name every time.\n\nHope this helps!\n\nRegards,\nQwertyKPH @ Yahoo!
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
618409
http://www.presentersonline.com/tutorials/powerpoint/macros.shtml
534942
There are macro programs - search under 'macro' - which will allow you to do a key sequence for regular tasks.  Or you can learn VBA if you need to do it within Office applications (and for free:))
361581
Create a form with textbox named 'txtDiamond' and give it the following settings: 'MultiLine = True', 'ScrollBars = 2 - Vertical'\n\nThen copy the following code within Either Form_Load() or another subroutine in which you would like to generate the row. The following code is dynamic, and allows you to create diamons with the amount of rows being odd or even. I expect alot of points cuz i had to write this myself ;).\n\nHere it is:\n\n    Dim RowCount As Long\n    Dim Row As Long\n    Dim Stars As Long\n    Dim MiddleRow As Long\n    Dim SpaceCount As Long\n    Dim X As Long\n    \n    RowCount = 11\n    MiddleRow = Round((RowCount / 2) + 0.1, 0)\n\n    Stars = 1\n    \n    For Row = 1 To RowCount\n        If Row = 1 Then\n            txtDiamond = String((RowCount + 1) - Stars, " ")\n        Else\n            txtDiamond = txtDiamond & vbCrLf & String((RowCount + 1) - Stars, " ")\n        End If\n        For X = 1 To Stars\n            txtDiamond = txtDiamond & "*"\n            txtDiamond = txtDiamond & " "\n        Next X\n        \n        If Row < MiddleRow Then\n             Stars = Stars + 1\n        ElseIf Row = MiddleRow Then\n            If InStr(1, (RowCount / 2), ".") > 0 Then\n                'Odd\n                Stars = Stars - 1\n            End If\n        Else\n             Stars = Stars - 1\n        End If\n        \n    Next Row
1078522
Microsoft Excel VBA Programming for the Absolute Beginner\nhttp://rapidshare.de/files/22281642/mevp.rar.html
650542
I'm not an expert.... but I dont think there exist such a macro recorder in windows... but if you are good programer you can very well write a code in VB6... which will do all that for you...\nThere are many s/w available which do (most of) that for you... like system mechanic.
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.
221896
There's an easy way to do this. I've given you some very basic code.\n\nCopy and past this code into your VBA code under the same sheet as your data. (Press ALT-F11 to get to the VB editor and double click the sheet name of the tab you are working on).\n\nSub SortText()\n    LookRow = 2\n    PutRow = 2\n    txtCounter = 1\n    Do\n        txtColor = Cells(LookRow, 1)\n        If txtColor = "" Then Exit Do\n        txtSize = Cells(LookRow, 2)\n        txtRange = Cells(LookRow, 3)\n        Cells(PutRow, 5) = "Trial #" & txtCounter\n        Cells(PutRow + 1, 5) = "Color " & txtColor\n        Cells(PutRow + 2, 5) = "Size " & txtSize\n        Cells(PutRow + 3, 5) = "Range " & txtRange\n        PutRow = PutRow + 5\n        LookRow = LookRow + 1\n    Loop\nEnd Sub\n\n\nWhen you run the macro it will take the data and arrange it into the columns you wish. Be aware that it will paste the data into column E of the same page and will overwrite anything you have there, so backup your data first.\n\nYou can also assign this to a shortcut-key with Tools>Macro>Macros... You will need your security set to Medium for this to work.\n\nIf you wish the data to be saved on a seperate page, please email me at wabbitt1970 @ hotmail.com
897637
Is there a macro hidden in it somewhere, that is running every time you open it? This is _a_ possible solution...\n\nRawlyn.
897335
You can do this in two ways:\nOne: Using Macro.\nTwo: Using functions\n\nI prefer using the option Two as a start.\nNow, I need you to focus with me...\n\n- Enter your two values "Default" and "1000" in two cells (Say Y1:Y2)\n- Create a Combo Box using "Forms Toolbar", that is go to View > Toolbars > Forms\n- The toolbar will show and you can create a combo box from it.\n- Right click on that combo box and go to Properties > Control, select two cells that have your values (Default and '1000') Y1:Y2 as the Input range, select a cell to link this combo box to (Say Z1).\n- Now click ok\n- Where ever you select a value from this combo box, Z1 cell will change to 1 or 2.\n- Your A1:E50 cells need to have this function, need to be changed. I have a question here (Do these cells have a numbers (A) or coming from a formulas (B) ?)\nA) If the A1:E50 cells have all constant numbers, I prefer you choose another range to put this formula in.\nSay G1:K50, put in G1 this formula and copy and paste to the others:\n= CHOOSE( $Z$1, A1, A1/1000)\nB) If they have a formula, just change it to this formula:\n= CHOOSE( $Z$1, [your old formula], [your old formula] /1000)\ndon't forget to change the value [your old formula] to your old formula on each cell.\n\nNeed more help? or would like to see the Macro section?\nmail me here\n\nEnjoy my profile, I am VBAXLMan
421831
Is not easy, but it is not imposible... I write a lot of macros in excel and i've run in that situation several time. I learned how to crack the VBE password.\n\nIf you search the web, everybody want to sell you a prduct to do that...\n\nif this is just a one time event for you, you can send it to me, i'll crack it and re-send it to you with out the VBE password\n...
275282
If you're working with Excel, consider Visual Basic, which is the language Excel's macros are done in.  But you'll have to know it awfully awfully well.  Same if you used C++.\n\nAnd what makes you think copying that information from a site isn't illegal?
817800
Here's some instruction for a UDF (User Defined Function) to do what you need.\n\nhttp://www.ozgrid.com/VBA/HyperlinkAddress.htm
325795
I don't think its an option from the menu. Ofcourse, VBA script can be written for that to happen.
1072460
Paste this macro into VBA\n(The >s represent tabs, please replace them. Tabs are really just for aesthetics, but help in macro troubleshooting)\n\nSub Del_Mt_Rows()\nDim lastRow As Long\nDim r As Long\n>lastRow = ActiveSheet.UsedRange.Row - 1 + _\n>>ActiveSheet.UsedRange.Rows.C...\n>Application.ScreenUpdating = False\n>For r = lastRow To 1 Step -1\n>>If Application.CountA(Rows(r)) = 0 Then Rows(r).Delete\n>Next r\nEnd Sub\n\nThen just run the macro and it will remove empty rows
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