SaveAs "Cancel" Error

Hi Everyone,

I have the following code I cobbled together from a few other scripts I use often. It does everything I want it to do with one exception.

Basic Function:
1. Ask if user wants to save their daily and clear the template
2. Pull name and date from cells C3 & J3 and format a specific way.
3. Open SaveAs dialog with formatted name
4. After user Saves clear content and date and save base template without 'overwrite' dialog.

Here is the snag I've found:

If they hit "Cancel" on step 3 instead of hitting save, the script continues with clearing the data etc.

What I want to happen if they cancel at step 3, is for the sub to be exited so none of the data is lost until they are ready to try saving again.

I attempted to add this code:

Please Login or Register  to view this content.

But all that happens is the file is saved as "FALSE" if the user hits Cancel.

Is there a solution to this or do I just have to instruct users not to hit Cancel and hope for the best?

I apologize in advance that I have to post an image of the code, everytime I hit post I'm getting a SQL Injection Block error from my county's web security.

Full Code:
Capture.JPG

Originally Posted by liquidmettle

... everytime I hit post I'm getting a SQL Injection Block error from my county's web security ...

Save it in the text file (with ".txt" extension) and insert it as an attachment.

Hi 6StringJazzer,

I work for a county government entity, so apparently when certain code looks malicious the web security flags it. This is only the second time I've seen such a warning for all the times I've posted while at work, so something in my code made it think it was possibly malicious SQL code.

Adding

Please Login or Register  to view this content.

Right before

Please Login or Register  to view this content.

Did the trick!

Thank you so much for your very quick reply!

Porucha,

That will be my future approach if this happens again (and makes much more sense!).

Glad to hear it worked.

Originally Posted by liquidmettle

I work for a county government entity, so apparently when certain code looks malicious the web security flags it. This is only the second time I've seen such a warning for all the times I've posted while at work, so something in my code made it think it was possibly malicious SQL code.

Oh, I see, the county is your employer. I am surprised they check outgoing pages. Usually checks for SQL injection are done as a defensive means for incoming content. In fact the Excel Forum has a screen for that by a third party called Securi. (Unfortunately sometimes it is too aggressive and flags VBA code as being HTML injection.)

Actually I just assumed it was on my end, it was a Securi prompt so maybe it was Excel Forum's security.

Will look into those, cheers!