save as macro partially working

All,

First of all, this attached sheet has been worked on by a lot of different people over the years, so this version is my first an only update and hence there is a possibility I am not to blame for this :-) It's also a mix of English and Norwegian, and i apologize for this in advance.

Anyway, I use a report sheet were there are 2 types of information. This information only tells the reader if it is one of the two. The actual results and format of this is the same regardless of report type. So in the attached sheet, on the 4th tab (F-19c Væskerapport) at the top in cell B1 there is a drop down menu. First option is not applicable. If choosing the second option everything on the Save As button on the right works fine, but choosing the third option i get this error: (if protected PW=F-19)
Capture.JPG

I don't get it as the save function in the macro use the same cell for defining the filename, the drop down only changes some names and definition.

The codes for the save function are in the same sheet as the button; "F-19c Væskerapport"
File attached: F-19 a-b-c Bestillingsskjema - mikseliste - væskerapport rev6.xlsm

Any help is hugely appreciated as always

The macro creates the name of the file by combining values from several cells. When third option is selected the value in Q10 is CaCl2/CaBr2 SPECIAL BL

Obviously the forward slash is a problem when present in the file name (C:\F-19\LJ-5 - A-15 - 1.765sg - 36m3 - CaCl2/CaBr2 SPECIAL BL - MIP MB 35.xlsm).

Wow, amazing what you don't see when you get blind...
Thank you so much!

Now obviously, my next question would be; is there a way to take any "/" or "\" to be changed to "-" when saving, automatically?
Or do i have to go through all my products and change them manually?

Thanks again!

you have two options - one is to amend the formula in the cell Q9

Please Login or Register  to view this content.

Note you may have to add multiple substitute functions if you want to remove more than one type of problem char
the other approach - to write a VBA function (which you may use in the worksheet or even better -to use in your SaveAs macro) that clears large number of chars (i.e. sanitize the file name)

Something like this

Please Login or Register  to view this content.

This is the new function GetFileName and slightly changed code from the old CommandButton22_Click

If i could, i'd buy you 10 drinks! Brilliant macro, and it works like a charm!

Thank you so much!!