opening and amending an excel spreadsheet from filePro

[Christopher Yerry]

There are so many posts on this I can't find the original request. But I know I read it. So here is my 2 cents. The problem is the question is posed backwards.

You can send a command line from excel to filePro in VBA, you cannot access excel from filepro easily. Microsoft makes the library accessable but filepro is not an object oriented language 

Shell "dfMaint - ......  > MyCommaDeleimetedFile.Txt"

create a VBA/excel macro to open the file and crate spreadsheets, titles, columns, dynamic cell functions etc ...
send multiple report data to the text file, then execute an excel  session, open the macro and run it, you can even be fancy and have it execute a query you created in filepro from a cell on the spreadsheet.
if written properly you will have multiple saved and named spreadheets complete with eerything in the correct columns nice titles etc.

if you don't know vba i.e. vb6 with office objects embedded you can get someone else to do it maybe 4 - 5 hour job including debugging and some fancy command line stuff.

 
Christopher Yerry
CMYerry&Sons
227 Pine ST
Hudson, WI 54016

715 690 7192
715 410 4904


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20100423/6fe0b0c8/attachment.html