xlsb

Hi, I Am kind of new with VBA code. I recently created a form that will populate the data also with a search function. Anyway, I am using ".xlsb" format. Unfortunately, the search is not working where the data did not appear in the 2nd list box. Your guidance is very much appreciated. I have...

I've gone and donked up my XLSB file somehow. i can access the workbook itself but i can not save it, nor can i access the VBA editor to fix whatever vba code is causing this in the first place. should i just delete it? I don't want to delete it. I don't have a current backup of it i do not...

Hello all, i have a small xlsb file- 1.3 Mb that works just fine until i try to save it- then it blocks for about 5 minutes and i dont understand why. Can u help me with some advices? Thank you!

XLA used to be just the macro and no worksheets, but I cannot find a way to save XLSB without any Worksheets i.e. just the macro?

I have an encrypted xlsb file that I would like to allow file properties to be visible when the file is closed. My IT department would like to use the "Comments" value to store a value that can be read by other systems without opening the file. I tried running the code shown below which I...

Ive been using XLSM for ages but just found anything works the same for me in XLSB format at nearly half the filesize. Does XLSB have any cons? I've read up on it but a lot of the info is old. I read with XLSB, if file becomes corrupt its harder to fix.

Hi I have a large (>20mb) Excel file (xlsb) that opens and saves reasonably quickly, but takes up to a minute to close (even without saving) if there are other (non-linked) workbooks open at the same time. If no other workbooks are open, it closes almost instantly. Has anyone ever experienced...

Hello, I use multiple systems in my office, some of them have 2007, some have 2010, some with 2013 and one with 2016 Excel. I tried to find the Developer tab in all but i could find in 2010 and 2016 only. Second, I could find personal. xlsb file in 2016 only not in any other version. Could...

I have many Excel reports that generate weekly. Those files have a macro in them. I want to use a macro from my personal macro workbook to disable the original macro within the weekly report. So far all I can find: 1. Disabling all macros(but I still need other macros from my personal...

When I have a particularly massive project on a shared drive which needs to run faster and more efficiently on lower quality machines at my company's various branches, I usually save the file in XLSB format to share, because this reduces the the file size, so it can download or be sent via email...

Fortunately, I had already exported the modules to BAS files and zipped them.... just in case I am completely baffled by this.

I have a large macro enabled file I saved as a XLSB to reduce size and opening time. Now however, if it is not the first excel file open, I get a Runtime Error '1004' when my macro events run. However, when it is the first file open, the macro events perform perfectly. Hopefully someone has...

Hello all, I need help with this build :confused:. Basically I want to be able to create a path within the code to search this folder for excel files with Xlsx/Xlsm/Xls, open, save as, same name, but new extension. In this case I am converting older files to Xlsb in order to save space...

Facing problem with XLSB format when working with Excel 2013 and sharing it with others. The original file was created in Excel 2007. The file works normally with Excel 2013, but when I share it with other Excel 2007 users, it gives the following errors: When the user recovers the document...

Ok. I am new to this board but have been playing with VBA for a couple of years. A workbook I have developed over a year now randomly decides to crash. Sometimes it fails to find an object, like a userform, that absolutely exists! On restart excel usually finds unreadable data in the xlsb file...

Hello All, I have created a little bit of code that opens, calculates and resaves a few reports. These newly calculated wbs are then saved to a communial network drive. as .xlsb. All easy up to now, the machine i was using to do this, was on 2003. I am using 2007 to create all macros. I...

Hi! Using Excel 2007. I work with XLSB to optimize file sizes. I have a huge data table (file size 16 MB). I put it into a file with some analysis (some pivot tables without saving data, some formula driven tables). File size went up by less than 1 MB. Great. Then I did some formula changes...