| Author |
|
hollis
Groupie
Joined: February 09 2002
Location: United States
Online Status: Offline
Posts: 28
|
| Posted: February 13 2002 at 21:55 | IP Logged
|
|
|
This won't add any new functionality, but would make the writing of complex macros a bit easier to duplicate and share.
I have the need to take a long macro and copy it to modify it slightly for another purpose of for debugging purposes. It would be great if you had a COPY function that would allow you to copy and save a new version under a new name.
Another feature (which also could be used to accomplish the above in a 2-step process) is an Import/Export Macro function. Say I wanted to send a friend a copy of a complex macro. This is not very easy to do now. But with this feature, it would be a breeze. Just EXPORT the macro to a file, email, and he imports the file containing the macro.
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: February 14 2002 at 08:05 | IP Logged
|
|
|
Hollis,
The copy function is already there  From the macro header screen in the Explorer, just right-click on the macro you want to copy and you'll get a pop-up menu with the copy function.
You are absolutely right on the import/export. Ive been wanting to add that functionality for a while so look for it to be added shortly. As a temporary means, you can use the SQL report and Direct SQL commands for import / export. Its a pain, but will work in a pinch. To export, go to SQL report and "select * from macroheader where id = 'MACRONAME'". When the result set is returned, click on File - Export and save the rows as SQL. Do the same with the macrodetail with "select * from macrodetail where id = 'MACRONAME'". The two files can be combined and edited to put in the proper table name and remove the create table statements. You can then use the Direct SQL option to import this file. I'll start working on the import / export functionality so I can get it in the next version.
Dave.
|
| Back to Top |
|
| |
hollis
Groupie
Joined: February 09 2002
Location: United States
Online Status: Offline
Posts: 28
|
| Posted: February 14 2002 at 10:46 | IP Logged
|
|
|
Great!
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome Feature Requests
Topic: Import/Export/Copy Macros
