629 Topics
 | |
| | I was told in an email to revise a document and submit the revised document "in clean and track change version." Not knowing what this meant, I asked for clarification and the sender explained that "track changes shows the change you made and a clean copy means you have accepted … |
| | i have a problem with execute the excel sheet in java code and also problem with execute asa same as pivot table in java |
 | I am trying to create a powerpoint quiz that tallies the scores, provides the results e.g. 95 out of 100 and the percentage %, then writes the users name and results to an excel spreadsheet. Oh, and all this has to be done using Office 2007 products. Can anyone help? … |
| | Office Addin Hello all I've searched Google for hours, with no success. I have developed an Office 2010 addin application. The application adds another form to Outlook.(Form Region) The application (let's call it A) works great! I can send emails from my Outlook with this form (filled or not filled … |
 | My process is to multiply the given points in B8, D8, F8, H8, J8, L8, and N8 to A3, B3, C3, D3, E3, F3, G3 respectively. this procedure is to be processed in C8, E8, G8, I8, K8, M8, and O8. after multiplying, the process should perform =sum(C8,E8,G8,I8,K8,M8,O8) to P8. … |
| | I am trying to program the last part of an application which needs to take data from an Excel sheet and add it to an Access table. I'm using Excel 2003 on XP. Any and ALL help is appreciated. The problem I'm running into seems to be on connecting to …  |
| | Helloooo Firstly, ive done a bit of googling, and found a few articles relating to my problem. None seem to help though. I require a simple method of acquiring the "Page Number" of the selected cell. range1.Information(wdActiveEndPageNumber) Something like this, does not work. Even though i read that it does. …  |
| | Firstly, im not sure if this is the correct location for a VBA question? Please move if necassary. This is my first major project using VBA - Ive previosuly used vb.net quite alot, and still adjusting to understand both, and the differences. My question is: I have a folder with … |
| | **Hello all** I've searched Google for hours, with no success. I have developed an Office 2010 addin application. The application adds another form to Outlook.(Form Region) The application (let's call it A) works great! I can send emails from my Outlook with this form (filled or not filled with data … |
| | Hi everyone I currently have a program that imports data from an excel sheet that is already made. The data also creates a chart. I need the chart to load into the program and I think that the only way to do that is by importing it into a picturebox. … |
| | I am trying to change the order of how my excel worksheets tab appear in my workbook. I have a .net app that parses and pulls data from sql and exports it to excel. Currently it spits out 5 tabs and the Summary tab is in the middle. I want … |
 | Recently, I meet a problem that I need to insert header and footer in excel with C#, I use the following code: Worksheet sheet = workbook.Worksheets[0]; sheet.PageSetup.FullHeaderString = "E-iceblue"; sheet.PageSetup.IsPrintHeadings = true; sheet.Visibility = WorksheetVisibility.Visible; sheet.PageSetup.LeftFooter = "everlasting"; But when I launch it, the header and footer do not appear … |
 | i created a report which exports to excel. it exports just fine. what i want to do now is merge the consecutive cells in a column which have the same values. how do i do this? please help me. this is code that generates the excel body: Protected Sub generateExcelBody(ByVal … |
| | Hi guys Basically im making a application that holds certain data that is read into the app, those readings are sent to excel and make a grapgh, which can be viewed on to the same page in the application. Each different sections data is put on to a seperate "sheet" … |
| | Okay, I am 50% toward having this figured out, but there are a couple of concepts that are new to me here and it is throwing me for a loop. I am reading an Excel file into VB.NET. There are 4 columns containing dollar figures of varying amounts. Here is … |
| | dear friends following is the code for export data from data grid to excel .. problem which i m facing that .. i could not export the last coloum values.. kindly give sulotion.. `Inline Code Example Here` Private Sub btnExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExcel.Click Dim …  |
 | Hey guys, i need to know if i can find a FREE excel like datagrid that will allow inline editing and has drop down boxes for some fields. Also filed may be able to collect their default data from a session variable. I have tried this: [url]http://azgtech.wordpress.com/2010/08/01/jqgrid-php-datagrid/[/url] Thanks, Marais |
| | hi , i have a textbox control in one sheet and a range of data in another sheet in the same file. how do i copy the range of data in paste it in the textbox control? appreciate a reply thanks |
| | Hi everyone I have an excel sheet and in this sheet i have a column with plain text data in list.. the data is just like (sample) 123131 | 564656311 85463 | 965132 3257| 93154911235 I need to create two columns from this column.. 1. i need to convert data … |
| | I am currently running Windows 7 Home Premium SP1, AMD FX-6100 Six-Core Processor 3.3 GHz, 8.00 GB RAM, 64-bit OS. My problem occurs while running Excel and Word 2007. However, all systems with 2007 or 2010 office have the same issues in our office.(Some are XP, Windows 7 and one … |
| | Well, when almost finishing this tutorial: [INDENT][/INDENT][url]http://msdn.microsoft.com/en-us/library/ff677562.aspx[/url] I found a problem on connecting the Add-in to the database, and so the lobInstance can´t be opened: [url]http://i.stack.imgur.com/AFzie.png[/url] This is the error code. (in fact the error message was being popped out when the Excel 2010 client starts, but I commented the … |
| | is it possible to access an access database without ms office or just using references or .dll  |
| | Hello everyone. I have the following issue: I have a Windows XP computer with excel 2003 installed. we use several automation robots using excel. everything works fine, files area created and all that. but we have a problem. for some reason the document recovery pane of excel is getting filled … |
| | Hello everyone, i have the following problem and I come here looking for some advice. I am using c#, but i have a dll that creates the excel file in Visual Basic. i have a datagridview and the information there is exported to excel file. No problem there. the problems … |
| | I have searched and nothing that I have found hits directly on what I am looking for (or maybe my searches have not hit on the combo of words). In C# I have created an Excel sheet, using Interop.Excel, in which I insert some data and create a chart. This … |
| | Hi there. I have a few hundred/thousand macro enabled spreadsheets that need to be uploaded to a database. The spreadsheets have a button that copies the data over to the database and it prompts the user for a username and password in order to do so (same for all files). … |
| | Hi, I need to create an html page to export some information. Currently, by using java, i've exported information to excel. But now, I need to export the information in HTML page using java.Is there any APIs I can use? Thanks.  |
| | Hi there, I was trying to edit a excel document and save under different name and my coding for this is as follows. [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Open Dim MyExcel As New Excel.Application MyExcel.Workbooks.Open("C:\Test\WalkAir.xlsx") 'Extract MyExcel.Sheets("sheet1").Activate() MyExcel.Range("A99").Activate() MyExcel.ActiveCell.Value = TextBox1.Text MyExcel.SaveAs("C:\Test\alkAir.xlsx") MyExcel.Workbooks.Close() …  |
| | Hi, I have attached a printscreen version of my excel template here, Now I just want to know, using vb.net code, on how can I import this data from a specific cell, including the header itself so I can insert it into mysql database. Thanks |
| | [CODE]Imports System.Data.SqlClient Imports System.Data.OleDb.OleDbConnection Imports System.Data.OleDb.OleDbCommand Imports System.Data Partial Class Main Inherits System.Web.UI.Page Public strSQL As String Public strConn As String = ConfigurationSettings.AppSettings("strConn") Dim objConn As SqlConnection Dim objAdap As SqlDataAdapter Dim objCmd As SqlCommand Dim objReader As SqlDataReader Private Sub cbfGenerateTable() Try objConn = New SqlConnection(strConn) strSQL = "SELECT …  |
The End.