macro hide excel tab and save as excel file with office 2013

[fcottais]

Hello,

I have a problem with a QV macro to hide a tab in an excel file and save it under a folder under Office 2013.
Knowing that the macro worked well under office 2010.

Here are the syntax:

for the save as :

workbookDest_0.SaveAs(outputFilename), accessMode=xlShared 

and for hiding a tab:

 workbookDest_0.Worksheets(2).Visible = xlSheetHidden

Thank you for your help.

[tamilarasu]

Hi Francosis-Marie,

The above syntax is working fine in Excel 2016. Could you please share some sample file that demonstrates the problem. It would be helpful for us to test and provide solution.

[fcottais]

Hi Tamil,

I'm sorry for the delay, I thank you for your answer. I tested the syntax on office 2016 but the result is the same, on the other hand on office 2010 it works well.

I will prepare a sample and i will send you

Thank you.

[tamilarasu]

Sure Francois-Marie.