VBA code for changing combobox value

Hi folks,

It's been a while since I've posted something, because usually I can find what I'm looking for in exsisting threads. However, this time I guess I didn't phrase my search correctly, because I came up blank. So...here's my problem:

We collect our research data in an excel spreadsheet. Some of our data have to be sent (in a special xml format) to a national database.
The people from the database have provided us with an exporter spreadsheet which nicely translates our data to the correct xml format. However, we currently have to copy and paste our data to this spreadsheet manually. Which is of course not really a problem, but can go wrong if you have to do it several times in a row. So, I was planning to automise this through a macro.

Seems simple enough, but as a part of the process, I have to select one of three options from a combobox included in the exporter spreadsheet. Since I've never written a macro with a combobox included in it before, my first idea was to simply record the macro. However, the part where I made my selection in de combobox was nowhere to be found in de resulting macro. It went straight from my last action before the combobox to my first action after the combobox.

The question should be obvious by now: Can anybody tell my how to say in VBA : Select the combobox named cboX and set this combobox to option A, B or C ?

Oh, since I don't know if this is important or not (I think not, but who am I?): The VBA in the exporter spreadsheet is password protected and I know for certain I'm not going to get that password.

Thanks in advance
Thirsa

OK, I guess I wasn't completely clear.
I know I won't be able to change the code in the exporter spreadsheet without the password. That is why I want to create a macro in my other spreadsheet (the one containing the data) which opens the exporter spreadsheet, selects the correct option in the combobox, then pastes my data into the exporter spreadsheet and saves the exporter spreadsheet under a specific name. I know how to do everything except the combobox part.
So all the VBA code I will be making will be stored in my data-spreadsheet.
The reason I asked about the password is because I don't know if the fact that the exporter spreadsheet is password protected will be a problem for programming the "select the correct option in the combobox" part of the macro.

Hope this clarifies things. And thanks for replying.

Unfortunately, I have no idea what type of combobox it is. Is there a way to tell which is which? This one looks like what you would get with the list option in the data validation menu, but it is not included in the cell. It's a separate control on top of the cell.

The worksheet has simply been named 'data' by the makers.

Of course I can work around the problem by saving 3 blank versions of the exporter spreadsheet, one with each of the thee options selected in the combobox, and make a couple of ifs in the macro in order to open the correct one. But it would be nicer (and save disk space) if the macro could make the selection in the combobox.

Don't know if I'm allowed to post a copy of the spreadsheet, since I didn't make it myself and the people who did are very "squeemish" when it comes to privacy and copyright issues (it's not just the VBA which is password protected, it's the whole workbook and I wouldn't be surprised if they used 2 different passwords)...which I guess isn't surprising since they're part of the gouvernment and privacy really is a big issue in the work they and we do.

Back again.
I wasn't at work the past couple of days and so couldn't check if I could figure out what type of combobox was present in the exporter spreadsheet. Turns out it's an ActiveX combobox. Don't know if that simplyfies things or makes them worse...
I'm still looking for a way to include the making the selection in the combobox in the macro, but if nobody has any ideas I'll just have to use my workaround solution.