Formatting number to have 2 digits: “Object required”
up vote
-1
down vote
favorite
Having a look in other threads on the issue, I've found how I can do it, but still i have some issue with my code (printing some values to a file. )
I'm trying to read some data from Excel sheet (it has 32 lines) and print it to a text file in some defined format. The code is for Excel Visual Basic
For y = 1 to 32
Print #1, y.ToString("D2")
Print #1, "some text" & y.ToString("D2")
Next y
I'm getting runtime error 424: object required on both of printing commands.
Am I missing something?
vba
edited Nov 11 at 9:35
trincot
114k1477109
asked Nov 11 at 9:12
user1977050
911210
|
show 1 more comment
up vote
-1
down vote
favorite
Having a look in other threads on the issue, I've found how I can do it, but still i have some issue with my code (printing some values to a file. )
I'm trying to read some data from Excel sheet (it has 32 lines) and print it to a text file in some defined format. The code is for Excel Visual Basic
For y = 1 to 32
Print #1, y.ToString("D2")
Print #1, "some text" & y.ToString("D2")
Next y
I'm getting runtime error 424: object required on both of printing commands.
Am I missing something?
vba
edited Nov 11 at 9:35
trincot
114k1477109
asked Nov 11 at 9:12
user1977050
911210
Your error has something to do with the way you opened your text file#1or whatever theyobject is - which we can see neither in the code you provided.
– K.Dᴀᴠɪs
Nov 11 at 9:19
File was opened withOpen fileName For Output As #1. There is no other definition fory. It is integer
– user1977050
Nov 11 at 9:23
Is this vba? Because you can't attach a method to an integer the way you are doing. What exactly is the purpose ofy?
– K.Dᴀᴠɪs
Nov 11 at 9:27
@K.Dᴀᴠɪs, This is Visual Basic for Excel
– user1977050
Nov 11 at 9:28
obj.toStringis a vb.net method. So what are you usingyfor? Better yet, what is your expected string in it's completed form?
– K.Dᴀᴠɪs
Nov 11 at 9:30
|
show 1 more comment
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
Having a look in other threads on the issue, I've found how I can do it, but still i have some issue with my code (printing some values to a file. )
I'm trying to read some data from Excel sheet (it has 32 lines) and print it to a text file in some defined format. The code is for Excel Visual Basic
For y = 1 to 32
Print #1, y.ToString("D2")
Print #1, "some text" & y.ToString("D2")
Next y
I'm getting runtime error 424: object required on both of printing commands.
Am I missing something?
vba
edited Nov 11 at 9:35
trincot
114k1477109
asked Nov 11 at 9:12
user1977050
911210
Having a look in other threads on the issue, I've found how I can do it, but still i have some issue with my code (printing some values to a file. )
I'm trying to read some data from Excel sheet (it has 32 lines) and print it to a text file in some defined format. The code is for Excel Visual Basic
For y = 1 to 32
Print #1, y.ToString("D2")
Print #1, "some text" & y.ToString("D2")
Next y
I'm getting runtime error 424: object required on both of printing commands.
Am I missing something?
vba
vba
edited Nov 11 at 9:35
trincot
114k1477109
asked Nov 11 at 9:12
user1977050
911210
edited Nov 11 at 9:35
trincot
114k1477109
asked Nov 11 at 9:12
user1977050
911210
edited Nov 11 at 9:35
trincot
114k1477109
edited Nov 11 at 9:35
trincot
114k1477109
edited Nov 11 at 9:35
trincot
114k1477109
114k1477109
asked Nov 11 at 9:12
user1977050
911210
asked Nov 11 at 9:12
user1977050
911210
asked Nov 11 at 9:12
user1977050
911210
911210
Your error has something to do with the way you opened your text file#1or whatever theyobject is - which we can see neither in the code you provided.
– K.Dᴀᴠɪs
Nov 11 at 9:19
File was opened withOpen fileName For Output As #1. There is no other definition fory. It is integer
– user1977050
Nov 11 at 9:23
Is this vba? Because you can't attach a method to an integer the way you are doing. What exactly is the purpose ofy?
– K.Dᴀᴠɪs
Nov 11 at 9:27
@K.Dᴀᴠɪs, This is Visual Basic for Excel
– user1977050
Nov 11 at 9:28
obj.toStringis a vb.net method. So what are you usingyfor? Better yet, what is your expected string in it's completed form?
– K.Dᴀᴠɪs
Nov 11 at 9:30
|
show 1 more comment
Your error has something to do with the way you opened your text file#1or whatever theyobject is - which we can see neither in the code you provided.
– K.Dᴀᴠɪs
Nov 11 at 9:19
File was opened withOpen fileName For Output As #1. There is no other definition fory. It is integer
– user1977050
Nov 11 at 9:23
Is this vba? Because you can't attach a method to an integer the way you are doing. What exactly is the purpose ofy?
– K.Dᴀᴠɪs
Nov 11 at 9:27
@K.Dᴀᴠɪs, This is Visual Basic for Excel
– user1977050
Nov 11 at 9:28
obj.toStringis a vb.net method. So what are you usingyfor? Better yet, what is your expected string in it's completed form?
– K.Dᴀᴠɪs
Nov 11 at 9:30
Your error has something to do with the way you opened your text file
#1 or whatever the y object is - which we can see neither in the code you provided.– K.Dᴀᴠɪs
Nov 11 at 9:19
Your error has something to do with the way you opened your text file
#1 or whatever the y object is - which we can see neither in the code you provided.– K.Dᴀᴠɪs
Nov 11 at 9:19
File was opened with
Open fileName For Output As #1. There is no other definition for y. It is integer– user1977050
Nov 11 at 9:23
File was opened with
Open fileName For Output As #1. There is no other definition for y. It is integer– user1977050
Nov 11 at 9:23
Is this vba? Because you can't attach a method to an integer the way you are doing. What exactly is the purpose of
y?– K.Dᴀᴠɪs
Nov 11 at 9:27
Is this vba? Because you can't attach a method to an integer the way you are doing. What exactly is the purpose of
y?– K.Dᴀᴠɪs
Nov 11 at 9:27
@K.Dᴀᴠɪs, This is Visual Basic for Excel
– user1977050
Nov 11 at 9:28
@K.Dᴀᴠɪs, This is Visual Basic for Excel
– user1977050
Nov 11 at 9:28
obj.toString is a vb.net method. So what are you using y for? Better yet, what is your expected string in it's completed form?– K.Dᴀᴠɪs
Nov 11 at 9:30
obj.toString is a vb.net method. So what are you using y for? Better yet, what is your expected string in it's completed form?– K.Dᴀᴠɪs
Nov 11 at 9:30
|
show 1 more comment
1 Answer
1
active
oldest
votes
up vote
1
down vote
accepted
You seem to be mixing up Visual Basic with Visual Basic for Applications (VBA): they are quite different.
In VBA you can format a number with the Format function:
Format(y, "00")
answered Nov 11 at 9:38
trincot
114k1477109
You're welcome ;-)
– trincot
Nov 11 at 9:42
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
You seem to be mixing up Visual Basic with Visual Basic for Applications (VBA): they are quite different.
In VBA you can format a number with the Format function:
Format(y, "00")
answered Nov 11 at 9:38
trincot
114k1477109
You're welcome ;-)
– trincot
Nov 11 at 9:42
add a comment |
up vote
1
down vote
accepted
You seem to be mixing up Visual Basic with Visual Basic for Applications (VBA): they are quite different.
In VBA you can format a number with the Format function:
Format(y, "00")
answered Nov 11 at 9:38
trincot
114k1477109
You're welcome ;-)
– trincot
Nov 11 at 9:42
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
You seem to be mixing up Visual Basic with Visual Basic for Applications (VBA): they are quite different.
In VBA you can format a number with the Format function:
Format(y, "00")
answered Nov 11 at 9:38
trincot
114k1477109
You seem to be mixing up Visual Basic with Visual Basic for Applications (VBA): they are quite different.
In VBA you can format a number with the Format function:
Format(y, "00")
answered Nov 11 at 9:38
trincot
114k1477109
edited Nov 11 at 9:42
answered Nov 11 at 9:38
trincot
114k1477109
answered Nov 11 at 9:38
trincot
114k1477109
answered Nov 11 at 9:38
trincot
114k1477109
114k1477109
You're welcome ;-)
– trincot
Nov 11 at 9:42
add a comment |
You're welcome ;-)
– trincot
Nov 11 at 9:42
You're welcome ;-)
– trincot
Nov 11 at 9:42
You're welcome ;-)
– trincot
Nov 11 at 9:42
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53247298%2fformatting-number-to-have-2-digits-object-required%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Your error has something to do with the way you opened your text file
#1or whatever theyobject is - which we can see neither in the code you provided.– K.Dᴀᴠɪs
Nov 11 at 9:19
File was opened with
Open fileName For Output As #1. There is no other definition fory. It is integer– user1977050
Nov 11 at 9:23
Is this vba? Because you can't attach a method to an integer the way you are doing. What exactly is the purpose of
y?– K.Dᴀᴠɪs
Nov 11 at 9:27
@K.Dᴀᴠɪs, This is Visual Basic for Excel
– user1977050
Nov 11 at 9:28
obj.toStringis a vb.net method. So what are you usingyfor? Better yet, what is your expected string in it's completed form?– K.Dᴀᴠɪs
Nov 11 at 9:30