[office-suite] Forum Topics

ok i got a new computer a couple months ago and the microsftr office was just a trial apparently. is that right? now i cant use word excel all those. which product key do i use. i used all that i had and none work??? help

I am updating an Access 97 DB w/ VBA code to Access 2007. The VBA code uses DAO objects that Access 2007 references when I converted the db files (first from 97 to 2002, then to 2007). My problem specifically is with the two references: "Microsoft DAO 3.6 Object Library" …

is there a way to take data from msflexgrid and put it into a ready made excel file(meaning some boxes in excel is already filled)? And it is put into some specific place in the Excel template. Data from MSFlexGrid-->Excel Template. Thank you.

I had Office 2007 Home / Student installed with Publisher & working on a Toshiba running Vista. The Tosh was a Friday crock that is finally dying. I tried to install the programs on a new machine running Win 7. The install was good. When I opened the programs they …

I (a next to computer-illterate Norwegian) operate MSOffice2003 on Windows XP; in Word2003 I, too, experience the obviously well known problem: in trying to save a document to any other file than the one proposed by the system, the system hangs and suddenly shows 100% system resources occupied. I (no …

Hello. I am looping through files in a folder and need to remove empty columns of a spreadsheet in a given range of A-G (at least any column between these ranges may be blank). I eventually want to do the same thing with the rows. I have revised my code, …

Hey people, first all let me apologise if this in the wrong section I couldnt find a seciton for office or just excel. So i figured windows software was my second safest bet, he hopes lol. I'm having a problem with excel. I'm trying to write a function that will …

hi all, i want to run the slide show say ten slides and then close it programaatically , but in my code given below it opens the slide show and closes immediately ... .. please give me a solution to this problem [code]Microsoft.Office.Interop.PowerPoint.Application ppApp = new Microsoft.Office.Interop.PowerPoint.Application(); ppApp.Visible = MsoTriState.msoTrue; …

Hi all, Can someone please help... I have a small youth football web site and would like to display the league table on a web page. What is the best way to display this information, so that it is not to manual when i come to update the results weekly. …

I need to move a chart from one sheet to another in an Excel workbook, and I am having issues with different versions of Windows and Excel. Here is the code I am currently using: (excelApp is declared correctly) [code]excelApp.Workbooks("Book 1").Sheets("Sheet 1").ChartObjects(1).Chart.Location(2, "Chart 2")[/code] This works perfectly and consistently with …

Hey everyone, I'm having an issue where my application will keep Excel running even after it closes. I think I'm closing everything properly, but is there a way to check on close? Here's part of my code: [code=c#] ////////////// Part of ExcelWriter class public void CreateSheet(Laptop lptp, string file, string …

Recently in the last month or to we have updated our workstations to office 2003. In two instances so far, the calendars keep creating blank appointments. Its not just 1 or 2 either. Sometimes its is dozens upon dozens. It will do this every hour. It is real annoying. As …

How can I specify which sheet I want to write to by name? For example, I want to specify that the sheet I should be modifying should be labeled "212". Also, perhaps a more challenging question. How can I ensure that the sheets I create are always in alphabetical order? …

Whenever i try to open a word document it displays a macro error. It tells me to try enabling or disabling macros from the trust center. The document displays but it is really annoying. would appreciate any help The error looks like this

I've recently downloaded the package that allows you to work an excel file using python at: [url]http://www.python-excel.org/[/url] I'm new at installing things from a programmer perspective... can anyone tell me how I'm able to determine if I have installed the programs correctly?

My outlook at times does not receive all e mails, in addition, it held on the password section...The ISP told me that I should look into un installing outlook.. Is there any type of thing/program that FIXES it or can someone advise how to un install and re install? Thank …

I have run into a very strange problem with Microsoft Word. Here's the background. I am running Microsoft Office Professional (fully updated) on a machine with the Windows XP Home (fully updated) operating system. My wife has a folder on the desktop where she keeps her business correspondence. This folder …

Hey everyone, I have an excel file I'm trying to work with. I can open it, write to it, and save it fine. But now I'm trying to work with adding sheets, and modifying the names of those sheets. For some reason though, my app keeps locking my excel files. …

Hey everyone, Does anyone know how to specify which sheet you're going to be modifying in an exel worksheet? For example, if I have an Excel file that has 5 sheets, and I want to modify (4,7) on sheet 3, how would I do that? Here's what I have so …

My boss and I have Outlook 2003. I know how to create templates for when we are sending new emails to include our company name, phone number, etc. Does anyone know if it is possible and how to create a template for the reply portion? We would like to click …

Alright. In Outlook, if I want to arrange my tasks by categories, I can go View->Arrange By->Categories. My question is, is there anyway to do this programatically? Thanks a bundle :D

Hello, I have created an HTML table wherein the row's values are filled thru database. ex: FirstName : dbvalue and so on... Then i create an excel file please find below code: [QUOTE] StringBuilder str1 = new StringBuilder(); str1.Append("<html xmlns:o='urn:schemas-microsoft-com:office:office'").Append(Environment.NewLine); str1.Append("xmlns:x='urn:schemas-microsoft-com:office:excel'").Append(Environment.NewLine); str1.Append("xmlns='http://www.w3.org/TR/REC-html40'>").Append(Environment.NewLine); str1.Append(Environment.NewLine); str1.Append("<head>").Append(Environment.NewLine); str1.Append("<meta http-equiv=Content-Type content='text/html; charset=windows-1252'>").Append(Environment.NewLine); str1.Append("<meta name=ProgId …

Hello, This code captures an defined area from screen and transfers it into text. But, i have 2 problems here. 1st. - I cant delete temp file ( File.Delete(strFileName) - it says - the file is used by another process. 2nd. - If i capture an area, where isnt any …

Hello, I have an page of User Details. When user fills up all the details and clicks to Save them the data should loaded in the Excel sheet and then send via email as an attachment. The Excel sheet already has the fields as on the User Details page. How …

i want to export all data in sql 2005 database to excel file but i don't know! Please help me! Thanks so much!

I have a spreadsheet (roughly 200x200 in size) that is a matrix of 0's and 1's that define rules. These rules cannot be expressed in procedural logic because they need to be easily accessible for change by a user for modification. The first row are header value strings and the …

This is a very brief overview of how to achieve an ON-THE-FLY creation of an appointment in the clients outlook calendar. This will not force the user to add it to there calendar but gives them the option to add it automated. Using the older .vcs file extension for outlook …

I would like to take value for say cell K1 and compare it to all data in L1 to L25 then if K1 = L12 I want it to take the data from P12 and paste it in D1 then move on to the next one. Compare K2 to all …

I have succesfully installed all the emails into Outlook 2010 on a new pc running Windows7 professional from a pc running win xp and Outlook express. The only way I could find to do this was by downloading windows live mail first, importing into this and then exporting from Live …

Laptop crashed and after OS reboot MS office would not work. A prompt for original product code would pop up. Is the any way to retrieve office or is it lost for good. Thanks Lo812

How to read Microsoft Office Document And displayed on web page ?

I am looking for a good Microsoft Office/Offices. I just had my computer upgraded, but they didn't leave any of my offices. I have Microsoft Windows XP with the 3 pack. I have a CD but it is only for a trial. Since I had a developers data was craming …

Hey all, I'm working a spreadsheet in excel. Basically, it looks like this: In Column A there's a 4-digit number. Column B, there's 2 things one cell with an entry like this A0000000, for example, and right under that, a 4-digit number. Column C is a person's name. what I …

Hi, My code opens Excel 97-2003 version Excel file correctly, but gives error when the Excel file is in 2007 (*.xlsx) format. How to solve this? - Mahesh

Hi, My VirusScan pops up with an alert anytime I try to start a Microsoft Office 2007 program, such as Word, Excel or Powerpoint. (For example, the pathname shown by the VirusScan Alert is C:\Program Files\Microsoft Office\Office12\EXCEL.EXE::GetProcAddress). It doesn't do this with anything else, web access etc. are fine. It …

I have Windows Vista and MS Office 2007. I am trying to generate a program using cut and paste to copy test answers sent online into an Excel spreadsheet and want to list IN ONE CELL, seperated by commas, the numbers of the answers that were wrong. So, if I …

I am using the .Net 4.0 and excel 2003 How can i use an oledb connection to retrieve the cell format of an excel spreadsheet... I specifically want to find out if a cell column (or cell itself) is in a numeric percentage format. I cannot seem to find this …

Hi I need to export some data from VB SQL query to an existing excel file, witch is a bill model. In the area where I use CopyFromRecordset are some merged cells, and all goes fine but the paste of data in those cells. If there are 3 merged cells …

I done an application using Power Point Interop library and it works well but if I copy it from DEBUG folder to another place, when I start it it gives me an error like: "Application has encountered a problem and needs to be close. We are sorry for the inconvenience". …

What do you guys think would be the easiest way to convert a powerpoint to a flash movie? Thanks

hi there, i have an excel sheet and i need to get values from the excel sheet to the mdf file in the visual studio 2008 database. the value i want to get from the excel file is a accounting value witch is displayed like this $ 67,300.34. how can …

please can anyone help me out to export crystal report to excel in windows apllication using c#..... please help me as early as possible..

I just created a code in c++ and i was wondering if there is any way a can convert that into a excel document.

Dears [INDENT]This is an electricity billing Site link [url]http://www.mepco.com.pk/ls/defftree.asp[/url][/INDENT] I click on each link and SELECT and COPY/PASTE , It takes 3 hours minimum each day to save all pages in Excel. I want to get all pages automatically using PHP or Query. Because higher management demand reports each day.

Well, I am an advanced Windows user, and I do a *bit* of programming in VB but mostly making modifications to my Windows box. Mostly software mods, but I do have LED case fans and a transparent side. I am running Windows 7 Ultimate 64-bit on an i5 box and …

Hi all. I attached a code creating file from datatable. I have a problem saving Excel file in c# using Microsoft.Office.Interop.Excel. When I'm saving the file as Exsel 2003 (xls) format the file is OK. When I'm saving the file as Excel 2007 (xlsx) format I get error massage from …

I have been getting an error message titled wmdc.exe-bad image "C:\Windows\system32\WSOCK32.dll is either not designed to run on Windows or it contains an error. Trying installing the program again using the original installation media or contact your system administrator or the software vendor for support". I also get all different …

I need some help finding instructions on how to re-eanble Outlook 2007 SP2 Junk Email Options. Mine are greyed out. I suppose it could be a GPEDIT problem, but I don't know what module to load so that I can change it. In any case, I cannot choose the level …

I want to export evrything in a page to excel, it's just the graph that does not export. I used ChartControl graph which I downloaded. [code] protected void excel_Click(object sender, EventArgs e) { excel.Visible = false; Response.ContentType = "application/ms-excel"; Response.AddHeader("content-disposition", "attachment; filename=CashFlow.xls"); } [/code]

Hi, my Outlook will not open after downloading and running the latest service packs yesterday. Outlook opens into a tiny window, first it said Microsoft SEtup Bootstrapper is not working, now it only opens in a tiny window and then closes saying, cant open Outlook. Tried uninstallating service packs through …