Inputting Excel Tables into VB
Inputting Excel Tables into VB
(OP)
I am writing a little application in Visual Studio Express and I want to import 5 colum wide x 400 row long data from excel and hard code it into the program as constants.
Is there a way to import this easily into VB?
The only idea I have come up with is to populate a column in the 6th column with the VB code and using the "&" to combine the data and then copy and paste it into the program.
Any other ideas? I am no expert on this VB stuff (Yet) so I am looking for simple ideas.
Thanks
Zuccus
Is there a way to import this easily into VB?
The only idea I have come up with is to populate a column in the 6th column with the VB code and using the "&" to combine the data and then copy and paste it into the program.
Any other ideas? I am no expert on this VB stuff (Yet) so I am looking for simple ideas.
Thanks
Zuccus





RE: Inputting Excel Tables into VB
You can even use an Excel worksheet function like: = " dim " & cellreference & " as integer" to get the text you want, then copy and paste.
RE: Inputting Excel Tables into VB
And I would never hard code constants!
RE: Inputting Excel Tables into VB
RE: Inputting Excel Tables into VB
If it can be used by people without access than I should be pretty well off. I don't like hard coding constants either, but I didn't have any ideas about how to get it out of excel.
Thanks Tom and FrancisL.
RE: Inputting Excel Tables into VB
A VB form wizard should produce a quick way to edit the data for those that need to.
Amd think about testing too, a set of test data in another table perhaps.