Question about Microsoft Windows XP Professional With Servise Pack 2 (e8503040) for PC
I have designed a Attendance Sheet in Excel. i want to connect itthrough Excel using Microsoft Excel 11.0 through References.
Here is some code that I found in this book:
Microsoft Visual Basic 6.0 Professional, Step by Step.
By Michael Halvorson
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
Tips for a great answer:
Mar 29, 2011 | Microsoft Windows XP Professional
Feb 22, 2011 | Operating Systems
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
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.
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).
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.
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
Feb 21, 2011 | Operating Systems
Dec 11, 2010 | Operating Systems
Nov 15, 2010 | Microsoft Windows XP Professional
Oct 14, 2009 | Microsoft Windows XP Home Edition
May 20, 2009 | Microsoft Windows XP Professional With...
May 24, 2008 | Microsoft Windows XP Professional
Mar 25, 2008 | Operating Systems
851 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: