By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,060 Members | 1,878 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,060 IT Pros & Developers. It's quick & easy.

Excel to string with quantity

P: n/a
Hello, I have a Excel document with multiple colums.
I want to use te data from 2 colums (filename & quantity).
First i want to know the quantity, because when the quantity is '3' i
want to make a string value with three times the same filename from the
same row.

### Examle, a row with the values for the colum filename: 'MyFile.XXX'
and the colum quantity: '3'
The string that i need to get for that row is:
'MyFile.XXX MyFile.XXX MyFile.XXX'

If someone knows a better/more easy way if i convert the Excel source
into a other format, please tell me, it is possible for me to convert
the Excel file.

I hope someone can help me.

Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You know what, I'm not being funny but your post makes no sense to me
whatsoever. Firstly this is a VB.NET Group, not an exel or VBA group.
Secondly, your description is so abstract and incomplete, I really don't
know what you are trying to achieve. Try reformatting your question so we
can understand it, then you might get a coherent response.

--
Terry Burns
http://TrainingOn.net

"nielsh" <ni****@hollandridderkerk.nl> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Hello, I have a Excel document with multiple colums.
I want to use te data from 2 colums (filename & quantity).
First i want to know the quantity, because when the quantity is '3' i
want to make a string value with three times the same filename from the
same row.

### Examle, a row with the values for the colum filename: 'MyFile.XXX'
and the colum quantity: '3'
The string that i need to get for that row is:
'MyFile.XXX MyFile.XXX MyFile.XXX'

If someone knows a better/more easy way if i convert the Excel source
into a other format, please tell me, it is possible for me to convert
the Excel file.

I hope someone can help me.

Nov 21 '05 #2

P: n/a
I am sorry that i made no sense...

I want to make an application in VB.net that gets his information out of
an Excel file (or an other file format if that would be better).
The information is then converted into a string for use in a commandline
(prompt).

The 2 culoms i mentioned before ('Filename' & 'Quantity') have the
information i need for creating the string.

the value 'Quantity' is a Integer and it only say how many times the
value "Filename" will repeat in the string.

### Examle,
When 'Filename' has the value 'MyFile.XXX'
and 'Quantity' has the value '3'.
Then the string that i need to get for that row is:
'MyFile.XXX MyFile.XXX MyFile.XXX'

I hope i am more clear now for what my intensions are.....

Either way thaks for you answer

*** Sent via Developersdex http://www.developersdex.com ***
Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.