Question about Operating Systems
Hi.. I am doing my chartered accountancy.. during my audits, i come across thousnads of excel data, which i am now looking to access through VB and do some simple programming wi that data. so pls help me wit a way to access my excel data with VB... expecting your reply soon.. thanks
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.
Posted on Mar 26, 2008
Tips for a great answer:
Use in-build "open and repair"utility of MS excel to repair damaged .xlsx files. Follow thesesteps to it
On the File menu, click Open.
In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
Click Open and Repair, and then choose which method you want to use to recover your workbook.
Most probably your problem may get fixsuppose due to any reason it can't fix your problem then use thirdparty excel repair softwarehttp://www.stellarinfo.com/excel-recovery.htm
Dec 20, 2010 | Operating Systems
Sep 03, 2010 | Microsoft Windows XP Media Center Edition...
Sep 03, 2010 | Microsoft Operating Systems
Apr 18, 2010 | Operating Systems
Dec 14, 2009 | Microsoft Windows XP Professional
Sep 29, 2009 | Operating Systems
Feb 08, 2009 | Microsoft Operating Systems
Feb 21, 2008 | Microsoft Windows XP Professional With...
151 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: