2003 Macro problem

[PhantomII]

HI All

I have an Excel spreadsheet that runs a macro that basically ftp's 3 files in from a unix box and then does some maths on the imported data an produces some reports.

This runs fine if I run it on 97 , but if I try to run it on 2003 It imports the first file of data, populates the page and then I get an error 9 messages on the next statement in the macro which has a .Activate command on the end.

Windows("ftp://" & server & ftppathname & "user_stats_" & mmmyyyy).Activate

The macro security setting is set to low. Are there any other new security setting in excel that I need to change, or is this likely to be a something else???

Many thanks in advance

PhantomII

[royUK]

I certainly wouldn't set it to Low, use Medium.

We need to see the code