opening and amending an excel spreadsheet from filePro

Dennis Malen dmalen at malen.com
Fri Apr 23 10:46:24 PDT 2010


I could definitely use that.

Dennis Malen
516.479.5912
----- Original Message ----- 
From: "Richard Hane" <yoresoft at sbcglobal.net>
To: "Bruce Easton" <bruce at stn.com>; <filepro-list at lists.celestial.com>
Cc: "Rick Hane" <rhane at deluxestitcher.com>
Sent: Friday, April 23, 2010 11:36 AM
Subject: Re: opening and amending an excel spreadsheet from filePro


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!)

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.

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.

Hoping I am wrong,
Rick Hane
Controller
Deluxe Stitcher Company Inc
www.deluxestitcher.com





________________________________
From: Bruce Easton <bruce at stn.com>
To: filepro-list at lists.celestial.com
Sent: Fri, April 23, 2010 9:30:18 AM
Subject: Re: opening and amending an excel spreadsheet from filePro

On 4/23/10 9:28 AM, Fairlight wrote:
> When asked his whereabouts on Thu, Apr 22, 2010 at 02:25:37PM -0700,
> Bill Campbell took the fifth, drank it, and then slurred:
>
>> Macros can do all sorts of things. [..]
>>
> [..] My boss gave me the wrong formula for a cell. [..]
>
> So we had everything all done, the boss (the Exec VP, no less) calls me up
> -from the show-, and tells me the books are all wrong.
[..]
> Self-modifying code can be fun. Dangerous if done
> improperly, but beneficial when done correctly.
>
> [..]
>
> mark->
>
I've done several interface with Excel for regular use, some only in a
one-way direction and others where a return Excel doc was required.
Even with a perfectly designed macro other factors creep in to mess you
up: inconsistent formatting of source document from 3rd party; change
of format from 3rd party without notification; change of edits on
individual fields without notification; change of pick-up/drop-off
locations; changes from a VAN, etc.

I've spent more time writing scanning code to pre-scan incoming data
(and write warning/failure-type exception output from it) to prevent
data disasters from happening than writing macros. Dennis did say 3rd
party was involved, so I might look at what he's doing now and suggest
more disaster-prevention code, if not already there, prior to any
further automation.


Bruce

Bruce Easton
STN, Inc.


_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://mailman.celestial.com/pipermail/filepro-list/attachments/20100423/1b48cfcb/attachment.html
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list 



More information about the Filepro-list mailing list