Macro Recorder

[Minitman]

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

 

[Barb Reinhardt]

Not that I'm aware of. What did you have in mind?

 

[Homey]

do search on 'keyboard macros'. there are many programs like
www.workspacemacro.com

| 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

 

[Minitman]

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

 

[Minitman]

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