Quick Trick: Copying Embedded Macros from one Property to another

re: Quick Trick: Copying Embedded Macros from one Property to another

Alan Cossey — Thu, 28 Sep 2006 20:31:24 GMT

Very clever. Thanks for pushing so much info our way.

re: Quick Trick: Copying Embedded Macros from one Property to another

unsurprisingly — Sun, 01 Oct 2006 12:28:33 GMT

Your June or July pointer to the office 2007 beta 2 test drive looked kind of interesting to check out, but here's what you get when you try to run it from win xp fully updated w/ie 6:

BROWSER OR OPERATING SYSTEM NOT COMPATIBLE

Your Browser or Operating System is not compatible with the Test Drive System. The Test Drive System supports the following:

* Windows 98, 2000 and XP
* Internet Explorer 5.5 and later

re: Quick Trick: Copying Embedded Macros from one Property to another

ThirdOfFive — Sun, 01 Oct 2006 23:10:11 GMT

Do you have Windows XP with SP2 installed? I believe the requirements mention that you need SP2.

Here are the requirements:

http://www.microsoft.com/office/preview/beta/sysreq.mspx

re: Quick Trick: Copying Embedded Macros from one Property to another

grovelli — Tue, 17 Oct 2006 00:42:34 GMT

Does the DoCmd object have a SaveText method? Because on Access VBA help I can only find Save.

re: Quick Trick: Copying Embedded Macros from one Property to another

ThirdOfFive — Tue, 17 Oct 2006 01:14:50 GMT

The DoCmd SaveAsText and LoadFromText methods are undocumented and hidden from VBA object explorers. Just type DoCmd.SaveAsText on your VBE immediate window and you will see the arguments, etc.