Ok, I confess, I have no idea how to use VB code!

[Mhowells]

Dear all,

Alright, I have to confess it. I have no idea how to add VB script to a workbook. Everyone talks about it as if it’s a given, but I can’t make heads not tails of the help files on this site.

I have been given a slab of code with the instruction that running it will potentially shrink the size of the workbook file. I have opened up the editor, inserted the aforementioned code into the workbook script window (or what I assume is the workbook script window) and the only change I have noticed is that the file has become larger.

Can anyone either A.) explain what I am doing wrong and tell me how to get this thing to work or B.) point me towards a help site that explains the process in fairly simple terms.

Best,
Max

 

[patrickmuldoon99]

Press Alt F11, then goto Insert--> Module within the VBA window.

Paste any code that you have been given - it should begin with 'Sub' and end with End Sub. The Sub will have the name of the macro written after it, eg: Sub MyMacro

Once you have got the code in there, close down the VBA window.

Then in excel goto Tools --> Macros --> and select the name from the box that appears that matches the name of your Sub.

Clicking Run will then execute the macro, and you should see the results afterwards in terms of reduction of size of your workbook.

Hope this helps, feel free to post if this is not clear.