-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
linetext
-
N
VBA for saving values in one column to text file
Hello, New to the forum. I've learned a lot just reading. Wondering if someone can help me with the VBA code below. It DOES save the whole worksheet to a text file, but I would like it to also Only save content in Column K Skip over blank cells in Column K Sub saveText()...- noslenwerd
- Thread
- column export filename linetext text file
- Replies: 2
- Forum: Excel Questions
-
R
Error runtime 13 export a selected column to text file
HI Can you help me? This macro give me a error runtime 13 mismatch when the loop arrive to a blank cell how can fix it? i'm sorry for my english Sub saveText2() Dim filename As String, lineText As String Dim myrng As Range, i, j filename = ThisWorkbook.Path & "\Command.txt"...- RaidHack
- Thread
- dim export filename linetext string
- Replies: 8
- Forum: Excel Questions
-
IIF replacement code
I have a code that runs fine on Excel 2016 but crashes miserably on 2010. This is the line that fails. lineText = IIf(j = 1, "", lineText & ",") & myrng.Cells(i, j) The entire macro is listed below. I need to know how to convert this to a standard If-Then-Else statement so that it will run...- rjplante
- Thread
- dim linetext sheetsscript string true
- Replies: 3
- Forum: Excel Questions
