 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Macros / November 2004Copying an Access Macro Text into Excel
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 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?  SignatureSteve Schapel, Microsoft Access MVP > I have a macro in access which I would like to copy and paste into an excel > spreadsheet. [quoted text clipped - 13 lines] > > John 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 > John > [quoted text clipped - 23 lines] > > > > John 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. SignatureSteve Schapel, Microsoft Access MVP > Sorry Steve... > [quoted text clipped - 12 lines] > > John > 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 :) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.