Question about Microsoft Visual Basic Enterprise Edition 6.0 (361-00667) for PC

1 Answer

Inserting data into MSFlexGrid control from an excel file

How to insert data to an MSFlexGrid contol in visual basic 6.0. After this is done with the data how to draw chart of type XYscatter using MSChart control

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

    New Friend:

    An expert that has 1 follower.

  • Expert
  • 48 Answers

Have you tried implementing an ADO (Active Data Object) control (available from the toolbox)? Properly configured (and run via OLEDB or Microsoft Jet as appropriate for your setup) it works like a champ.

Posted on Apr 07, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Do you have a formula in Microsoft Excel that a value can convert to a word...(Ex. 15,000 then it will convert to in words fifteen Thousand..)thanks. need immediate reply.


Hi enelrah_mel0,

You can create a function called SpellNumber using the Visual Basic Editor in the Microsoft Excel to spell the number.

  1. Please Open Microsoft Excel. Then press Alt + F11 to open the Visual Basic Editor.
  2. Then, click "Insert" option above the Visual Basic Editor window and select "Module".
  3. Then, in the Book1 Module1 (Code) window, paste the below code there. (pasted in the next post separately for your convenience)
  4. Then, press Alt+Q to close the Visual Basic Editor window.
  5. After that, please type the formula " =SpellNumber( * )" in the Excel Sheet and press the Enter Key.
  6. Then, save the Excel Sheet.
eg: =SpellNumber(A1)

Where A1 is the first cell in the excel sheet.


Good Luck!

Please post back the result and let me know if you require further assistance.

Thanks for using Fixya.

Oct 29, 2010 | IBM ThinkPad T30 2366 Notebook

1 Answer

How to Export MSFlexgrid Data to Crystal Report in Visual Basic 6.0


simple Way to do is
Save all Data to any temporary table
and call temp.table from any report writer

Dec 10, 2009 | HP Computers & Internet

1 Answer

Drawing in Visual Basic 6.0


Hi - You cannot scan directly into VB6 unless you use a third-party control (OCX). You would need to get the data into a database table and use ADO, or, hard-code the data directly into your source code. You can actually grab it from Excel too but that involves automation programming - not hard to do - just more to learn. Have fun!

May 12, 2009 | Microsoft Visual Basic Enterprise Edition...

1 Answer

Write into excel format


Your code does not save in access format it just makes a copy of existing file. You need to open table by table and export data using csv format.
It can be done using access OLE to export, or
write some VB code to access the database tables via ODBC and save row data to csv file

Feb 17, 2009 | Microsoft Visual Basic Professional...

1 Answer

Write into excel format


You can use ADO or SQL to open the excel file directly (provided it is constructed correctly, ie fields names) and write the data to it without Access.
That might be eaiser thatn converting it from Access to Excel, if that can even be done.

Feb 17, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

Type mismatch in MSFlexGrid Control


type mismatch error occours when there is a mismatch between the value which you are trying to assign to a variable which is dimensioned to store values of another, first you check if the datatypes match each other by applying the break.

Dec 19, 2008 | Microsoft Visual Basic 6.0 for PC

1 Answer

How can i print datas from MSFlexGrid in VB6


I hear a lot of people are asking that question. I am sure its possible.
Try this:

For i = 0 To Form1.MSFlexGrid1.Col
For j = 0 To Form1.MSFlexGrid1.Row
Print Form1.MSFlexGrid1.TextMatrix(i, j)
Next j
Next i

That should move the data. I think. This isn't my best area; however, It doesn't hurt to try it right?

Hope it helps.

Nov 21, 2008 | Computers & Internet

1 Answer

Excel password is protected....... but not i don't know that password,,,,,,, so password are remove if i see that password


Excel Password Remover 2008

Excel Password Remover
Instructions
FAQ
Disclaimer
Excel Password Remover PRO

