Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
X=30
DO UNTIL X=315
IF FileSize (PathX)>0 THEN
Logins:
LOAD employee,
name,
last name,
login,
logout
FROM
$(PathX)
(biff, embedded labels, table is Phaze1$);
ELSE
SET xls_exists=0;
END IF
X=X+1
LOOP
Hi,
Code seems to be fine. What does the PathX store? Is that a variable? What error do you get? A simple code with AUTOGENERATE instead of FROM works fine (loads 285 times).
Regards.
Miguel
Thank you for your answering.
'PathX' was defined before the code, and it's a variable:
PathX = 'U:\Reports\ & YEAR(Today(1)-X) & '\' & MONTH(Today(1)-X)..
I don't receive any error, all of data that suppose to be loaded with the code, doesn't appears. All fields are empty.
Do you have any idea?
Best Regards,
Tomi
Thank you for your answering.
'PathX' was defined before the code, and it's a variable:
PathX = 'U:\Reports\ & YEAR(Today(1)-X) & '\' & MONTH(Today(1)-X)..
I don't receive any error, all of data that suppose to be loaded with the code, doesn't appears. All fields are empty.
Do you have any idea?
Best Regards,
Tomi
Hi Tomi,
Did you try using instead
IF FileSize('$(PathX)') > 0 THEN
Hope that helps.
Miguel
Thank you very mach Miguel, your answer was Helpful..
It's gived me a hint what should i do..