Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Sure Francois-Marie.