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
Why not just use adir()? = adir(a, "automation.xlsx") ? a[1, 2]
Mike
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com Sent: Thursday, October 20, 2016 10:26 AM To: profoxtech@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]
On 2016-10-20 12:25, mbsoftwaresolutions@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 here....that will work if I simply give the full path+filename for the file created!!!
:-)
-
mbsoftwaresolutions＠mbsoftwaresolutions.com -
Michael Glassman