.xlsb

I am having an issue with my save copy on close VBA code. I am wanting to save a OneDrive shared file (which is a .xlsb file type) upon closing the file to a network drive, but am wanting to save it as a .xlsx file, not .xlsb file type. If I use this code, the file will save, but I get an...

Hello, Is this possible through a macro? Many thanks.

I have a complex workbook with a lot of macros. Yesterday, I noticed the file size shrank by 15% when I switched from .XLSM to .XLSB. All the macros seem to work - though command buttons seem to flash strangely at times. The performance speed is about the same (less volatility in macro speed...

So we finally got Excel 10 rolled out and find that all files with macros are automatically disabled. Except for a .xlsb file that contains copies of macros I had stored in my Personal.xls macro workbook. When I open the .xlsb file I get the option to Enable Macros. However, if I take a .xlsm...

Hi Friends, I have a .csv file. Due to some requirements I added 4 new columns with each having different formula applied to it. Now the actual problem starts. After making this change I want to save this .csv file in .xlsb format as size of this .csv file is approx. 1.7GB. After saving , the...

Hello, Could you pelase help me? I have .xlsb calculation file that I need to uplaod to SharePoint monthly. I have search for some codes on internert but at moment any of tem worked for me. Do you know any VBA code whihc I could run from Excel to upload .xlsb file to sharePoint?