Change "Save as" default safe to .xlsb

[navialivad]

Greetings

I have a macro that currently opens an .xlsb file, this file may be changed depending on what the user does in previous steps. I want to allow the user to save this file but would like to change the default in the save as to .xlsb since the file is 40MBs + big without this extension and only 6Mbs with it

The codes I've tried are the following:

This one just creates the save as

Please Login or Register  to view this content.

This one allows me to put an .xlsb extension but doesn't actually reduce the size of the file to what it would with the previous code selecting .xlsb

Please Login or Register  to view this content.

Any help will be appreciated

[karedog]

Hi,

Change this line :

Please Login or Register  to view this content.

to this :

Please Login or Register  to view this content.

For further information, please look at this page : link

Regards

[navialivad]

Thanks, it worked perfectly. If you don't mind, what does the 50 stand for and how can I get more info into that?

Thanks!!

[karedog]

You are welcome and thanks for the reputation point.

If you follow the link I provided in post #2, you will find all your need there.
Number 50 means it is a Excel Binary Workbook (xlsb) type, you can also use xlExcel12 constant.

The description is like this : imagine you have a .jpg file, then you rename this file to .txt file, because you change the file to .txt extension, it doesn't mean you change the file into a text file.

In your first post, you set the the filename with .xlsb extension, but you set FileFormat:=xlNormal, so the file will be save as normal Excel file (.xlsx) anyway. In short, changing the file extension doesn't change the file type automatically, you must set the FileFormat argument to do this.

Regards