Enter data in form fields

[mcinnes01]

Hi,

I have a spreadsheet, called a gtr from out HR system providers, essentially it allows you to import/ export data from the system and it validates against the business rules engine.

I have written a macro that populates data on to the spreadsheet and then calls the macro to import data, but this opens a form that requires you to put your login password in. I can set this as a string in vba, but how do I enter data on to the form and then click the "OK" button. This wouldn't be an issue, BUT they have password protected the vba for it and so I can access any objects externally.

Hope you can help,

Andy

[royUK]

Automating this would really make a nonsense of password protecting the files