Question about Microsoft Windows XP Professional With Servise Pack 2 (e8503040) for PC

1 Answer

CONNECTING VB TO EXCEL

I have designed a Attendance Sheet in Excel. i want to connect itthrough Excel using Microsoft Excel 11.0 through References.

Posted by on

  • WallaceJ Feb 22, 2008

    Thanks

  • tjayarani Mar 03, 2009

    I don't kno how to connect vb 6.0 with ms excel 2003

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Scholar:

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

  • Expert
  • 148 Answers

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.

Posted on Feb 21, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How to open excel sheet in different window?


While one spreadsheet is open in Excel, open the second spreadsheet as follows:

Go to Start, Programs, Excel (or however you navigate to Excel). Then in the new Excel window select FILE, OPEN, then your 2nd spreadsheet.

Mar 29, 2011 | Microsoft Windows XP Professional

4 Answers

How to convert 2007 excel sheet into 2003 excel sheet


if you have excel 2007 you can save the file into excel 2003 compatibility

if you have excel 2003 need download compatibility pack from this page
http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
install it and success!

Feb 22, 2011 | Operating Systems

2 Answers

What is exel sheet extension in office 2010 ?


Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Operating Systems

1 Answer

Describe the each part of microsoft excel 2207


anmolsxn_0.gif
Parts of the Excel 2007 Screen

Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

1 Answer

How to create VBA programme in excel?


Use macro editor. And modify it.
You need to create a new Excel Based VB Program, then install Visual Basic 6.0 or higher version and use the MS Excel ActiveX control.

Aug 10, 2010 | Operating Systems

1 Answer

I have to list a number of name, phone number and email address together. How do I do that? And what program do I use?


You can use word or excel depending on how you want the finished product to look. In excel you can use grid lines to make easier reading. The cells or boxes are adjustable in size so you can change them as you go. If you naver used your excel or word your programs will have a tutorial in it, you should watch this and it will teach you the basics so you can get started and experiment as you go if you like. HP and Microsoft also offer free on line classes if you like what your doing and would like to take advanced classes to learn more. Have fun and type your paper it will be easier than you think.

Oct 14, 2009 | Microsoft Windows XP Home Edition

2 Answers

How to coonectivity excel sheet with visual basic with coding


Here is ur solution :
http://support.microsoft.com/kb/257819

Thanks,
Mukund
www.Einfochips.com

May 20, 2009 | Microsoft Windows XP Professional With...

1 Answer

Microsoft excel


I'm not sure what you mean exactly...

Do you want to sort an existing excel worksheet?
Or do you want to change a cell value depending on the class of students.
You can use if for the latter.
Otherwise just use sorting in excel.

Please explain what you want to do exactly...

May 24, 2008 | Microsoft Windows XP Professional

1 Answer

Pls hepl me wit Excel VB integration


you can use a OLE object that is available in VB as standard object. Drag the tools to your form that your creating and it will ask for create or link existing object. so now browse to the excel sheet and embed it into the VB form or use run time for manuplating the cells and other info in excel.

Mar 25, 2008 | Operating Systems

Not finding what you are looking for?
Microsoft Windows XP Professional With Servise Pack 2 (e8503040) for PC Logo

851 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Operating Systems Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Scott Fryer

Level 2 Expert

80 Answers

Carlos L. Burgos
Carlos L. Burgos

Level 2 Expert

508 Answers

Are you a Microsoft Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...