Question about Computers & Internet

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

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:

2 Answers

Delete blank rows in excel using visual basic


have you tried to read in one file and write back in excel format only the non-blank rows?

Mar 11, 2009 | Sony Playstation 3 (PS3) Console

Tip

How to Backup Your Outlook Contacts to Excel File?


Microsoft's Outlook is integrated into Microsoft Office 2000, 2002, 2008 and Microsoft Exchange Server. Outlook is complete e-mail manager by which you e-mail, calendaring, and contact management. Outlook enables you to filter and organize e-mail messages, integrate and manage e-mail from multiple e-mail accounts, personal and group calendars, contacts, folders, and tasks.
Using Import and Export feature in Outlook, you can create the full backup of outlook contacts. Because without backup yon can lose your e-mail accounts data any time due to virus, power failure and hard disk problem.
Follow the given steps to export your outlook contacts to Excel file:
Click on Start button, go to Program then click on Microsoft Outlook to export the contacts.


Now go to File menu and click on Import and Export option. Choose Export to a file as show in the below figure then click Next.
export-computerfreetips.gif Now on next dialog box, choose Microsoft Excel and click Next.
export-computerfreetips1.gif Select the Contacts Folder you want to backup to Excel file as shown below then click Next.
select-computerfreetips.gif Choose a name and location where to save the Excel file by clicking Browse button, then click Next.
file-computerfreetips.gif Click Finish to start the back up procedure which may take little time depending on how many contacts you have.

on Jan 29, 2010 | Computers & Internet

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 Computers & Internet

1 Answer

Excel


VBA is an integral part of Excel. Search help for VBA, and you should be guided to the proper place. Please post back if you need more help, otherwise thank you for using and rating FixYa!

Jul 08, 2008 | Microsoft Computers & Internet

1 Answer

Vb project


One of three ways:
1 make the table using vb creating a Bload screen.
2 using the visual data manager.
3 import a windows access or excel data base table.

Try the data wizard, easiest to use and U can program the program to manipulate the data in the tables.

May 29, 2008 | Computers & Internet

1 Answer

Excel formula


The IF() is the wrong one to use. Use "Iif()", as in:

=IiF(A3='Audit Exception Register'!B:B, COUNTIF('Audit Exception Register'!P:P,Y), 0)

See:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=799

Caveat about using Iif(), one that doesn't probably apply in this case, but keep it in mind: Don't use Iif when trying to return the values of "real" objects. Examples of "non-real" objects in the VB/A world are:

String
Integer, Double, etc... all the numeric "objects"
Boolean

These are fine to use in IIf() statements. If however you will be returning some value that is part of an object, as in:

Iif(x=2, myObject.getSomeVal(), 0)

You run the very real risk that is myObject is null, your program will simply stop running. Iif() will NOT return a null error/exception; it will in fact just stop. This is a bug in the VB interpreter and/or in the Iif() function itself.

I am referring here to classic VBA (ie, pre-VB dot-Net). How .NET handles such cases, I don't know.

Mar 07, 2008 | Computers & Internet

1 Answer

Export data in excel shld yoeet through VB


When i first figured out how to pull data from SQL and put the results in an excel file i referenced these two articles....
Reading and writing excel file using VB.NET (http://www.codeproject.com/KB/vb/Work_with_Excel__VBNET_.aspx)
Get the Values From DataBase and Stored into excell Sheet (http://www.codeproject.com/KB/vb/Getvaluesfromdatabase.aspx)

This is the code i ended up using.... (check out those links to see how you need to import the ms office excel reference file with visual basic)

Const stcon As String = "Provider=SQLNCLI;server=xxxxx;database=xxxxx;uid=xxxxx;pwd=xxxxx;DataTypeCompatibility=80"
Dim stSQL As String = "select * from scs_rate_class_money where irate_book = 124 and snew_used = 'U' and sclass = '2' and splan = 'T4' and sopt_code = 'F1'"
Dim cnt As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim fld As ADODB.Field
'Open the connection.
cnt.Open(stcon)

'Open the recordset.
With rst
.CursorLocation = ADODB.CursorLocationEnum.adUseClient
.Open(stSQL, cnt, ADODB.CursorTypeEnum.adOpenForwardOnly, _
ADODB.LockTypeEnum.adLockReadOnly , _
ADODB.CommandTypeEnum.adCmdText)
.ActiveConnection = Nothing 'Disconnect the Recordset.
End With
'Close the connection
cnt.Close ()
Dim exp As Export = New Export()
Dim xlApp As New Microsoft.Office.Interop.Excel.Application
Dim xlWBook As Microsoft.Office.Interop.Excel.Workbook = xlApp.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet )
Dim xlWSheet As Microsoft.Office.Interop.Excel.Worksheet = CType(xlWBook.Worksheets(1), Microsoft.Office.Interop.Excel.Worksheet)
Dim xlRange As Microsoft.Office.Interop.Excel.Range = CType(xlWSheet, Microsoft.Office.Interop.Excel.Worksheet).Range("A2")
Dim xlCalc As Microsoft.Office.Interop.Excel.XlCalculation
Dim i As Short

'Turn off Excel's calculation.
With xlApp
xlCalc = .Calculation
.Calculation = Microsoft.Office.Interop.Excel.XlCalculation.xlCalculationManual
End With
'Write the fieldnames.
For Each fld In rst.Fields
xlRange.Offset(0, i).Value = fld.Name
i = i + 1
Next
'Populate the range.
xlRange.Offset(1, 0).CopyFromRecordset(rst)
'Close the recordset.
rst.Close()
'Make Excel available to the user.
With xlApp
.Visible = True
.UserControl = True
'Restore the calculation mode.
.Calculation = xlCalc
End With
'Release variables from memory.
fld = Nothing
rst = Nothing
cnt = Nothing
xlRange = Nothing
xlWSheet = Nothing
xlWBook = Nothing
xlApp = Nothing

Jan 03, 2008 | Computers & Internet

1 Answer

Excel Loading Problem


try using OpenOffice.org instead of Microsoft Office. It should work and it's free.

Dec 07, 2007 | Microsoft Excel 2000 Step by Step...

1 Answer

Auditing in Excel


Dear raajee, Auditing in excel if fairly easy. It can be find by pressing Tools > Formula auditing and then further options. Complete introduction these options are availible on this tutorial:

http://exceltips.vitalnews.com/E037_Auditing.html

Please press solved if that has helped you.

Nov 14, 2007 | Microsoft Excel for PC

1 Answer

Import excel sheet in vb.net 5


you have to make link in you vb then you can save the xls files on same format

Oct 08, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

153 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18385 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

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

Answer questions

Manuals & User Guides

Loading...