Question about Operating Systems

1 Answer

Pls hepl me wit Excel VB integration

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

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

6 Answers

My excel 2010 file .xlsx was damaged or corrupted. how can i repair and getback


Use in-build "open and repair"utility of MS excel to repair damaged .xlsx files. Follow thesesteps to it

  1. On the File menu, click Open.

  2. In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.

  3. 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

1 Answer

Different between MS EXCEL & ACCESS


Hi. MS Excel is for spreadsheet. Very useful when creating accounting documents. MS Access is for database. Very useful when collecting data.

Please visit these links to learn more about the 2 applications:
http://www.blurtit.com/q373300.html

http://office.microsoft.com/en-us/access-help/using-access-or-excel-to-manage-your-data-HA001042918.aspx

http://www.thetechfaq.com/2010/03/14/microsoftaccess-and-excel-comparison/

Sep 03, 2010 | Microsoft Windows XP Media Center Edition...

1 Answer

I want to transfer my data saved in microsoft excel 2007 to microsoft excel 2003


hi

just open your Excel 2007 data in 2007 from the just save as 2003 all date will save in 2003 format

Sep 03, 2010 | Microsoft Operating Systems

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 am trying to use 2003 excel data in excel 2007, but it keeps shutting down my excel 2007. how do i convert the 2003 into 2007 so i can use it on my computer


hi friend see you cant view excel 2003 data in 2007 excel as it is latest version and you will need to install 2007 office in your computer.

Apr 18, 2010 | Operating Systems

1 Answer

I need to print mailing labels imported from excel to word in columnar order instead of in order by rows across the page.


hi Samajane,

I understand the you excel file has data that is stored column wise. Well you can first convert the column wise data to row wise data and then import it to you word.

To convert the column wise data to row wise data.
1.Select the data in your worksheet.
2.Right Click -> Copy
3.Create a blank worksheet.
4.Goto Edit - > Paste Special
5.Check the Transponse Option
6.Press OK.

Now you have converted your column wise data to row wise data and now u can import it to your word and print mailing labels

Dec 14, 2009 | Microsoft Windows XP Professional

1 Answer

Word/Excel - trying to mail merge excel data into word document. Keeps carrying values out rather than following my Excel rounding to four.


Hi. I was pointed to a change in settings in Word that allowed the data to come over as I wanted.


Take care, Dennis

Sep 29, 2009 | Operating Systems

1 Answer

Code for upload data form microsoft excel to sql server


you wan the code for sql loader right? or you want the procedure to do that?

Feb 08, 2009 | Microsoft Operating Systems

4 Answers

Recovery excel password


http://www.straxx.com/excel/password.html

Feb 28, 2008 | Microsoft Windows Vista Ultimate Edition

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?
Operating Systems Logo

Related Topics:

151 people viewed this question

Ask a Question

Usually answered in minutes!

Top Operating Systems Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Prashant  Sharma
Prashant Sharma

Level 3 Expert

1127 Answers

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

Answer questions

Manuals & User Guides

Loading...