runtime 1004 on save as

[RANDY IN NC]

I have a project I have worked on... and I find that from my compute
the following portion of code works fine saving a file to an ft
address... I am running excel 2000 I have tried to run this fro
another computer running the same version of excel and get a "run tim
error 1004" from that computer (also running excel 2000). I have run i
from my Wifes computer running excel 2003 and it worked fine...

Any help would be appriciated....

thanks


Dim sStr As String
sStr = "ftp://address"
sStr = sStr & _
ActiveWorkbook.Worksheets(1) _
.Range("a2").Text
sStr = sStr & "_"
sStr = sStr & Format(Now, "mm-dd-yy_hh-mm")
sStr = sStr & ".csv"
ActiveWorkbook.SaveAs _
Filename:=sStr, FileFormat:=xlCS

 

[dok112]

I dont think it was until excel 2003 that you could start writing th
time in the fashion you wrote. Have you attempted to run it with th
time written as hh:mm? When you run the code, and it asks you to en
or break, if you break what portion of the code is hightlighted a
being in fault

 

[Tom Ogilvy]

are your slashes all "/" rather than "\". Is the computer with a problem
running win98?

Just a guess of course.

--
Regards,
Tom Ogilvy

"RANDY IN NC" <[email protected]>
wrote in message
news:[email protected]...

 

[RANDY IN NC]

The macro was written and works in excel 2000.. it is not working o
another computer running excell 2000... it does work on a compute
running excel 2003....I have not tried it on a computer running 98..
thank you I will try the suggestions..

 

[Tom Ogilvy]

I said windows 98, not Excel 98. I am talking about the operating system.
The version of excel should have no effect.

--
Regards,
Tom Ogilvy


"RANDY IN NC" <[email protected]>
wrote in message
news:[email protected]...

 

[RANDY IN NC]

I am sorry, I understand... I will have to get in touch with the person
who tested it for me and find out... I did ask the excel version but
did not ask the windows version... Thank you

 

[RANDY IN NC]

Sorry yes all of my "/" are in the same direction..