Thread: Open file for output
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
galimi galimi is offline
external usenet poster
  
Posts: 210
Default Open file for output
Post the error message you receive.
--
http://www.ExcelHelp.us

Call me at
1-888-MY-ETHER ext. 01781474



"Johan" wrote:

I have a worksheet with the following command

Open "test.txt" For Output As #2
Dim sString As String
sString = "open " & FtpServer & vbCrLf & FtpBruker & vbCrLf & FtpPwd &
vbCrLf & "get sjekk.txt" & vbCrLf & "bye"
Print #2, sString
Close #2

this works in Excel 2003 but not in Excel 2007 any one know why??
Reply With QuoteReply With Quote