[office-suite] Forum Topics

This is getting me insane, I got Office 2010 (I think it is still trial). When I try to open a file made in 2007 (both 2010&2007 save in .docx) it shows me this: [url]http://www.flickr.com/photos/60633736@N03/5568673664/[/url] Translating (sort of...): There's not enough quota to do this action. Please Help, it look …

Hello! I'm trying to find a code to delete multiple columns because when you delete a column the next column takes his place so for example: If you delete column 6 then column 7 becomes column six. I tried the following code with an for loop & a while loop: …

Anyone can tell my why it keeps saving at My Documents? [CODE] $newfile = 'temp.xls'; $wkb->SaveAs($newfile); [/CODE] If I [B]echo[/B] $newfile, it will display 'http://localhost/test/excel/temps.xls' Its suppose to save it at same level right? wrong, it keeps saving at "My Documents" How is that possible? Thanks

Hi, How do I write a VBA function to display blank if I want to refer to a blank value in pivot? Excel shows 0 in such cases. I don't want to handle this using [CODE] =IF(formula="","",formula) [/CODE] since it involves repeating the formula twice. Please let me know how …

Hello world, I need your help/advice, I have a table last_acces where inserting a few data. The table columns are: Id Name Date I want to export this data into excel clicking on the link or button from the page. Anyone could help me on this please? The action will …

Hello, I have a layout and i have to paste information on that layout, in that lay i have Columns H, P i have a formula in column P like this [CODE] =IF(ISERROR(P3/H3),0,P3/H3) [/CODE] but when i insert the information obtained in VBN to EXCEL worksheet it pastes the information …

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 …

Sorry - I know this isn't strictly Python, and i'm more asking for a formula than code! Usually Excel functions show how they are calculated but i can't find anything on this one! So given a set of data, predict what the next value will be based on the previous …

When I load frontpage 2003 it goes through an installation process then brings up the error: "a required installation file F2561406.CAB could not be found" I keep reading similar problems with resolution being select the location on the CD.. but I have lost the CD Is there anything else I …

I am running Excel 2007 on Windows 7 Ultimate Edition 64-bit. I was sent a spreadsheet which uses the earlier Excel format (97 to 2003). I can open and edit it fine, but when I save I get a message saying that I am using features which are not compatible …

Hello all, Currently i'm trying to make an addin for Microsoft Word that i need to get the content in byte[] of currently active document. So here what i'm thinking what i will do, First I'll read the document.xml and get its bytes, then i'll get the byte[] of each …

Is someone there running iWork and have him/her checked its compatibility with Word? By compatibility here I understand that a document produced in iWork will open and be absolutely readable by Windows users, also basic features like tables, images, bullet points will remain in the document. I have my doubts …

