Copying an Access Macro Text into Excel

[John Ortt]

I have a macro in access which I would like to copy and paste into an excel
spreadsheet.

By this I mean the design window view of the macro.

Selecting the top left corner and then going to excel and trying to paste
does not seem to work.

Pasting one line at a time does seem to work (for the description) but is
time consuming for long macros, and doesnt have all the data such as
conditions..

Does anybody else have any clever ways of getting round this please?

Thanks in Advance,

John

 

[Steve Schapel]

John

An Access macro is an entirely different creature from an Excel macro.
An Excel macro is more closely related to a VBA procedure in Access. A
bit like crabapple and pineapple. Can you please let us know some
specific examples, and what you are really trying to achieve with this?

 

[John Ortt]

Sorry Steve...

In a sense I would like to produce a screen grab of the macro design view
but to have it in text format so I can alter it.

When you are viewing the macro design and it looks like a table with the
properties box at the bottom of the page, I would like to copy the table
section at the top.

(Hope that makes sense)....I can't really think of any other way to describe
it.

Let me know if that helps atall and if not I'll try and think of a better
description.

John

 

[Steve Schapel]

John,

Ok, I think I understand what you mean now, and unfortunately I think
the answer is No, I don't know any way of achieving this.

 

[John Ortt]

John,

Ok, I think I understand what you mean now, and unfortunately I think
the answer is No, I don't know any way of achieving this.

<snip>

OK, Thanks anyway Steve