Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Recorder
Greetings,
I love the excel macro recorder for recording keystrokes inside of excel. the question: Is there anyway of recording keystroke going out of excel into other programs? Any advice is appreciated. -Minitman |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Recorder
Not that I'm aware of. What did you have in mind?
"Minitman" wrote: Greetings, I love the excel macro recorder for recording keystrokes inside of excel. the question: Is there anyway of recording keystroke going out of excel into other programs? Any advice is appreciated. -Minitman |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Recorder
do search on 'keyboard macros'. there are many programs like
www.workspacemacro.com "Minitman" wrote in message ... | Greetings, | | I love the excel macro recorder for recording keystrokes inside of | excel. | | | the question: Is there anyway of recording keystroke going out of | excel into other programs? | | Any advice is appreciated. | | -Minitman |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Recorder
Hey Barb,
Thanks for the reply I have 2 workbooks. The first is for invoice creation and storage. You can fill out an invoice form by double clicking on any invoice number. The 2nd workbook is the invoice form which is populated by all of the information about the invoice number you double clicked on in the first workbook. This is working, as is the print subroutine. The problem is when I try to close the form workbook, I sometimes get am I/O device error and then it closes leaving the invoice creator open but damaged and it very quickly crashes!!! Here is the code I have on the "Close" button: Workbooks("Print Invoice Form.xls").Close SaveChanges:=False It works fine, sometimes. Since it is only a form, I have no need to save any information. I was trying to record a macro of closing this workbook to see how vba handles this task. Any ideas as to how to close this workbook using vba without the I/O device error? Any assistance is appreciated. -Minitman On Wed, 22 Apr 2009 07:01:03 -0700, Barb Reinhardt wrote: Not that I'm aware of. What did you have in mind? "Minitman" wrote: Greetings, I love the excel macro recorder for recording keystrokes inside of excel. the question: Is there anyway of recording keystroke going out of excel into other programs? Any advice is appreciated. -Minitman |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fix Device I/O Error Was: Macro Recorder
My apologies, it is not a macro recorder that I need, I thought I
could use something like a macro recorder to show what the problem is, I was mistaken. I am trying to track down a "Device I/O Error". It occurs when I attempt to close one workbook to return to the other open workbook. It doesn't happen every time, just enough times to be really annoying. Every time that it does happen, the Excel program crashes and all recent data is lost. Another strange thing seems to be happening, before Excel crashes, I can go into Visual Basic Editor and still see the workbook that I closed. But when I return to the spreadsheet view and look into the window menu choice, that same workbook is NOT present(?). I am at a loss as to how to proceed!!! Any one have any ideas or thoughts as to the direction I need to look? Any help is appreciated. -Minitman On Wed, 22 Apr 2009 12:32:12 -0400, "Homey" <none wrote: do search on 'keyboard macros'. there are many programs like www.workspacemacro.com "Minitman" wrote in message .. . | Greetings, | | I love the excel macro recorder for recording keystrokes inside of | excel. | | | the question: Is there anyway of recording keystroke going out of | excel into other programs? | | Any advice is appreciated. | | -Minitman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
MACRO RECORDER | Excel Programming | |||
Help with Macro Recorder Please | Excel Programming | |||
Help with Macro Recorder Please | Excel Programming |