Is it possible to create a program in VBE that will act as an add-on to a program that will import data from a text file and place it into another program Or is this a program that needs to be created in some other language/version
Any thoughts/comments are appreciated. (I just don't want to waste my time) Thanks.
Is it possible to...
bri5
It's definatly possible... infact, i recently created a little program that uses SendKeys to, well, send keys to another program. You type what you want it to auto-type into a textbox and away it goes at a click of a button! Also, if you want it to keep typing the sam ething periodicly, you can set the speed.
If you wanted to take the text from a file, just use a text uploader in the program or copy/paste the text manually.
If you would like me to alter my program to fit your needs, or give you some code, please post and/or e-mail me at ************@hotmail.com (sencored for privacy)
Hope this helps,
-
ItsMe!!!
Mr pinchy
I have sent you an e-mail with the program you asked for... So other users who visit this tread know - to send text to another program you use SendKeys:
Senkeys.send ("Message here")
and it will 'send keys' to what ever program is in focus.
Hope this helps
BBPowers
Sure this is possible. Your talking about a conversion program.
You are basically going to have to parse the text file and do your conversion before writing it out.
Here is an article on parsing the text file using the textfieldparser class
http://msdn2.microsoft.com/en-us/library/x710fk43.aspx
Once you are processing (parsing) the file you can apply you conversion and ultimately you can write out you data. It could be to another text file (in which case you can use streamwriter, my.computer.filesystem.writealltext classes) or it could be to Excel (in which case you could use the Excel Object model to write to excel) or it could be to import into a SQL database (in which case ADO.Net)
Using the above textfieldparser class should enable you to process a wide variety of text files fairly easily.
Alex-MyRpg
I am deciding if I can use Visual Basic Express to query and perform calculations on a data set of parameters of stars from 2MASS (2 micron all sky survey). An answer to these questions could save me alot of time and wasted effort.
I have not started using VBE, but the video tutorials I've watched lead me to believe that this might be the right tool for me to use. I have programmed in the distant past (Algol, Basic, Pascal - for those who remember such beasts, but that was a loooooong time ago).
First, can I import the format and data into a database that I can then access and use in Visual Basic Express
Second, How do I do this
The data set and format can be found at: ftp://ftp.ipac.caltech.edu/pub/2mass/allsky/practice/
What I would want to do is import the format (columns) into a table set up and them import the data - WITHOUT TYPING IT ALL IN.
Any help would be greatly appreciated.