[office-suite] Forum Topics

Okay, so I've been searching the internet for hours trying to find the solution to my problem. Many came close, but didn't describe exactly what I want to do. I have an excel file that displays the names, locations and other information about certain servers for work. I want to …

i have pivot table in a excel sheet and it pulls data from a CRM database. when a user clicks any data in the pivot table it creates a new worksheet showing all the data that is related to that data selected. I want to know is how can i …

have pivot table set up in report format with various fields from a CRM database. I want to clear blank data in the cells when the user click in the pivot table cell to open a certain cell to view the data that is whtiin the pivot table. it creates …

I have a spreadsheet for each month of 2010 (Jan-Dec) that is used to track church members donations by month. Under each month I have the last name, first name and weekly donation with the monthly donation total at the end of the row. I would like to output on …

This is my code : [CODE] icrosoft.Office.Interop.Excel.Application(); string filePath = Server.MapPath(@"~\\Staf\\TestLucene\\" + strFileName.ToString()); Microsoft.Office.Interop.Excel.Workbook workbook = application.Workbooks.Open(filePath, Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing, Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing); int numSheet = workbook.Sheets.Count; for (int num = 1; num < numSheet + 1; num++) { Microsoft.Office.Interop.Excel.Worksheet sheet = (Worksheet)workbook.Worksheets[num]; Range excelRange = (Range) sheet.get_Range("A1", "H10"); object[,] valueArray = (object[,])excelRange.Value2; for …

good evening everyone.. im a student and currently taking my thesis...im having a problem with creating a excel file with vb... the thing is I need to open the excel file inside the form in vb.net... Anyone please need help...

hi, i've got error like this : CS0012: The type 'Microsoft.Office.Core.MsoTriState' is defined in an assembly that is not referenced. You must add a reference to assembly 'office, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. whats wrong??

Hi All, Found your great site whilst looking for alternative ideas to fix problem that has arisen of late. I run Microsoft Outlook Pro 2003 (not exchange server) and recently I have had an increasing amount of problems with Outlook. It would appear that I have a corrupt section of …

have pivot table set up in report format with various fields from a CRM database. I want to clear blank data in the cells when the user click in the pivot table cell to open a certain cell to view the data that is whtiin the pivot table. it creates …

Hi all, thanks in advance for your help. Is it possible (and if so how:sad: ) in Excel (using VBA or whatever easiest) to have 2 worksheets A and B where worksheet B is atomatically updated. A bit more complicated tho!! I enter data into A, and B takes that …

Have a table in column a i have a list of part numbers p101, p101, p102, p102, p102, p103, p104 etc part no alternative p101 a178 p101 a196 p101 a192 p102 a135 p103 a165 p103 a145 p104 a179 i need to have it like this but i cant work out …

Dear all, I'm a newbie Outlook Add-in and I have developed a small Outlook Add-in, but now I have an issue with the Add-in. Sample source code is bellow: [CODE] using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Xml.Linq; using Outlook = Microsoft.Office.Interop.Outlook; using Office = Microsoft.Office.Core; using System.Windows.Forms; …

Earlier this evening I had a problem that ended up requiring me to do a fresh install of Windows XP Pro with service pack 2 onto my computer. I did not format, rather I installed over the current and problematic install. I've done this a number of times in the …

I'm using ASP to dynamically generate an XML file (for an RSS feed) that pulls information from a SQL DB. Users input the data into the DB using a UI that is a straightforward html form. However, there is a textarea field in that form in which most users seem …

I have a data in list at vb.net and i want export to Excell. I have tried the code from Jx_man in thread "Export Data from listbox to Excel" , but it can't worked. Dim MsExcel As Excel.Application ---> Error Statement is not valid in a namespace I use Microsoft …

Got a problem with after upgrading excel from 2007 to 2010, and after the upgrade, when double clicking an excel doc to open it, excel does not open, however, you can open a blank excel doc and then open it from file menu..

[url]http://rapidshare.com/files/370940756/commands.jpg[/url] [url]http://rapidshare.com/files/370940682/toolbar.jpg[/url] My question is that is it possible to have the above two options in Visual Studio Tools for Office (outlook 2007). I am trying to build custom toolbar with lots of mail items for templates or is there a way of building the whole lot in outlook as …

Today I configure My Ms Outlook 2007 . but when I downloaded the email from Pop3 Server To my Ms Outlook 2007 . I Did not get my all email from Gmail .i have only get One week email Only .But I want to download my All Email from Gmail …

I'm having a problem with line spacing. When I c/p text from Notepad or Jarte to some places, such as an Internet Marketing article marketing tool I'm using, when I save it, the paragraph spacing looks like double. For some lines, the cursor skips right past them. I checked the …

hey guys where can i find free office 2010 ribbon for vb.net i found ribbon for c# but nothing for vb

this is my code.. i can upload everything (image, pdf, doc, ppt, xls, text), but i can upload file with Microsoft Office 2007 (docx, pptx, xlsx).. whats wrong with my code? can u help me? Please?? [code] DMSDataAccess db = new DMSDataAccess(); Dokumen doc = new Dokumen(); Versi versi = …

Have new iMac w/ OS 10.6.6. Installed older version of Excel (2004). Worked fine. Opened files, worked on them, no problem. There are 5 files, though that won't open. Tried double-clicking and get a "flash" of the loading bar but nothing opens. Went to menu bar: File, Open, find file …

Hi All, I am trying to output an excel workbook that I created else where in the program through a Response.Write() call. The issue I am having is that when I call the Response.Write(); it shows the download dialog for the excel file which it is supposed, but when opened, …

Hello guys I am a newbie so please don't freak if you find this question stupid or easy I have some data in CSV format, which I want to bring into Excel, and based on that data, I have to create graphs in PowerPoint. I searched on Google and everywhere …

Hi All, I have a small problem that I am trying to solve...It regards storing string values in an array and outputting them to a .csv file. As you know the .csv file accepts inputs delimeted by commas ",", however the arrayed values are also delimeted by commas therefore $arr[$i]="1,2,3"; …

Hi All, I have an application written in VB.net for batch print jobs. As part of the application, the user selects two printer trays to use to print the batch to (one plain paper the other coloured for coversheets and batch seperators) I had this working until we upgraded our …

Dear Experts please help and support: Scenario: 1. 4 excel sheet (same structure) stored on 4 different computers attached to a network… 2. 1 master sheet (same structure) as other 4 sheets stored in my PC... Objectives: 1. Want to consolidate into one master sheet that is stored in my …

Dear All, i was wondering if there was another text editor than open office as is not MS office compitable

Hi, Is there any way I can add a footer to rtf with name, page no. and date using c# and word tags? Thanks

Hi I am using Pastel Partner V11 - runs Pervasive SQL - i would like to query the data using Microsoft Excel Query - please can some-one help me : 1/ set up the ODBC connection - on a network 2/ query the database Thanks very much

I'm having exactly the same problem! I have a brand new imac (OS 10.5.2) and brand new office 2008 but everytime i try to open the drawing toolbar it freezes and i have to force quit. It doesnt freeze for anything else. The same thing happened on my last mac …

My Excel 2008 literally freezes after one click into a cell. I updated my Mac and I updated my Microsoft Office Software. Please Please Please Help! I really need to get it to work :( -Sarabeth

Hi, I want to save datagridview data in Excel sheet as per user spcify the location for that I write some code but It's not working properly. If I spacify the location in the code then It alway overwite the data on previous data. In Savedialog Box when I spcify …

hi all, i am a newbie to visual basic .net i have a vb.net database that has 3 textboxs that go to a listbox and also store in a database. i was wondering if i can extract the data from the listbox to excel like a csv file or something …

I want to bring data from certain cells in an Excel workbook into a datatable. The Excel is 97 - 2003 and is in \Box_zero.xls. The code snippet below gives an error "Could not find installable ISAM". From what I see in the literature, this error often means that there …

I’m trying to automatically save an excel file to pdf file using visual basic. So, I will manually open the excel, upon opening the excel file, it will run code to calculate a daily totalizer (this I have functioning) as soon as this code finishes, I want the excel file …

Hi everybody! I'm trying to solve a problem on excel. So it's the following. I need to create a timer where it adds 3 to the variable final each 30 seconds . . This is already done. Now it needs to create an excel sheet and write the value of …

i want to save the export excel that i made workbook.SaveAs("MyExcelWorkBook.xls", Excel.XlFileFormat.xlXMLSpreadsheet, missing, missing, false, false, Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing); where i tell the place to save there?

Hello, I was just wondering if anyone knows of a way (or if it is possible) to change the current time display in outlook 2003 from the highlighted orange area that is on the main day and time bars to maybe having a bar that moves with the current time …

I downloaded Office 2010 Pro but when I try to start Outlook, it looks for a path that does not exist on my new computer. All other Office programs work well. Can someone advise me how I can reset a correct path?

Hi everyone! Imagine that i have a timer that each 30 seconds it adds 3 to the variable final. Variable final is shown on excel sheet when user press "Export", on cell [5,2]. I added this on the timer: [CODE]numero++; if (numero == 5) { numero = 0; final += …

Okay so after many hours I finally figured out how to read data from an excel file but now I am running into a problem here is how I read in data [CODE] Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); Workbook excelFile = excelApp.Workbooks.Open(filePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, …

I am using Windows Vista Business and Microsoft Office 2007 on a couple of computers. When transfering a document (for example a word doc) from a computer to the other, it sometimes happens that the source document is not identical with the destination. The main problem is that certain things …

I was able to find a few different threads that talk about using Excel in VB.net, but none seem to help me. Here is what I'm trying to do... I do not want the standard excel toolbar to be usable. I have a form that opens an excel file with …

Hi everyone! For some time that i don't post here a message on the forum, i've been a little out of the lineup due to school, but now that the holidays are almost start i will learn some things new :) So the problem is . . I created a …

I have been working on several plugins for office. One for Word, one for excel. They are working fine on the developer system however when I try to install the Word plugin on any other machine it doesn't appear to register with Word at all. It isn't listed in the …

This is the strangest thing I have seen. Computer running Vista 32, Office 07. User reported strange printing. Some PDF's would print, others not, some Excel files would print, others not. Same for Powerpoint files. This computer prints wirelessly to a Ricoh network printer on a domain. Throws an error …

Source: [U][url]http://www.lost-password.net/products/passwordrecovery.html[/url][/U] Do you have a outlook e-mail? Microsoft Outlook 2010 offers premium business and personal e-mail management tools to more than 500 million Microsoft Office users worldwide. With the release of Outlook 2010, you get a richer set of experiences to meet your communication needs at work, home, and …

Morning all! :) I was wondering if someone could shed some light on a problem that I have encountered whilst setting up a shared calendar in Outlook 2003 ... I have done the usual Google searches, but to no avail! A member of staff would like to share her calendar …

The File Edit View .. Menus are missing in Outlook 2003. I tried hitting the ALT key as previously suggested but that did nothing. I need to export contacts and the only way to do this is through these menus.