runtime 1004 on save as
 

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

--
RANDY IN N
-----------------------------------------------------------------------
RANDY IN NC's Profile: http://www.excelforum.com/member.php...fo&userid=2977
View this thread: http://www.excelforum.com/showthread.php?threadid=50901

runtime 1004 on save as
 

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

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=50901

runtime 1004 on save as
 

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"
wrote in message
...

I have a project I have worked on... and I find that from my computer
the following portion of code works fine saving a file to an ftp
address... I am running excel 2000 I have tried to run this from
another computer running the same version of excel and get a "run time
error 1004" from that computer (also running excel 2000). I have run it
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:=xlCSV


--
RANDY IN NC
------------------------------------------------------------------------
RANDY IN NC's Profile:
http://www.excelforum.com/member.php...o&userid=29778
View this thread: http://www.excelforum.com/showthread...hreadid=509018

runtime 1004 on save as
 

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..

--
RANDY IN N
-----------------------------------------------------------------------
RANDY IN NC's Profile: http://www.excelforum.com/member.php...fo&userid=2977
View this thread: http://www.excelforum.com/showthread.php?threadid=50901

runtime 1004 on save as
 

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"
wrote in message
...

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


--
RANDY IN NC
------------------------------------------------------------------------
RANDY IN NC's Profile:
http://www.excelforum.com/member.php...o&userid=29778
View this thread: http://www.excelforum.com/showthread...hreadid=509018

runtime 1004 on save as
 

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

Tom Ogilvy Wrote:
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"

wrote in message
...

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


--
RANDY IN NC

------------------------------------------------------------------------
RANDY IN NC's Profile:
http://www.excelforum.com/member.php...o&userid=29778
View this thread:
http://www.excelforum.com/showthread...hreadid=509018



--
RANDY IN NC
------------------------------------------------------------------------
RANDY IN NC's Profile: http://www.excelforum.com/member.php...o&userid=29778
View this thread: http://www.excelforum.com/showthread...hreadid=509018

runtime 1004 on save as
 

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

Tom Ogilvy Wrote:
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"

wrote in message
...

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


--
RANDY IN NC

------------------------------------------------------------------------
RANDY IN NC's Profile:
http://www.excelforum.com/member.php...o&userid=29778
View this thread:
http://www.excelforum.com/showthread...hreadid=509018



--
RANDY IN NC
------------------------------------------------------------------------
RANDY IN NC's Profile: http://www.excelforum.com/member.php...o&userid=29778
View this thread: http://www.excelforum.com/showthread...hreadid=509018