chriz1000

Anyone got any advice?

I’m trying to make a macro that copy’s the house number and postcode from a MS Access form, then opens up this website: http://www.postoffice.co.uk/portal/po/addr...requestid=89894 And pastes the house number and postcode into the relative fields. I have done this bit so far, but it’s probably not done in the most efficient way. What I then need to do is copy the returned address results from the website above back into the access form. This is what I’m having problems doing. Any help much appreciated. Chris

One of my macros runs in a text document, every week the text file is renamed to the week of the year, is there a way of setting up macro express so the macro parameters automatically change at the end of each week. At the moment I have to change the macro manually Cheers

Is there a way to search through a notepad document with a macro and do a find and replace type search? Cheers

When a macro is running I’m getting a problem where if I click the mouse or type anything, it will interfere with the macro and it won’t complete correctly. I can’t set the macro to write to a certain file only, as the name of the file changes on a very regular basis. Is there a way to lock out the keyboard and mouse until the macro has completed? Cheers