Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is FreeFile() function???
I'm trying to understand what exactly is the purpose of the
VBA FreeFile() function??? If I call this function inside one of my VBA modules, it will return a numerical value. What is this numerical value?? thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is FreeFile() function???
"Robert Crandal" wrote in message
... I'm trying to understand what exactly is the purpose of the VBA FreeFile() function??? If I call this function inside one of my VBA modules, it will return a numerical value. What is this numerical value?? thank you Robert, Here are two ways of accessing rather immediate assistance 1. VBA Help Search "freefile". It lays it out in plain english. 2. Google. Here's one of many hits. http://zo-d.com/blog/archives/progra...ect-excel.html In the first paragraph at this site, it states "Use FreeFile to get the file number of the next file." Pretty straightforward. Skiffle |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is FreeFile() function???
Robert,
In VB you can open files and then manipulate them using FileNum. Now in a simple piece of code you could use Filenum 1 (one) manually assigned in the fairly certain knowledge the number isn't being used but in more complicated code this become very risky indeed because if you manually assign the number you may start geting uppredictable results. Hence FreeFile() which allocates the next 'unused' number. In the snippet below Filenum is assigned to the next free number by FreeFile and thereafter the file is referred to by the number assigned to it and not the name Dim FileNum As Integer LogMessage ="Some very important text" FileNum = FreeFile Open FName For Append As #FileNum Print #FileNum, LogMessage Close #FileNum ' close the file End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Robert Crandal" wrote: I'm trying to understand what exactly is the purpose of the VBA FreeFile() function??? If I call this function inside one of my VBA modules, it will return a numerical value. What is this numerical value?? thank you . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is FreeFile() function???
Thank you so much for the info. It is always appreciated!
Robert "Mike H" wrote in message ... Robert, In VB you can open files and then manipulate them using FileNum. Now in a simple piece of code you could use Filenum 1 (one) manually assigned in the fairly certain knowledge the number isn't being used but in more complicated code this become very risky indeed because if you manually assign the number you may start geting uppredictable results. Hence FreeFile() which allocates the next 'unused' number. In the snippet below Filenum is assigned to the next free number by FreeFile and thereafter the file is referred to by the number assigned to it and not the name Dim FileNum As Integer LogMessage ="Some very important text" FileNum = FreeFile Open FName For Append As #FileNum Print #FileNum, LogMessage Close #FileNum ' close the file End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions |