opening and amending an excel spreadsheet from filePro

[Chris Rendall]

In Excel you put your VBA code in the Workbook_Open event and it will run when the file is open.  If you have a macro setup you can put Run "MyMacro" in the Workbook_Open event to start the macro when the file is opened.

Chris

-----Original Message-----
From: Richard Hane [mailto:yoresoft at sbcglobal.net] 
Sent: Friday, April 23, 2010 10:37 AM
To: Bruce Easton; filepro-list at lists.celestial.com
Cc: Rick Hane
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