| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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?? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open - Output txt file creation | Excel Programming | |||
| VBA error with Open for Output / Append: File not Found | Excel Programming | |||
| Open a print output sent to file | Excel Discussion (Misc queries) | |||
| Open CSV file, format data and write output to a text file. | Excel Programming | |||
| Cannot open file for output | Excel Programming | |||
Hybrid Mode
