If you want to run your own macros without lowering the default macro security settings, you'll need to sign them with a digital certificate.

Signing your own macros with SelfCert.exe is a great description how to create your own certificate and sign your macros with it. And everything you'll need for this already comes with Microsoft Office.

So you have an Excel sheet with data on your Windows computer, and an app on your Android phone that can import csv files. You want to export your Excel data to a csv file that you can send to the Android device in order to import it in your app.

( Read more... )

Apparently, I've never before tried to enter a slash in an Excel sheet until now ( Read more... )

Sometimes you just want to read in a complete text file from your PC without muddling through all the records (i.e. text lines) one by one. When you open a text file in binary mode, such things like EOL won't get special attention and you can read in the text as one big chunk.

( Code for function that reads in a text file )

Long time no post...
And this post has nothing to do with VBA either, but I'd like to point out two incredibly useful Excel tutorials by
( Read more... )

Ok, Excel probably isn't the first thing that comes to mind when needing to deal with web pages. But sometimes it's necessary to access them from your Excel Application (or Word or any other MS Office Application). And it's easier than you probably think.

( Read More... )

Excel uses collections of objects a lot, and sooner or later you'll be in the need of checking if a certain object exists in a collection. For example, to check if a workbook was already opened, check if it's in the collection of open workbooks (Application.Workbooks), to check if a certain worksheet exists, check if it's in the collection of ( Read more... )

You want individual buttons? Using the formatting options for CommandButtons will get you only so far. You can change the background color, the font, and you can even put a picture on the button, but the button will always be rectangular ( Read more... )

Imagine you have a long list in your excel sheet and want to find certain entries. Especially if the list gets bigger, it'd be nice to just tell Excel what you're looking for, and have Excel automatically find it. It's faster and more accurately than searching yourself.

( Excel Search - not the ultimate solution )

To create random numbers in VBA, there's the function Rnd. It returns a random number between 0 and <1.

( Randomly select entries from a list )