helo friends. i need to deal with more than 10 excel sheets.. so i want to make an desktop application in Visual Studio(c#), which performs as followings..: 1) first user can choose on which file he wants to work on. 2) then retrieving column wise data, and performing many mathematical …

Hello I am looking to dump data from a MySQL database to an excel spreadsheet. I know I can dump it to a CSV file and import that way, no problem. But I want to dump the data to a specific spreadsheet in an excel and specific cells. I have …

Hi I m working on a project where in i have to change the EXCEL workbook settings at runtime as per the regional setting of the user. Although i know abt the Localization option available in vb.net, but it is only working for forms not for EXCEL. Need ur help …

Hi, I am generating table with Microsoft.Office.Interop.Word In my table cell values i get is: 7, 11, 13, 14, 15, 18, 28, 29, *25,26,28 Now my prob is i want to replace ,* with new line in word. i have written this code [CODE] tbl.Cell(i, 4).Range.Text = tbl.Cell(i, 4).Range.Text.Replace(", *", …

I will get an Excel 2003 file everyday via email. This file has 5 columns. The first for columns have static headers and text in them. The 5th column is the date of the report and below that is a list of values in the same column, followed by an …

Hi guys..I try to automate outlook..it works great ..the problem is that I use office14 at home, and my company (where I need my program to work) uses office12... I was told that to make it possible to run on office12 and later, I need to get msoutl.olb from office12. …

Hi guys..I try to automate outlook..it works great ..the problem is that I use office14 at home, and my company (where I need my program to work) uses office12... I was told that to make it possible to run on office12 and later, I need to get msoutl.olb from office12. …

I have word 2003. I can't use the font type or size. I also can't change ruler unit. Basically I can't do any editing.

HIII please help me.. i need the confirmation code of Ms office home and student 2007 at first i entered the product key , then while activation it asked about the confirmation key and yeah i chose that i want to activate the software by telephone.

I have a jsp page which is showing data in that page from DB.there is also a facility to show data in excel file.So there is a link to import the data in excel file. I have noted down that url by pointing the cursor to that link that is …

Hi, I'm using microsoft.interop.excel to automate excel sheets.... here's a snippet from the original code..... [CODE] rangeTemp1 = "C" + rowNo; rangeTemp2 = "C" + total; worksheet.get_Range(rangeTemp1, rangeTemp2).Merge(false); range = worksheet.get_Range(rangeTemp1, rangeTemp2); range.FormulaR1C1 = temp.query; [/CODE] i'm trying to insert a long string into the cell.... though manually i am …

Hi guys... I have small problem with my code [CODE]// WYSYLAMY DO HD Outlook.Application oApp = new Outlook.Application(); //Create the new message by using the simplest approach. Outlook.MailItem oMsg = (Outlook.MailItem)oApp.CreateItem(Outlook.OlItemType.olMailItem); //Add a recipient. // TODO: Change the following recipient where appropriate. Outlook.Recipient oRecip = (Outlook.Recipient)oMsg.Recipients.Add("aaa@bb.pl"); oRecip.Resolve(); //Set the basic …

I have an excel sheet having predefined columns 'Qname','CorrectOptions' etc. Following that excel columns user fills data. Problem occurs when, in column 'CorrectOptions' user put ex. 2,3 value, while reading cell value getting empty. But if user enters any digit value without comma, it reads fine. I think excel makes …

Hi, I have place list of items in the xls and from that excel i read the items and add to context strip menu on run time. How to give the short cut keys to these items on run time is this possible.... Thanks in advance...

Hi All, I am developing an Excel Add-in using Visual Studio Tools for Office using C#. However, the problem is that i want to use the SOLVER add-in that is available in Excel in my code. I cannot find any way or documentation anywhere for doing the same. However i …

How to move data from sql server to excel sheet.

Hi, I am using vs 05 and access 07. I would like to export the data in the datagrid to an excel file preferably in excel 2007(i.e. .xlsx). I have found this discussion on daniweb [url]http://www.daniweb.com/forums/thread211651.html[/url] however i get an error [CODE] Excel.Application app = new Excel.Application(); [/CODE] Am i …

hi, i found a module called xlwt ([url]http://www.python-excel.org/[/url]) that can write to Excel. i want the code to read from a file (robert.txt) and then write to excel in a column. however, it seems that the output from this code is that it only writes to one cell in the …

I am trying to make a stock control work sheet and I am having problems with a circular reference. Take cell B2 and place this formula in it =(A2+B2). I now have a circular reference. I have turned on the iteration in Tools,Options calculation and limited the maximum iterations to …

Hello, i would to import the last modified txt file from a directory (c:\Folder) using a macro in Excel. I have a folder which is incremented everyday by a new txt file. The goal is to import the last txt file added in the direrctory. I've already created a an …

I've been racking my brain over this for a few days now. I'm attempting to write a program in Python 3.1 / PyQt 4.7.5 that will open a Powerpoint, go through every shape on every slide, determine if it is a picture and then save that picture to the specified …

is there a way by which i can generate a excel report in asp and create a chart corresponding to it using asp as well...

hi... can someone please explain how to create a new excel file using an excel template in c# I have no idea how to go about doing it and that is why i haven't pasted any code.... i have been developing an application as part of my college project..... and …

Hi, I hope someone here can help me with this problem. I want to create a button in my site such that when it's pressed, the site database will be exported to an excel file. The codes to export database I got works fine but when I try to merge …

I have a [B]Windows XP Pro[/B] machine with [B]Outlook Express 6[/B] on it. I want to transfer it ([B]Account settings, Contacts, Calendar, Messages[/B]) to: a [B]Windows 7 Pro[/B] machine with [B]Microsoft Office 2007[/B] on it. I do not want to use the Windows Mail or Windows Live Mail. I want …

I need to be able to check if another user has an excel workbook open (from a network drive) from within another workbook. user 1 has workbook1 open and has a macro to open workbook2, paste some data in, save it and close it, I need to add code to …

Hi, I'm trying to create an excel 2003 workbook from my vb.net project I referenced the code from this website [url]http://www.dotnetspider.com/resources/20382-To-create-Excel-file-vb-net.aspx[/url] However i'm getting error on this line "objSheets = objBook.Worksheets" Can any please tell me what's wrong? [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click …

Hi, I am importing data from excel (don't know yet I am going to do that) and export it back into excel. I don't want to have users to import data using excel (due to lack of intelligence) and also it would be faster and more streamline. I already had …

Hi every one, I need help urgently please I am creating a db with an interface from VB.Net 2008, what I need is to export to excel from a datagrideview by clicking on a button. I have found a code but its giving me errors, I posted the code maybe …

hi all, I need a code which export access table data into excel sheet.I am working in vb.net2003

can any one help me about my project.... how to code data from excel export to access..

I need to take the content of a C# datatable and deposit it (...) in a new Excel spreadsheet. I have seen some good generic code to do this, however, my problem is that I need to be specific, column by column, as to the format of the cells. For …

i have Installed MsWord 2003 and MsWord 2007 in my Computer .But when i open Either MS Word 2003 or Ms Word 2007 . i got the following attached message .let me know the idea .any help would be highly appreciated.

I am trying to create an Excel sheet and save it in server... Once it is saved, I display a link to the user "download excel". He can click it and then download it.. The pblm is I cant save the excel it says "The file could not be accessed." …

How do I add a Macro to an Excel Sheet using Late Binding? I had the code working using Excel(2010) PIA: [CODE] //create a new VBA control module oModule = oWorkbook.VBProject.VBComponents.Add(VBIDE.vbext_ComponentType.vbext_ct_StdModule); //Add the VBA macro to the new code module oModule.CodeModule.AddFromString(sCode) //sCode is the VBA macro I created;[/CODE] I now …

I use Word 2003 and want to set the default font to Optima (the template being Normal) but as soon as I type, the font changes to Times New Roman, the template changes to Normal + Times New Roman. This does NOT happen if I set the default font to …

I'm using VBA to query and modify an Excel database. The database contains information about servers and their locations. Most of the rack mount servers have the location column as something like "G-05". Those are easy. When it comes to the blade servers, the locations are listed as "G-05E2S09" or …

Hello, everyone, My question deals with Excel, and not Access, but I understand they should be roughly the same. I have an Excel worksheet which contains several tables. The tables are actually named ranges; basically, I grabbed an area, gave it a name, and -voila!- it is a table. Until …