RE: Best way to determine file size from VFP9SP2 app using Excel automation
On 2016-10-20 12:32, Michael Glassman wrote: Why not just use adir()? = adir(a, "automation.xlsx") ? a[1, 2] Mike Yep...just posted that exactly and then saw this post! Thanks! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/d964316e7d4eba94bef27d0135be3...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Best way to determine file size from VFP9SP2 app using Excel automation
On 2016-10-20 12:25, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: My VFP9SP2 app creates an Excel file via automation. I want to echo back to the originating form the filename and filesize created. I checked out the FSIZE command but wondered if there was a better way to determine the outputted file size? These files are being created on a network drive, most likely (unless the user chooses a local drive). WSH (Windows Scripting Host) comes to mind (but not sure if that's locked down). tia, --Mike Looking at Ted's ADIR logic in another thread and testing it herethat will work if I simply give the full path+filename for the file created!!! :-) ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/2a1ced716f5e81763d6d00cc4a22f...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Best way to determine file size from VFP9SP2 app using Excel automation
Why not just use adir()? = adir(a, "automation.xlsx") ? a[1, 2] Mike -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Thursday, October 20, 2016 10:26 AM To: profoxt...@leafe.com Subject: Best way to determine file size from VFP9SP2 app using Excel automation My VFP9SP2 app creates an Excel file via automation. I want to echo back to the originating form the filename and filesize created. I checked out the FSIZE command but wondered if there was a better way to determine the outputted file size? These files are being created on a network drive, most likely (unless the user chooses a local drive). WSH (Windows Scripting Host) comes to mind (but not sure if that's locked down). tia, --Mike [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/05a001d22aef$7f0092a0$7d01b7e0$@PioneerDrama.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.