|
Here's the problem: I have raw data (from a mainframe) in the form of a text file and its also already in tabular form with a title centered on top and everything. These numbers are normally inputted manually on Excel. How do I get that info from the text file automated so it is put into Excel nicely? Do I keep the text file as a text file or do i want to change it into CSV file? What is the easiest way to go about this?
|
|
|
|
|
Try just opening it in Excel. Excel's Text importer is pretty good at dealing with tab-delimited files.
|
|
|
|
|
I'm pretty new to VB programming however i'm trying to become better. i Play an online RP game , i want to make some sort of calculator with an cope and paste option so i can copy and paste info from the browser/clipboard into the program and format the text.
the text might look like this :
name
sypto
country
trysto
12876
offense
12000
defense
10000
something liek that , not i need to have a way that it copies the 12000 and the 10000 for example into the calculator..how do i start this ?
|
|
|
|
|
If you're playing Utopia (http://games.swirve.com/utopia) there is a good calculator already (http://utopia.sourceforge.net/)  .
Use the Clipboard object to get the text you just copied from the browser, and afterwards you can treat the text as string. I am assuming each line is separated by Char(13) and you can probably split them into an array using the Split() function and get the data you want from the array.
Here's an example from MSDN on how to use clipboard (you need the namespace System.Windows.Forms):
Private Sub button2_Click(sender As Object, e As System.EventArgs)
' Declares an IDataObject to hold the data returned from the clipboard.
' Retrieves the data from the clipboard.
Dim iData As IDataObject = Clipboard.GetDataObject()
' Determines whether the data is in a format you can use.
If iData.GetDataPresent(DataFormats.Text) Then
' Yes it is, so display it in a text box.
textBox2.Text = CType(iData.GetData(DataFormats.Text), String)
Else
' No it is not.
textBox2.Text = "Could not retrieve data off the clipboard."
End If
End Sub 'button2_Click
|
|
|
|
|
Hi,
Is it possible to use a vb.net library in a vb 6.0 application? I have made a vb.net application that communicates with a vb 6.0 COM add in. And I want to be able to send my custom vb.net objects to the vb 6.0 COM add in. Can it be done?
Best regards
Pål Eilertsen
|
|
|
|
|
Have you looked at the .NET SDK documentation section "Exposing .NET Framework Components to COM" ? Start there - it may help.
|
|
|
|
|
|
I use externals ocx in my project. In my machine, the application works fine.
I add a project of instalation. I make the setup without errors.
I execute this setup in a machine without miscrosoft visual studio without error messages.
I execute the application and the application crash.
If i do the same, modify the application, and not use externals ocx, do the same and the application works fine. I have to do something special with the externals ocx's ?
Sorry for my english. I'm spanish.
Thanks.
|
|
|
|
|
Is your Application written in VB.Net? If it is, then your client's machine will need the Framework for apps written in .Net
If this isn't the case, can you be more specific on how your app crashed? What was the error message, if any, etc.
Sig Under Construction. Visit back later.
Support Bone
|
|
|
|
|
Hi,
The situation is like this:
I have created a MCQ test using a excel spreadsheet and I have created a nice macro GUI which will display the "time left" and will save and close the application which the time is up.
May I noe how can I prog the macro to run automatically when the spreadsheet is opened ?
Please advise. Thank you !!
With regards
bk
|
|
|
|
|
Why don't you call the macro in the spreadsheet auto macro called Workbook_Open()?
Therefore it will always be called when the spreadsheet is opened.
|
|
|
|
|
Is it possible to connect to As400 using winsock?
If so can you referrer to the sites and examples.
Thanks
|
|
|
|
|
All,
1)
Why does
Dim mResult as double
mResult = 0.1 * 0.1
return mResult = 0.010000000000000002?
What can I do about it?
Thanks,
Joe
|
|
|
|
|
You cannot trust double nor float results on any language (to be picky, those who use IEEE floating point arithmetic): they are subject to rounding errors.
A full description of the causes can be found on several articles on the web, like here
Search google for, e.g., IEEE rounding errors.
There are quick ways of working this around:
1. round the results
2. don't compare with '=', use a 'between'-like comparison.
3. Use the Decimal data type.
Trying to make bits uncopyable is like trying to make water not wet.
-- Bruce Schneier
|
|
|
|
|
Rounding worked great - thanks.
I'll read those references to get educated - I haven't done very much numeric computing stuff.
|
|
|
|
|
Sir
To create a hook dll people recomending to create a dll in visualc++ and use that in vb.
Is it not possible to create a vb dll for a creating a system wide hook dll for example keybaord hook dll and use the same way as we use dll made from vc++ or delphin software.
Please give me suggestions what are the draw backs in creating a vb dll and what are the constraints we have to consider in creating a dll in vc++ that can be used in vb for the purpose of system wide hook
Thanks in advance
rvvimal
|
|
|
|
|
percyvimal wrote:
Is it not possible to create a vb dll for a creating a system wide hook dll
Nope. Sorry.  But you might look around for a system-wide hook DLL that's meant for use with .NET.
Remember, btw, that you should only use system-wide hooks where absolutely necessary. 
|
|
|
|
|
Thanks sir,
But if you could provide me what are the important things that is necessary for creating a vc++ dll like i didnt understand the address parametes where u need to send the address of the call back function and how the function should be decalared in vc++ etc
then it will be really helpful to me
thanks in advance
|
|
|
|
|
The hook types WH_KEYBOARD_LL, WH_MOUSE_LL, WH_JOURNALRECORD and WH_JOURNALPLAYBACK can be written perfectly well in VB5 or 6.
The others require the hook procedure to be in the dll exports section which is not possible in VB.
'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd
|
|
|
|
|
I want to play quick time video (.mov) file in vb. How can I play ?
When I use microsoft active movie control, It gives me unspecified
error. pls advice if there is any codec required for that.
thanks in advance
sanjeev kumar 
sanjdhi@rediffmail.com
sanjeev
|
|
|
|
|
There are codecs involved. Why not just use the QuickTime Control (QTPlugin.ocx)?
RageInTheMachine9532
|
|
|
|
|
Hi Folks
I have 2 datagrids - don't worry about the contents. When I scroll datagrid1, I want to scroll datagrid2 so that both datagrids have the same row number for the first visible row.
I know how to scroll to, but I have no idea how to get the rownumber of that first visible row in datagrid1.
A code scrap would be much appreciated.
Thanks
|
|
|
|
|
I am programing a windows app (much like my console app talked about earlier in the forums) such as this.
User inputs number
Number is stored into an array
there are commands the user can use to print sort and other such things.
I do not want to use the arraylist function. I want to do this using just using array as such:
Dim array1(3) as string
I'm not sure how to add items to the array. In all my searching I only found information on the Arraylist. If anyone can Point me in the right direction.
"Doko ni datte, hito wa tsunagatte iru." -Lain
|
|
|
|
|
Do you mean to assign objects to the array, simply do this
array1(0) = "Hello"
array1(1) = "world"
If you mean to increase the capacity of the array, use the Redim keyword
Redim Preserve array1(10)
array1(9) = "Bye"
Sig Under Construction. Visit back later.
Support Bone
|
|
|
|
|
I want to assign objects to the array. However I need to do this dynamically as they type information in.
I can't get the code right for the program to add the new string to the end of the array.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
