ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open file for output (https://www.excelbanter.com/excel-programming/420621-open-file-output.html)

Johan

Open file for output
 
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??

galimi

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


Johan

Open file for output
 
Thank you, but I found a solution on the problem

galimi skrev:

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



All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com