Hello Kim, >From the looks of it you shouldn't need to declare the name of the function (eg create a FileSystemObject)
where I got that from is here: http://www.techonthenet.com/excel/formulas/filelen.php it has an example on that page as well. ................................... Brian Van Grinsven Integrated Systems Specialist Medbuy Corporation mailto:[EMAIL PROTECTED] http://www.medbuy.ca T: 519.652.1688 ext. 114 F: 519.652.2788 Technical Support: ext. 199 or [EMAIL PROTECTED] Building Partnerships in Healthcare "Scaccia, Kimberly" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 19/03/2008 03:01 PM Please respond to [email protected] To <[email protected]> cc Subject RE: [Talk] File Size Do I need to declare FileLen or a file system object? I My Code looks like: If Dir("\\DRIVE\PATH\PBR_FHC_CAP\FHCPCAP*" & ".xls") <> "" Then F("FILE") = Dir("\\DRIVE\PATH\PBR_FHC_CAP\FHCPCAP*" & ".xls") If FileLen("\\DRIVE\PATH\PBR_FHC_CAP\FHCPCAP" & F(?FILE?)) = 0 Then Step = "ZEROFILE" End If Exit Sub Kim Scaccia, System Admin Recovery Reimbursement Patient Business & Financial Services Halifax Medical Center 386-226-4590 opt 1 ext 2018 From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] On Behalf Of Andrew Koehler Sent: Wednesday, March 19, 2008 2:48 PM To: [email protected] Subject: RE: [Talk] File Size You can use the FileLen If (FileLen(currFile) = 0)Then ?Do something End if Andrew Koehler ehealthclaim.net 877-881-7484 The information in this email, including attachments, may be confidential and/or privileged and may contain confidential health information. This email is intended to be reviewed only by the individual or organization named as addressee. If you have received this email in error please notify ehealthclaim.net immediately, and destroy all copies of this message and any attachments. Confidential health information is protected by state and federal law, including, but not limited to, the Health Insurance Portability and Accountability Act (HIPAA) of 1996 and related regulations. From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] On Behalf Of Scaccia, Kimberly Sent: Wednesday, March 19, 2008 2:46 PM To: [email protected] Subject: [Talk] File Size Is it possible to capture the size of a file (in bytes) in Boston to determine if the file size is zero ? do something? Kimberly Scaccia, System Admin Recovery Reimbursement Patient Business & Financial Svcs Halifax Medical Center 386-226-4590 optn 1, ext 2018 Electronic communications originating from or sent to Halifax Community Health System (HCHS) are subject to monitoring and public inspection under ยง 119.07, Florida Statutes. This message and any attachments are the property of HCHS and are intended to be received only by the individuals or entities identified in the message. If you have received this message in error, please take notice: 1) that any use, copying, printing, forwarding or distribution of this message in any form is strictly prohibited, and 2) please notify the HCHS Compliance Department at (386) 254-4278 and/or forward the message to [EMAIL PROTECTED], and please delete or destroy all copies of the message and any attachments. ********************************************************************** This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal. **********************************************************************
