Thread: runtime 1004 on save as
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RANDY IN NC[_5_] RANDY IN NC[_5_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote