excel

Hello All, I have a third party Excel Application, which have a VBA code, I want to fill the Excel Application from VB.NET. I want to update a VBA Boolean Variable during the Data Filling from VB.NET, is there is any way to do it?

I want to use a loop to check to see if there is any data in the first column of a row, if there is data I want it to go to the next row and check again, once it finds an empty row, I want it to right data from an array I have created. I understand the concepts of loops and incrementing to make...

I am using the following code to export a datatable into a Excel spreadsheet. I am having issues trying to set the AutoFilter on for the top row. With the code as it stands does turn on the Autofilter , however it gives an error "Unable to Set the Autofilter property of the range class."...

I'm setting up a console application that ... (I'm using late binding to manipulate Excel) 1. Executes a stored procedure that populates a SQL table for reporting purposes. 2. Opens an Excel Workbook. 3. Refreshes the Workbook. 4. Saves the Workbook. 5. Closes the Workbook. 6. Sends the...

I have an RTD server with manual strings defined as topics that I use to pull data into Excel but I would like to define fields that I can access via my Vendor's VB.NET API. Any articles/suggestions you guys could provide to put me in the right direction? Much appreciation in advance.

Code peepz, I'm writing excel files from vb. That's no problem... But i have problems with closing my excel services in my task manager. Before i wan to close my pc i get prompt with the question to save workbook1,.... You can see my code can anybody tell me where i don't close my excel...

Hello, I'm all set for querying my SQLServer database, that's no prob, but how do I access individual cells of data in a workbook sheet. If, for example, I had a workbook and one of the sheets was contacts with Names, addresses, etc - how would I access the workbook called MyWorkbook.xls and...

Hello folks! I'm new to VB and I'm working on a project for work. I'm a 911 Dispatcher and currently we have about 5 books of information that we have to go through by hand to check for things. I'm trying to make an app to speed up the process. So far what I've got is this: I've made a google...

I have got some VB.net code that opens up an excel spreadsheets, checks all the vba modules and finds & replaces a certain string for another. My code just hangs though if the Excel file 'Contains Links' and I have to press Continue on the m up message before my code will continue. Is there...

I am looking to have my website generate a simple excel spread sheet on the client side when clicking a button. I don't know if it would be best to open the spread sheet on the client side and then write to it or create it on the server side and ask the user to save it locally. I've been looking...

I'm hoping someone can help with a problem I'm having getting multiple values out of an XML node. I'm trying to use vb.net to read a sydi xml document and write the requested information to excel. the XML portion I'm having issues with is this <computer> - <storage> - <drives name="SCSI Disk"...

Using Excel 2007 and Visual Studio 2003 This function throws a target invocation exception Private Function ExcelNewSeries(ByVal sercol As Excel.SeriesCollection) As Excel.Series Dim series As Excel.Series series = CType(sercol, Object).GetType.InvokeMember("NewSeries"...

I'm trying to make an vb.net project which generates data and then exports it to an excel spreadsheet complete with a chart representing the data. I have Office 12 (Including Excel 2007) as well as windows SDK. All the tutorials I've seen which explain how to create/modify an excel spreadsheet...

LENEXA, KS, June 22nd, 2010 - Today, SpreadsheetGear LLC announced the immediate availability of SpreadsheetGear 2010. With one safe managed assembly, SpreadsheetGear 2010 enables developers to easily add scalable ASP.NET Excel Reporting, dynamic Dashboards from Excel Charts and Ranges...

I am trying to create a program which will output data from a database and produce and Excel file with data and a chart. I have been able to create the Excel file and the data to go in. However, I have not been able to create the chart as I want to. What I am doing is create a workbook as...

Hi, I am creating an application which uses OleDb to connect to an Excel spreadsheet and read the data into DataTable. The problem that I am having is that some of the columns I am getting are coming up blank, I've managed to narrow down that this is because that the first few lines for that...

Hi all, sorry to bother you with a total beginner's question. :( I'm currently working on my (business) master's thesis... the topic is capital budgeting tools to manage major investments for a European energy supplier. So far the company has used MS Excel for calculating relevant data to...

There seems to be some inconsistency between the Excel VBA and the Excel Dot Net object models. I implemented auto filtering via the following code in Excel VBA: Selection.AutoFilter However, when I tried to do the same thing in Dot Net, via the following code, the AutoFilter object was...

:confused:Hello All, I have the following SQL query that runs against an Excel datasource and I'm getting the infamous "No value given for one or more required parameters" because of a join. It's erroring on the where t1.[trnVendorName] = v.[Vendor] part. It is acting like it can't see the...

I have a form that silently interacts with Excel by adding cells based on user input. I completed the solution and it talks with Excel perfectly, updates the records and cells in Excel wonderfully. After completion, I sent the requesting user the completed product and he was happy. The user...