Strings Not Holding There Values.....

[JonesZoid]

Hi All,
I have the following code - which i 'Borrowed'.... The problem i have is that the strings don't seem to be holding there values once they get to the If IsEmpty part. So when the code is ran - no directories are made and nor is the file saved.....

Please Login or Register  to view this content.

[watersev]

hi JonesZoid, those two lines:

Please Login or Register  to view this content.

check if your string variables: strDirname, strFilename have any value. If they do not the code quits. So one of them or both are empty, check your file.

[JonesZoid]

They are both "Empty".
But

Please Login or Register  to view this content.

Are showing the values correctly....

CONFUSED.....

---------- Post added at 04:21 PM ---------- Previous post was at 04:20 PM ----------

They are both "Empty".
But

Please Login or Register  to view this content.

Are showing the values correctly....

CONFUSED.....

[yay_excel]

Don't test if the strings are empty using IsEmpty.

Please Login or Register  to view this content.

[JonesZoid]

They still show empty - and so does the code following on.