[office-suite] Forum Topics

**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 …

I want some help to generate a report in PDF/Doc(MS Word) format . I’m not able to find any module to generated report in doc, except “docx” which I’m not able to comprehend. Actually my actual task is to generate the report in Doc only, but as I’m not able …

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 …

Hi guys, I have a problem I need to make an appointment with some bold text in it. I also want to set a category for it (color)... I heared that it is possible to implict RTF into appointment.body - but I dunno how to do that... My code is: …

Hi. I have written some code that creates an ical file and attaches the file to an Outlook email. Is there a way to create an appointment that appears directly in Outlook calendar as accepted instead of a user having to open the attachment and accept it? Thank you for …

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 …

Hi, First Problem: I have a PHP script that export CSV with Japanese text, for example I download the CSV on the website then save to desktop of my computer and Open it on NOTEPAD... that works fine I could still see all the japanese text OK with no problem, …

Looking for some help in order to increment a cells value by one depending on how many seperate rows there are for a specific instance. Ill try and demonstrate rather than babble. Report 1(Spreadsheet 1) Employee# Reason 123456 Late 123456 Late 654321 Late 654321 Late 654321 Late This example shows …

Using Office 2010 on Windows 7 Pro. On a spreadsheet, I am putting hyperlinks on names that will open another spreadsheet. If I sort the spreadsheet, the hyperlinks will no longer work. Is there a way to keep them so that they will work after a sort. Thanks.

hi everyone i am currently building a program which logs into an email, extracts information like the date, sender, subject, number of copies, and takes any attachments and puts them into a directory, than takes the number of pages of the pdf. i have already built a program which does …

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 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 …

One of the most important things to understand when automating office, is that it's heavily [search]OOP[/search], and therefore you are forced to work with objects. In order to create an object that is external to your application (for example an office application, whereas a button or textbox would be internal …

I cannot open M S Oulook, when click the M S Outlook tab, Outlook window opens and I get the message'The connection to Microsoft Exchange is unavailable. Outlook must be online or connected to complete this action' and further on I get the message "Cannot start Microsoft Outlook. Cannot open …

hi guys, My hard disk was crashed. I some how recovered my data.Now my problem is I am unable to add my mail folder into the my outlook.The file is in .ost format The error is as follows: " The file you chosen is not an outlook data file.you must …

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 …

Hello Everyone! So ive done some searching and havent been able to find what i need. Partly because i'm not sure exactly what words i should be googling! I am wanting to download gmail emails, and then display them in a spreadsheet like format. I know that emails have unique …

I teach a beginners class using Excel. During an examination, some of my students misread the instructions (provided by the department, not by me). These are the kinds of errors only a novice could make. This caused the following two errors to occur. - Instead of just putting data into …

I am new here.. But been lurking for some time. I am now driven mad and have joined. I have Microsoft office 2003 Professional edition. I use for home and some business. Since service pack 3 came out I have been having problems with Spell checker.. Wherever spell checker is, …

I've been putzing around with this for awhile but I need to delete column B (minus the header) when ever it is empty. Does anyone have any idea on how to do this. If xlWorkSheet.Range("B2:B65565").Value = "" Then Dim rg As Excel.Range = xlWorkSheet.Columns("B") rg.Select() rg.Delete() End If

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 …

Hey all, i have a problem here, i want to know how to send value from datagrid to excel plizzzzz.. help me

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 i am open a word file 2007(.doc file) in a rich text box through open dialog box. It works fine but images and bullets are not shown in a rich text box. i want to open open word file with images and bullets in a rich text box. I …

Hello everybody, I have a sheet containing historical exchange rates for AUDJPY (2 columns, Date and Price). I also have another sheet containing hypothetical AUDJPY trades (4 columns, Start Date, End Date, Start Price and End Price). What I would like to do is find the maximum value of a …

I have a rather large Excel spreadsheet. What I would like to do is "fix" the leftmost or topmost columns on the screen as I scroll horizonally or vertically. So, in other words, if I have 10 rows of various accounts with 200 columns each, I want to be able …

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 guys, I need your help. I tried to find out sth via google, no luck. I need to create an appointment "on behalf of" I know how to make an appointment in my personal calendar. But how to do that in other calendar (where I have access rights)? Thx …

I have a client with a reasonably modern computer. Upgraded from Vista to win 7 32 bit (it wont run 64!) all went OK and registered. I tried to reinstall the legitimate version of MS office from the purchased disc CD (2007) and it runs the set up but then …

I'm writing the following bits of code for a SaveFile Dialog box in Visual Basic 2010.NET. The code works well as the XLSX file is created and opens in Microsoft Excel. However, the problem that I am having is that if the program overwrites a file, the user is getting …

hi everybody! i already know how to save in excel using openfiledialog. but what i want to happen is that when i save another file, i want it to be saved in my existing file but in a different sheet. can you guys help me? this is my code for …

Hi i am open a excel file and it automatically open first two cell A1,B2 in two text boxes. now i want how to open different cells in different click of button. i am using this code- [CODE] OpenFileDialog openexcel = new OpenFileDialog(); openexcel.Title = "Mayank"; openexcel.InitialDirectory = @"c:\"; openexcel.RestoreDirectory …

[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 …

Hi, I have a program that needs to create a downloadable excel template with the following headers on the first row named, name, age, gender. And I also want the template to only have 1 sheet on it. how can I create a sample template using vb.net code? Thanks

Hi, I just have this program that needs to create a downloadable template for the excel file that will be used later in my program, now I have this templates in my server and I think that i'll just import this file first and then put it in the data …

Good Day! I've created a rudimentary program that takes multiple .csv files and creates one merged .csv file. What I'm looking to do is after merging the file into one, I want to convert it to an .xls file, however, when I do this the converting is not correct. Here …

Hi, I have this program that uses OLEDB connection to import excel file to data table then use it in other functions. Now I have this question: What are the possible limitations of OLEDB when it reads the Excel file. The File is on xls format, and I want to …

Hi, I have this code that will import the excel sheet to the datatable then inserts it in the database, but I have this problem. I have set the HDR to yes so that the first row will be considered as its header, but the problem now is that if …

The problem that I am facing is that Word 2007 is adding spaces in a mail merge when there isn't a value from an excel document. <<FirstName>> <<MiddleName>> <<LastName>> I've placed spaces in between the template place holders to seperate the names. However, when a record doesn't have a middle …

please find attached screen prints on how my data looks on XL sheet (as-is). With the help of Macros, I need to cut every 4 columns and need to paste it in a different XL TAB. I have attached another Attachment which gives how my data should look once Macro …

Hi everybody, In Excell 2010 when a cell is defined as number we can round up the number with the round() function. The increase/decrease decimal should not round up but it does! A number of 4.7380 converts rounds up to 4.74 when I decrease the number of digits shown to …

Hello people. I want to suggest you some must-have programs. 1. Power ISO. It is the best program for using "images". It is easy to use and powerful program. You can easily mount, make dvds from .iso, .nrg etc. [url]http://www.poweriso.com/[/url] 2. I want to suggest you Opera for browser. It …

I have an application that needs to know how many excel rows are in a worksheet before they are imported into my application. at the moment I am asking the end user to enter this into a text box, but would like my application to do this can anyone suggest …

How to deactivate updating of microsoft office 2010