Search results for query: *

Does anyone know how to get VBA macros to continue running after the computer has been locked? I have macros that I would like to run overnight but the computer must be locked in my absence. As far as I can tell, execution pauses when I lock the machine and resumes when I unlock it. Chris...

I need to know when my UserForm has gained or lost focus. I haven't found an obvious way of capturing these events. The closest things I've found are the Enter and Exit events for individual controls, but not the UserForm itself. Any ideas? Chris...

I have an Excel worksheet with a macro embedded in it (not in a module). This macro is invoked by a button on the worksheet. When I copy the worksheet, the macro and button are copied with it, as intended. Unfortunately, the button on the copied sheet points to the macro in the original...

I wish to build a table and assign event callbacks with dynamically generated arguments. In the sample code below I am trying to pass the row and column value associated with the cell that is clicked. What I really need is the values of 'row' and 'col', not the variables themselves. In the...

I have a 2010 worksheet with a group of option buttons. If I duplicate the sheet, the OBs on both sheets function as one big group (i.e. if I select a button on Sheet1, the buttons on Sheet2 are turned off and vice versa). It appears that all the buttons are scoped to the workbook rather than...

I have custom buttons linked to macros in Word 2010. I've succeeded in utilizing my own icons, however... Does anyone know how to define the tool tip text that is displayed when you hover the cursor over the button? Chris ------------------------------------------------------------- "Don't...

My goal is to create a Word table from Excel and place it on the clipboard as gracefully as possible. My first approach was to create the table without actually placing it in a document but I ended up having to build the table in an open document, then cut it to the clipboard. Is there a way...

I have a utility that I would like to run from a Perl script. The utility is run via an IT maintained alias. I can run the command directly but the path can change without warning (while the alias is constant). Unfortunately, "command" and "open" do not recognize the alias. Any suggestions...

I have a JPanel placed in a JTableHeader into which I intend to add other components. While attempting to determine mouse click locations in this panel I found that the x/y coordinates are negative (for the JPanel rectangle) and the height/width are 0/0. The JPanel displays as I expect and...

I have 2 contact lists. One for my default mailbox, and a second that is for a shared mailbox. From the Contacts window both contact lists are visible and accessible. Unfortunately, only my default contact list shows up in the 'Select Names' window that appears when selecting 'To' in an...

A typical error from the canned Excel functions is '#N/A'. I would like my function to do the same under appropriate conditions. The Excel function NA() will return this value in the worksheet. I tried return Application.WorksheetFunction.NA() but VBA doesn't seem to recognize this one...

I have some macros in an add-in file for PowerPoint 2003. I want to assign them to toolbar buttons that will be accessible whenever I open PP. Excel allows me to assign a macro to a custom button but I can't find the same option in PowerPoint. Chris...

Anybody know how to undo the actions of an Excel macro? Chris ------------------------------------------------------------- "Don't be deceived. We're all temporary employees.

Anyone know how to access & manipulate the custom format list, aka, Format/Cells/Number/Custom ? When I assign a new format to a cell, it shows up in the list, but I haven't figured out how to query or delete items in the list.

I wish to query the user for input, but use a default value if the user enters a carriage return without text. Unfortunately the program will not proceed until the user enters text. write(6,'(a,$)') 'Enter file (default: dummy.inp): ' read(5,*) inputFile if(trim(inputFile) == '')...

(Fortran 77, Windows 2000) I am trying to write to a file: open (2, FILE='outputfile') write(2,*) 'stuff' write(2,*) 'more stuff' ... write(2,*) 'yet more stuff' The first line writes correctly. The following lines do nothing and I get no error or warning. I tried commenting out the first...

I am trying to interactively add/delete buttons in an open dialog box. At best, the changes do not appear until the next time the dialog is run. At worst, Excel crashes. I have tried hiding the dialog, then reshowing it ->error or crash. Any suggestions would be appreciated. (Excel 97)

How do I remove a password from a VBA macro? I know the password. I just want to get rid of it.

I am using a Function to calculate a variety of parameters from a set of data in a spreadsheet. I know I can pass a single value back to the calling cell through the return value. Is it possible to send additional values back to other cells? I tried passing cells in as arguments, but I have...