Programming
in [Excel]
|
Page numbering Hi, I want to have the "page n of nn pages" to be represented in a specific cell (not using the header functions). Is it possible to do so? Thanks a lot in advance ... 16 May 2010 16:50
Cracking VBAProject Password Dear Programming Gurus Is it possible to crack a VBAProject password? If yes, are there any add-in tools that do so? Cheers Lacty ... 16 May 2010 08:06
Get AutoCorrect Options with VBA Is there a way to "call" the AutoCorrect Dialog box programatically in Excel 2007? This would be the same as selecting the Office Button, Excel Options, Proofing, AutoCorrect Options. I tried to record those steps but that doesn't work. Thanks. ... 16 May 2010 16:50
X = SHELL Hi all is there any difference between this.. Shell ("R:\provaclick.exe") and this .. X = Shell ("R:\provaclick.exe") ...? tx ! ... 18 May 2010 09:16
E#xcel 2007 problem Hello, Most of my saved VBA codes disappeared. When one clicks on MS Excel a blank sheet with cells appears- as it should. When one clicks on Developer, Visual basic the VBE screen appears, with a short program (that I entered some time ago) Sub amacro() End sub The top of the screen is troubling: Micr... 15 May 2010 22:27
Calling Macro Hi All, I have macro like this sub unique() '''''''' '''''''' Counter_item = 0 For Each Item In nodups counter_item = counter_item + 1 bic_var = Item Call Ps_Match Next Item end sub I have another macro Sub Ps_Match() ''''' ''''' If counter_item <= 1 Then call another_macro() end if en... 15 May 2010 19:11
Call Paste function with Undo Is there any way to call the Paste function using a macro code and with the undo capability still intact. Everything I have tried the undo is not available after the Paste. Thank you, Steven ... 15 May 2010 13:44
Insert a custom function in a cell by runnig a sub or through You are very welcome. Thanks for the feedback! -- Gary''s Student - gsnu201003 "Subodh" wrote: On May 15, 5:11 pm, Gary''s Student <GarysStud...(a)discussions.microsoft.com> wrote: An interesting request! This little macro enters the function in the active cell. It then uses SendKeys... 15 May 2010 12:38
Insert a custom function in a cell by runnig a sub or through a ma An interesting request! This little macro enters the function in the active cell. It then uses SendKeys to enter Edit Mode and move the cursor betweeen the parens: Sub FormulaStarter() Dim r As Range Set r = ActiveCell r.Formula = "=mysub()" Application.SendKeys "{F2}" Application.SendKeys "{LEFT}" DoEve... 15 May 2010 10:26
Changes to working code I have some code that gets data from an Excel 2003 spreadsheet to populate a listbox in a userform: Dim db As DAO.Database Dim rs As DAO.Recordset Set db = OpenDatabase("E:\My Documents\Excel Files\DemoSpreadsheet.xls", False, False, "Excel 8.0") Set rs = db.OpenRecordset("SELECT * FROM `mySSRange`") While... 16 May 2010 04:53 |