Converting xlsx to xlsb

[LAVA2]

Hello all,

I recently discovered the benefits to converting Excel documents to XLSB (binary), mostly the cutting almost in half of file sizes.

I would like to apply this to some of my older files, but don't want to sit around resaving these documents.

That macro should be able to search through the whole C:\ drive find only the XLSX files open it and save it in .xlsb file format in the same folder with the same name by also retaining the original .xlsx file.


As always any direction on this would be great.

Thank you in advance!

Regards

[Kyle123]

Your post does not comply with Rule 3 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Please make sure to include the full link, so that other members will be permitted to continue helping you

Note that if you have fewer than 10 posts, you may need to type the link, or past it in pieces (or ask a mod to do that for you)

[dotchiejack]

See attached.
Select a folder that you want to save the XLSX As XLSB and push the button.
The macro makes a folder Converted and saves the XLSX as XLSB in this folder

[LAVA2]

dotchiejack that workbook doesnt do anything at all

[Kyle123]

LAVA2 Please update the thread with where you have also posted this question:

Your post does not comply with Rule 6 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

All participants:
Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.

[Kyle123]

Yes, it is my job as Guru

[dotchiejack]

Yes, it is my job as Guru

Where can I find the rule about this?

[Pepe Le Mokko]

@dotchie
IMO there is no need to make rules for who may, or may not post messages pertaining to the "housekeeping" of the forum.
This decision has been made by Admins/Mods and if what Kyle did was not authorized ( which is NOT the case) action would have been taken

Bottom line is that OP did not comply as requested and by cross posting without links members working for free on their spare time might be wasting their time and energy

OTOH having 180+ posts you MUST be aware of our rules about cross posting. If you are not, please refresh your memory.
I will soft-delete your post #6 and wait for OP to comply.

[dotchiejack]

@plm,I am aware of your rules about cross posting,I don't like it either, but when I see a crossposting i post also the link,what I think is important.
And sorry, posting messages pertaining to the "housekeeping should be regulated and clear.In a Dutch forum where I am helper for years ,we had problems with will be moderators, and because of that, I reacted this way.
(normally I only listen to moderators and administrators)

[AliGW]

The reason that Experts and Gurus are able to post these messages is because they have access to canned messages because of their elevated status. It is not their job to issue these messages, however it is perfectly acceptable for them to do so if they wish to where a housekeeping issue is perceived. If you wish to question anything like this, the correct way to do so is to PM a moderator or administrator to seek clarification.

As has already been mentioned, we will deal with anyone behaving inappropriately: this is not the case here, however. I hope this helps to explain what you might have perceived as an anomaly.

[dotchiejack]

@AliGW,why am I not surprised to see a message from you here.
However, the question remains, where can I find this in the rules

they gain access to them because of their elevated status

[Kyle123]

Here:https://www.excelforum.com/the-water...n-ef-guru.html

Specifically:
As a guru you are expected to follow all publicized forum rules, and endorse those rules within the threads you participate.

[Pepe Le Mokko]

Hope that ends this pointless discussion...

[AliGW]

@AliGW,why am I not surprised to see a message from you here.
However, the question remains, where can I find this in the rules

I do not know what you mean to imply by your question. I am a moderator here - I may comment wherever I feel some clarification is required.

There is no written rule about who has access to the canned messages and, because of that, may use them. As I said, if you are in doubt, rather than violating a rule, check with a moderator first.

It may be that we need to add this to the forum guidelines, however as it is the only time I recall it being questioned, I am not sure it is really necessary.

[dotchiejack]

I agree

Hope that ends this discussion

I didn't say

pointless

[LAVA2]

that workbook dosent work can you please post a working workbook that workbook also messeup my active x control setting and i cant fix it yet

[Pepe Le Mokko]

Please read and comply with post #2. As long as you have not no answers will be offered

All participants:
Please do not post a reply in a thread where a moderator/guru has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.

[LAVA2]

it is already done Pepe Le Mokko

[Pepe Le Mokko]

Which post please?

[FDibbins]

@plm,I am aware of your rules about cross posting,I don't like it either, but when I see a crossposting i post also the link,what I think is important.
And sorry, posting messages pertaining to the "housekeeping should be regulated and clear.In a Dutch forum where I am helper for years ,we had problems with will be moderators, and because of that, I reacted this way.
(normally I only listen to moderators and administrators)

Each forum has it's on "flavor" with regards to it's rules, and how they are enforced. Some forums are very strict, others are very lenient. We tend to be more middle of the road.

On this forum, senior members (including experts and gurus) assist mods and admin in maintaining order and ensuring rules are adhered to - this may not be the case on other forums, that is their prerogative, just as it is ours.

While we do value input from members in how we run this forum, that type of discussion should be conducted either through a PM to mods/admin, or even by starting a thread in the water cooler, to discuss your concerns. I can tell you right off though, that "I only listen to moderators and administrators" will not go down too well here

We have recently updated our rules, to make them shorter and easier to read. We will be adding more detailed explanations to them soon, and you comment will be taken into consideration when we get to that part f things.

I hope this clears things up for this, and the discussion can get back to assisting the OP - who STILL needs to provide a link for the x-posting.

[FDibbins]

it is already done Pepe Le Mokko

I see no link posted to your x-post. I have also been informed of other instances where you have x-posted, and also not provided the necessary link, when requested to do so.

Our rules are fairly simple, but we expect them to be adhered to. If you cannot comply with this simple request, then perhaps removing your privileges on this forum for a few weeks would help you see what is required of you?