Classification pop up issue when saving file

[Dani_LobP]

Hello all,

I would like to get some help in how to automatically assign the classification as internal document.

At my company we use some classification tool in excel called Secure Islands Classification, and whenever create new file it pop ups asking to set the classification, usually being internal.

My problem here is that i have some files that have lots of tabs, around 30-40 and i made a macro that splits the file, into many files, one per tab.

So basically macro will go tab by tab, and creating a file with the name of the tab and so on...

But, as you can imagine, is not as efficient if every tab pops the classification message to select internal. and is what i want to add in the code, some line that automatically selects internal and keeps going without my intervention 40 times or so..

Hope someone understands what i mean and have some idea in how to do this.

thanks in advance.

 

[CountTepes]

Can you show the code which creates the files?

 

[Dani_LobP]

this is the code

Sub SheetsToWorkbooks()
    Dim ws As Worksheet
    Application.ScreenUpdating = False
    For Each ws In ThisWorkbook.Worksheets
    ws.Copy
    ActiveWorkbook.SaveAs ThisWorkbook.Path & "\" & ws.Name
    ActiveWorkbook.Close SaveChanges:=True
    Next ws
    Application.ScreenUpdating = True
End Sub

 

[CountTepes]

I think it might be because you are not saving a file extension.

Look here.

Worksheet.Copy method (Excel)

Office VBA reference topic

docs.microsoft.com

 

[Dani_LobP]

I think it might be because you are not saving a file extension.

Look here.

Worksheet.Copy method (Excel)

Office VBA reference topic

docs.microsoft.com

As far as i see, its saving by default as .xlsx so i was fine with that.
But problem is that every new file that is created need to be classified, so for each new workbook created by macro for each tab, i get pop up... security reasons i believe. doesnt matter the extension i add i think.

 

[CountTepes]

Can you drop in a screenshot of the popup box you get, please?
Also, where are you saving the files to?

Also do you have a plugin in to handle the classification? I just spotted something on the web. Do you have this button on your toolbar?

 

[CountTepes]

If you have that button, or the Titus plugin, maybe this will help.

How to save workbook and handle TITUS (or any other document classification add-in) popup?

I'm creating a script in HP UFT 12 which performs grid data validation against a CSV file and saves the results in a Excel file with two worksheets. I'm using Excel for this because it is much more...

stackoverflow.com

 

[Dani_LobP]

If you have that button, or the Titus plugin, maybe this will help.

How to save workbook and handle TITUS (or any other document classification add-in) popup?

I'm creating a script in HP UFT 12 which performs grid data validation against a CSV file and saves the results in a Excel file with two worksheets. I'm using Excel for this because it is much more...

stackoverflow.com

Will try this thanks, cant check today so will be back on Monday and let you know

 

[Dani_LobP]

Can you drop in a screenshot of the popup box you get, please?
Also, where are you saving the files to?

Also do you have a plugin in to handle the classification? I just spotted something on the web. Do you have this button on your toolbar? View attachment 7761

i'm afraid I guess i can't share pic of pop up because of compliance/security reasons. But is just a pop up window requesting to choose 3 options of classification. if i don't choose any, it won't keep forward so file won't be saved. similar to titus i believe, but never used titus before so just guessing.

And i don't have that icon. i think its embded in excell in a way that is full time on. can't disable it.

 

[CountTepes]

If you go to File-Options on the main Excel screen and look at your Add-ins. Is there anything there, which looks like it might be causing the pop-up box? Especially in the Document Related Add-ins.


What happens if you disable events before the saveas and re-enable after?