Another solution would be to check your record after D.Next_ and in your
DBCheck and if D("Whatever")="" just get another record.
I would also keep a count of how many consecutive "" you find and exit
after x many as you are likely at the end of the file. One of the
support guys at BWS suggested that relying on EOF in Excel can be a bit
tricky as you can sometimes have a sheet with 30 lines of real data and
64450 or so of blank data. This can create a lot of script cycles
looking for nothing!
David Gibbs
LIS Analyst
Fraserhealth________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence, Mitchell Sent: May 11, 2007 5:52 AM To: [email protected] Subject: RE: [Talk] Excel in datastation If the blank line situation is consistent, when you do your D.Next_, just do two. :-) Thank you, Mitch Lawrence Lead Applications Analyst - Advanced Report Writer General Financials Support CHRISTUS Information Management ': 361.881.3408 7: 361.888.6117 *: 361.549.8456 )AIM: a1d13 )MSN: [EMAIL PROTECTED] *: [EMAIL PROTECTED] Send a "thank you" <http://intranet.christushealth.org/spiritBuck/> to someone! ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Williams Sent: Friday, May 11, 2007 7:41 AM To: [email protected] Subject: [Talk] Excel in datastation The excel sheet I am to use for input has blank lines between every record. When I bring this into the data station every other record is blank. Is there a way to have the script remove tthe blank lines? Or will I have to have them remove the lines beforeI get the file? Thanks, Gary
<<image001.gif>>
