Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open - Output txt file creation
Hi everybody,
I would like to know whether I need to add a specific reference in my vba project in order to be able to use the following kind of command: dim lfnum as long lfNum =FreeFile Open strName &".txt" For Output as lFNum Because by default whenI do that it is not recognized and the compilation cannot be done thans in advance for your answer G |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open - Output txt file creation
There is nothing wrong with what you have written, but you have
magically created a variable called StrName in your code snippet and (a) not declared it and (b) not set it - so there MAY be something in the rest of your code that is actually the fault elcroco wrote: Hi everybody, I would like to know whether I need to add a specific reference in my vba project in order to be able to use the following kind of command: dim lfnum as long lfNum =FreeFile Open strName &".txt" For Output as lFNum Because by default whenI do that it is not recognized and the compilation cannot be done thans in advance for your answer G |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open - Output txt file creation
Where, if ever, are you declaring and assigning a value to the variable
strName? If you do not have an Option Explicit declaration at the top of the code module, and you haven't declared the strName variable, VBA will create it automatically and give it a value of an empty string. Therefore, your code is attempting to open a file named ".txt", and this will cause an error. First of all, put Option Explicit at the very first line of your code module (above and outside of any procedure). Then in the procedure, declare the variable strName and give it a value: Dim strName As String strName = "C:\Test.txt" '<<<< CHANGE AS REQUIRED Then call open: Open strName &".txt" For Output as lFNum -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "elcroco" wrote in message oups.com... Hi everybody, I would like to know whether I need to add a specific reference in my vba project in order to be able to use the following kind of command: dim lfnum as long lfNum =FreeFile Open strName &".txt" For Output as lFNum Because by default whenI do that it is not recognized and the compilation cannot be done thans in advance for your answer G |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open - Output txt file creation
the variable is declared before, I ve just forgotten to write it in the
post !!! wrote: There is nothing wrong with what you have written, but you have magically created a variable called StrName in your code snippet and (a) not declared it and (b) not set it - so there MAY be something in the rest of your code that is actually the fault elcroco wrote: Hi everybody, I would like to know whether I need to add a specific reference in my vba project in order to be able to use the following kind of command: dim lfnum as long lfNum =FreeFile Open strName &".txt" For Output as lFNum Because by default whenI do that it is not recognized and the compilation cannot be done thans in advance for your answer G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
"Unable to Open File" - excel output of Datagrid <-help needed | Excel Programming |