Hi All, I have an excel book,which contains 5 sheets as below: - One - two - three - four - five in the same book i have one form where i have placed one...
Dear any one send me the code for word macro to check the weather map drive is active or not. regards, sikhan [Non-text portions of this message have been...
I have been using vb for years now. Im currently working a project to automate processes used but my company to track installations by our techs. We use a web...
I need some help with the following. I am taking a file from one system via FTP. The file is a delimited text file. I need to be able to take this file and...
Dear guuuyyy, I think you can simply change the .txt suffix to .csv and Excel will load it fine. Edgar ... [Non-text portions of this message have been...
... No formatting in a delimited text file. You can just open the file in excel and it will decide where the columns are if it is delimited by tab or comma....
Edgar True, it will but it will also change the value of some numeric values, which is why i need to be able to format the columns. For example I have the...
Dear guuuyyy, I think you can simply change the .txt suffix to .csv and Excel will load it fine. Edgar ... Explore and discover exciting holidays and getaways...
Guuuyyy, That's a matter of simply changing the formating of the Excel columns in Excel to currency. I don't know if there is a way to do this automatically...
Save the txt file in the system. Open the file through excel. Text Import Wizard will open and then you can convert the file to excel giving the way you like...
I'm using VB.net and trying to get images from a word document and save them to an access file. I can't seem to find many examples of this on the web, would...
I am using VB2008 and was wanting to know how to use a button to select/display a certian tab in the tabcontrol. I have 9 tabs and want to display one when the...
I think Guuy wants to do it programmatically. Needs to incorporate some Excel VBA. ... From: sheeja k To: VisualBasic_Official@yahoogroups.com Sent: Friday,...
Easiest way would be to start "Record Macro", follow steps Sheeja outlined, stop recording, switch to Visual Basic view, and copy the code the Excel macro...
I figured it out late last night. I used TabControl1.SelectTab(8) The tabs are also numbered 0 thru.. not 1 thru... This may be common sense but I'm learning. ...
I am using a combobox in VB2008 with a total of 8 items. Can I make an item not visible depending on if a channel is availble or do I have to rewrite the...
Hi Brian, Try the following code in the Button_Click event: TabControl1.SelectTab(1) or TabControl1.SelectedIndex = 1 where 1 is the second tab. Remember the...
Hi Brian, You can use, for example: TabControl1.SelectTab(Index) or TabControl1.SelectedIndex = Index Search help for 'Tabcontrol Class' should give you more...
Hello All.. I am beginner programmer... I have one problem... When I insert the date picked from the system into Sql Server 2005, it doesnt store the date...
Greetings I have to generate box, bundle and serial numbers as identifiers for a Store Room System. I tried using an arraylist but got an error that: "Index...
I think I found a way, it works so far. When I connect to my external target via the serial port the channels will update. Does anyone have a better way to...
Dim channels As Short = 3 'Will be updated with number of channels cbTemp.Items.Clear() For i As Integer = 1 To channels cbTemp.Items.Add(i.ToString) Next ...
Hi I modified the code, but still getting the error: Dim box, bundle, serial, count As Integer Dim SerialNum As New ArrayList(4) count = CInt(TxtSerial.Text) ...
Hi I want to generate 4 sets of numbers with relationships. First set will have +- 1000, second set about 8000 and the third about 600 000. This will then be...
I'm using a tool that uses VB to insert data into an Access DB that it creates. I'm getting the following error msg when it's running. Syntax error in string...
Dear all You are requested to provide the guidelines/reference material of excel macros. I would really appreciate if anyone can provide the sample macros as...
Dear all You are requested to provide the guidelines/reference material of excel macros. I would really appreciate if anyone can provide the sample macros as...
Hi, all. I have this MDI form as startup form and in which I have a menu that calls the other parts of the application. Also, in the blank area of the MDI form...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