--------------------------------------------------------------------------------
Recommended links:
Password recovery software (Word, Excel, Outlook, Exchange, Visual Basic modules, Access, Winzip, Lotus 1-2-3, Lotus Organizer, Lotus Wordpro, Backup, Project, FileMaker, Schedule+, Money, Paradox, Act!, Mail, Windows NT)
Instant password recovery (Instant online recovery service for password protected MS Word and Excel files. Free online preview of encrypted file content. )
Visual Basic Password (Instant recovery of VBA-passwords in Office programs)
Excel add-in decompiler (Converts Excel add-ins into normal workbooks)

Have you ever forgotten your Excel workbook or sheet password?
Here you can download a FREE Excel add-in that removes/cracks sheet and workbook password protection in Excel®.
NB! This program can't remove file protection, i.e. if you are unable to open the file, this program won't help you. You could try Excel Key to remove file protection. If you need to crack the VBA-password try this one.
This Excel add-in (password.xla) works fine in Excel 5.0 and above (including Excel 2000, XP and 2003).
This program will remove passwords of any length, also passwords containing special characters.
Download here: password

Feb 23, 2008 | Computers & Internet

1 Answer

CONNECTING VB TO EXCEL


Here is some code that I found in this book:
Microsoft Visual Basic 6.0 Professional, Step by Step.
By Michael Halvorson
Second Edition.
ISBN: 0-7356-1883-6
Code removed for possible copyright issues.

That program in VB6 will open an Excel workbook, and then insert the data into the cells at B1, B2 and B3.
You can change this to have a textbox show up to ask for info to insert into the cells as appropiate.

If you look at www.microsoft.com/mspress/developer and search there, they may still have some code that you can download.

Feb 21, 2008 | Microsoft Windows XP Professional With...

Not finding what you are looking for?

Open Questions:

0 Answers

Hai everyone, I am doing a project on Attendance Monitoring. I have two tables one master table called student and another table called att to store students daily attendance. I have four comboboxes in my form, by selecting the city,area,centre and batch the respective students satisfying this condition has to be displayed in the grid apart from that i have to display another column to mark attendance. I am using datagrid and mark P for present and A for absent. When i finished marking the whole data has to be stored in att table with the current date. The next day again the same class may be selected with the next date and has to be stored again. The problem is i am not able to store each person attendance. Please help me in this regard. The att table contains fields like Code: Student_ID,Date,Attendance The student table contains fields like Code: Student_ID,City,Area,Centre,Batch,Name etc The code that i have written is like this Code: Public ac As New ADODB.Connection Public ar As New ADODB.RecordSet Private Sub Command1_Click() Set ar = ac.Execute("select student.Student_ID,att.Attendance from student,att where City = '" & Combo1.Text _ & "' AND Area = '" & Combo2.Text & "' AND Centre = '" & Combo3.Text & "' AND Batch = " & Combo4.Text & "") Dim count As Integer count = ar.RecordCount MsgBox count Set DataGrid1.DataSource = ar End Sub Private Sub Form_Load() ac.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:v-tablesStudent.mdb;Persist Security Info=False" ac.CursorLocation = adUseClient Combo1.AddItem ("CHENNAI") Combo1.AddItem ("BANGALORE") Combo2.AddItem ("GILL NAGAR") Combo2.AddItem ("CHOOLAIMEDU") Combo2.AddItem ("EGMORE") Combo2.AddItem ("SOWCARPET") Combo2.AddItem ("KOTTIVAKKAM") Combo2.AddItem ("KILPAUK") Combo2.AddItem ("MOGAPAIR") Combo3.AddItem ("RANGA NURSERY") Combo3.AddItem ("V-KIDS") Combo4.AddItem ("1") Combo4.AddItem ("2") End Sub

Jun 27, 2009 | Microsoft Visual Basic Enterprise Edition...

Microsoft Visual Basic Enterprise Edition 6.0 (361-00667) for PC Logo

Related Topics:

580 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18346 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...