That has to be what is happening b/c once it hits EOF in my file loop, it is still looping through an extra time and causing the script to stop. I have to break it manually and then force the d. Report and d.close_ to happen. I will try your approach.
Thanks, Reese Reese E. Walker Lead Financial Systems Analyst Phoebe Putney Memorial Hospital Phone: (229) 312-4259 Email: [email protected] <mailto:[email protected]> From: [email protected] [mailto:[email protected]] Sent: Wednesday, April 28, 2010 1:59 PM To: [email protected] Subject: RE: [talkbws] EOF Greetings, You working with Excel by any chance? The below is correct. Excel however will sometimes report EOF a record too late. I always with Excel do: If D("AlwaysPopulatedField")="" then Regards, Thom From: [email protected] [mailto:[email protected]] Sent: Wednesday, April 28, 2010 1:54 PM To: Talk Subject: [talkbws] EOF HI, Does anyone know how to write an if statement for EOF? If D.EOF_ Then... doesn't seem to be working... this is not for a rules script, but for a web connect scripts. Thanks, Reese Reese E. Walker Lead Financial Systems Analyst Phoebe Putney Memorial Hospital Phone: (229) 312-4259 Email: [email protected] --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk .aspx ________________________________ Disclaimer: The HIPAA Final Privacy Rule requires covered entities to safeguard certain Protected Health Information (PHI) related to a person's healthcare. Information being faxed to you may include PHI after appropriate authorization from the patient or under circumstances that do not require patient authorization. You, the recipient, are obligated to maintain PHI in a safe and secure manner. You may not re-disclose without additional patient consent or as required by law. Unauthorized re-disclosure or failure to safeguard PHI could subject you to penalties described in federal (HIPAA) and state law. If you the reader of this message are not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, please notify us immediately and destroy the related message. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk .aspx --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk .aspx --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
