Menu
I am writing code to read lines from a text file and I came across this method:
Dim FileNum As Integer
Dim DataLine As String
FileNum = FreeFile()
Open "Filename" For Input As #FileNum
I understand that when # is placed after a variable it denotes it as a double but what does it mean when it is placed before the variable, as in Open "Filename" For Input As #FileNum?
449
The pound is defining which filestream you want to use.
The Microsoft Excel IF-THEN-ELSE statement can only be used in VBA code. It executes one set of code if a specified condition evaluates to TRUE, or another set of code if it evaluates to FALSE. The IF-THEN-ELSE statement is a built-in function in Excel that is categorized as a Logical Function.
In Visual Basic, the separator character is the colon ( : ). Use separators when you want to include multiple statements on a single line instead of separate lines. This saves space and improves the readability of your code.
When you are in the Insert->Symbol Dialog and you select the symbol you want to insert, you'll see at the bottom of the Dialog the hexadecimal character code of the symbol. You can use the codes to write the characters in strings or directly in cells.
The # (for "number") is there since the old times. VB6 just supports it. It does nothing execution wise. It used to assist readability and make the language more natural-like. Speak out loud:
Open "1.txt" For Input As 1
vs.
Open "1.txt" For Input As #1
Reference:- What does a hash do to a variable in VB?
79
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
