Error 91

[plunkettyplunk]

Hi, I am having an issue with the following piece of code.

File location has recently changed from "T:\crystal_reports\General\Oracle_Web_Trading_Reports\"
to "T:\crystal_reports\General\Oracle_Web_Trading_Reports\Open Position Client Count (Daily)"

I have updated the code accordingly, however I am now getting an error (91 Object variable or With block variable not set) when the macro gets to "wbOpen.Close False".

until the file location was changed this did not happen.

Your help is much appreciated.

thanks

Ben

Please Login or Register  to view this content.

[Marcol]

Try adding a backslash to the path name, and drop the asterix from the file extention

Please Login or Register  to view this content.

Put a break on this line

Please Login or Register  to view this content.

Check the full name in the immediate pane.

Please Login or Register  to view this content.

If it is not correct adjust as is required.

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

[plunkettyplunk]

Of course... thanks.