<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><DIV>I too was one who use to write many apps (and macros) in Lotus 123. I even had our accounting firms compilation program appear in Lotus magazine. (I know you're happy for me!)</DIV>
<DIV> </DIV>
<DIV>So here's one for all you 'old' Lotus macro writers. In Lotus was the ability to save a macro as autoexec or \0. This would automatically execute immediately after the file was loaded. Does anyone know that respective commands in Excel to do the same thing.</DIV>
<DIV> </DIV>
<DIV>It would be nice to have a bat file call an Excel file, have it load, execute a macro, do all it's work, then save and exit. All of this could and was done with Lotus.</DIV>
<DIV> </DIV>
<DIV>Hoping I am wrong,</DIV>
<DIV>Rick Hane</DIV>
<DIV>Controller</DIV>
<DIV>Deluxe Stitcher Company Inc</DIV>
<DIV><A href="http://www.deluxestitcher.com">www.deluxestitcher.com</A></DIV>
<DIV><BR> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><BR>
<DIV style="FONT-SIZE: 13px; FONT-FAMILY: arial, helvetica, sans-serif"><FONT face=Tahoma size=2>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Bruce Easton <bruce@stn.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> filepro-list@lists.celestial.com<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Fri, April 23, 2010 9:30:18 AM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: opening and amending an excel spreadsheet from filePro<BR></FONT><BR>On 4/23/10 9:28 AM, Fairlight wrote:<BR>> When asked his whereabouts on Thu, Apr 22, 2010 at 02:25:37PM -0700,<BR>> Bill Campbell took the fifth, drank it, and then slurred:<BR>> <BR>>> Macros can do all sorts of things. [..]<BR>>> <BR>> [..] My boss gave me the wrong formula for a cell. [..]<BR>><BR>> So we had everything all done, the boss (the Exec VP, no less) calls me up<BR>> -from the show-, and tells me the books are all wrong.<BR>[..]<BR>> Self-modifying code can be fun.
Dangerous if done<BR>> improperly, but beneficial when done correctly.<BR>><BR>> [..]<BR>><BR>> mark-><BR>> <BR>I've done several interface with Excel for regular use, some only in a <BR>one-way direction and others where a return Excel doc was required. <BR>Even with a perfectly designed macro other factors creep in to mess you <BR>up: inconsistent formatting of source document from 3rd party; change <BR>of format from 3rd party without notification; change of edits on <BR>individual fields without notification; change of pick-up/drop-off <BR>locations; changes from a VAN, etc.<BR><BR>I've spent more time writing scanning code to pre-scan incoming data <BR>(and write warning/failure-type exception output from it) to prevent <BR>data disasters from happening than writing macros. Dennis did say 3rd <BR>party was involved, so I might look at what he's doing now and suggest <BR>more
disaster-prevention code, if not already there, prior to any <BR>further automation.<BR><BR><BR>Bruce<BR><BR>Bruce Easton<BR>STN, Inc.<BR><BR><BR>_______________________________________________<BR>Filepro-list mailing list<BR><A href="mailto:Filepro-list@lists.celestial.com" ymailto="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</A><BR>http://mailman.celestial.com/mailman/listinfo/filepro-list<BR></DIV></DIV></div></body></html>