2,270 Topics
i'm trying to open an existing excel worksheet. my code is: [CODE=c#]Microsoft.Office.Interop.Excel.Application excelApp; Microsoft.Office.Interop.Excel.Workbook excelWorkbook; Microsoft.Office.Interop.Excel.Worksheet ExlWrkSheet; private object Opt = Type.Missing excelApp = new ApplicationClass(); excelWorkbook = excelApp.Workbooks.Open("..//..//Data.xls", Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt);[/CODE] on the last line i get an …
Hello there, I just bought a book to learn ColdFusion, so I have a project but I wonder if the following is possible: To create a page where the user can select: 1 - Date Range 2 - Report Name 3 - select to export to Excel, and here is …
Hi, I have looked all over the web and cannot find a resolution to a basic question. I am having all kinds of problems with Outlook 2000 (PC). Either the program hangs/freezes on the splash screen when i try to launch it, or it freezes when I try to switch …
Cleaning up my computer from some virus "invasions" seems to have messed up my operating copy of Microsoft Office Outlook. [My OS is xp Pro, sp2, Office Pro 2003 enterprise edition with Hebrew multilanguage content] The program no longer receives nor sends emails and, though I can easily access saved …
Hey All, I have been trying to install Microsoft Office 2003 Professional Edition with Vista Basic. So for I have been able to install only Visio and Microsoft Project, but what i really need to install is Word and Access. No i have read somewhere that Microsoft Office 2003 has …
Hello there, after days of researching I finally managed to finish my dragging and dropping of mail items in MS Outlook. But I have this annoying pop up thing in MS Outlook, a security pop up that grants you access from the range of 1-10mins so that I can drag …
Hello there, I've installed VSTO to my pc and I'm trying to make an application using the MS Office in my VS (2008). I've already added the reference to Microsoft.Office.Tools but when I compile it, it gives me the error: [QUOTE] The type or namespace name 'AddIn' does not exist …
I'll start off saying I am not a programmer. I am making a database that imports data from Word forms. It requires code and I found some that works almost perfectly for me at [url]http://msdn.microsoft.com/en-us/library/aa155434(office.10).aspx[/url] It does exactly what I need. The only thing that would make this code better …
Used to work fine.....now, added shadow effects still appear on slide in progress and still appear in slideshow view. They no longer appear on the set of slides that run down the left side of the screen, don't appear in print preview and naturally, don't print. All posts I've checked …
Hi, I have problem to terminate the process EXCEL.EXE after I write into it. After the program finish execute. The EXCEL.EXE is still in the proceses list in the task manager. Anyway to terminate it? Below is my coding: [CODE=csharp] SaveFileDialog s_Lvl_Max = new SaveFileDialog(); s_Lvl_Max.Filter = "xls files (*.xls)|*.xls|All …
Hi All, I have a table consisting in worksheet2(DataSheet) which has country list and in another worksheet1 i have a list which i am populating from the table DataSheet. I require the list in Sheet1 to be updated automatically as I add data in Sheet2. I am unable to achive …
I'm trying to write a program in VB2008 that uses a 2003 Excel spreadsheet as the interface. To help with this I am trying to pass data to and from macros inside the spreadsheet. I call a macro from VB with this line: [CODE] Call gXLApp.Run(gwbTB.Name & "!ArrGather", gArr) [/CODE] …
I've got a user with a Palm Zire 31 who gets the following error when he tries to do a sync with Outlook 2007: HotSync operation started for <user> on 11/17/08 16:08:40 OK Quick Install Outlook Notes - Fast Sync OK Outlook Notes Outlook Calendar OLERR:03-0010 OLERR:0D-000E OLERR:0D-0004 OLERR:0D-0001 - …
Screenshot of problem: [url]http://www.equinefocus.co.uk/worderror.jpg[/url] I create a table without problem, but when I come to type in it, the cell fills with a navy highlight, and I am unable to see the text I am writing, until clicking outside of the cell. I do not have this problem at work, …
Here is my situation, every time I open Office word 2007 and work on it, in a matter of few seconds a get an error and it says ¨office word had stop working and needs to close¨ and then shuts down. same thing happens with excel 2007. I have a …
Hi All Got a really wierd issue here. In both Excel 2003 and Word 2003, when you type the word October, and it is only October, when you press the tab or enter button or click the next cell, whatever it always drops it to lower case when you have …
Any body know about "EasyfitXL" and "StatistiXL"?? which one is more user friendly and useful??? thank you.....
Hello i just download office 2007 in vista and in my xp windows too.however, i am unable to open pdf files download from internet or from my school site because they are in the format of office 2003. so i need help about the format or how i can open …
All the sudden MS outlook and Word on XP MS office 2007 the spell checker and Grammar is set to FRENCH? I've done alot of resarch on the Internet and MS site and there doesn't seem to be a fix other than download 3rd party s.w. and install it and …
Hello there, I've been haunted by this problem for a couple of days. I'm installing Visual Studio Tools for Office and one of it's requirements is Office service pack 1. I've already installed the update and it still prompts that the sp1 is not yet installed. Please help. Thank you.
I purchased a Lenovo T400 windows XP Prof XP - shipped w/ Office 2007 trial but I uninistalled it and installed Office 2003 and now when I launched Office outlook 2003 it rec'd an error unable to open your default email folders. outlook could not start so I went through …
HI There, I am a user of Excel 2003. I need to open a text file via Macro and read it from the bottom one line at a time moving up with conditional match to a pattern of String. If the conditional String is found I have to read the …
This happens simply by opening Word and then closing word, without opening a document. The exact error message I get is "Microsoft Office Word has stopped working" " A problem caused the program to stop working correctly Windows will close the program and notify you if a solution is available." …
Hi I ahd one difficulty in plotting series charts using python ..I had so many sheets and need to generate charts , by running the script using python in excel can any body help me attached is my test file
How can I open file in XL 2007? as I have downloaded the update but not all formulas will open?
hi, i want to transfer the contends of a table from database to excel. can i declare a excel sheet in c#
Hi All I have an Excel workbook (Excel 2002) which is accessed and modified by multiple people, there are 3 sheets within the workbook, 'Processing', 'Completed', and 'List Data'. On the processing sheet there are open jobs with drop-down validation in 2 cells which fetches options from the list data …
I'm a VB newbie with a mammoth task. Well probably not for the Pros. I have been given the task of creating a programme that will allow the user to send SMS messages from their PC to a cellphone and Visual Studios 2005 was the tool given to use. I'd …
haii friends.. am using excel to set formulas like IF(cell4="o";"9":"0")..but am getting a formula overflow when seting lengthy formulas..is there any way to avoid this...
What I am trying to do with the attached excel spreadsheet is to place an IF formula in each of the cells within the black borders. The formula cold be something like this: IF(row 4 = "april" then place a number (say 1). The problem I am facing is that …
Hi all, All the pcs on my network run Outlook 2003 connected to Exchange 2003. Only one of these machines has problems with Outlook hanging every so often with this event:- Hanging application OUTLOOK.EXE, version 11.0.8217.0, hang module hungapp, version 0.0.0.0, hang address 0x00000000. for more information see Help and …
Hi, My system is Windows XP Home. When I click ' remove' in the Add/Remove Programs in Control Panel for 'Microsoft Office Home and Student 2007 trial'; nothing happens. Anything else I want to remove works ok. Any suggestions? Is it possible the program has been removed although it is …
Everyone please give me ur suggestions about which processor and motherboard is best for Estate company work in London. applications i have to use are following Microsoft office 2007 a Database software and some other applications no work with graphics Thanks Alot
hi every one I have a lot of excel data sheets and I need to work with them . how can I connect my code with the excel files . is it the same as ADO.net while u do with access? please help me or send me a link about …
This is my first time joining a community. I am after some specific help with uninstalling Microsoft Office Home and Student 2007 trial!! I have tried to remove it from Add/Remove Programs in the control panel but the remove button doesn't work for some reason. Everything else I remove works. …
I am doing one project in which Whenever I export the result, the list of record should be extracted as Excel file and the list of record should be listed within Excel Table with formated Line. So, I want to format Excel from VB so as to make line / …
I have Microsoft Office on 1 of my IMacs and would like to copy it to the other. I copied the application on a cd, but don't know how to install it. Can it be installed from a disk? Is there a way to copy it direct from on IMac …
Hi to all.. How can we export datas to Excel sheet. Becaause the input is in given form? Need c# sample Coding.. Plz Help me to work with it.
Hey everyone, I am aware that if you change the file extension on .docx files to .zip, then you can open it up. I am also aware that if you save images to a word document, it gets saved within this file structure at word/media/.... What I am wondering is …
Logfile of HijackThis v1.99.1 Scan saved at 19:36:32, on 10/10/2008 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\Explorer.EXE C:\WINDOWS\system32\VTTimer.exe C:\WINDOWS\system32\S3trayp.exe C:\PROGRA~1\Grisoft\AVG7\avgcc.exe C:\PROGRA~1\Grisoft\AVG7\avgemc.exe C:\Program Files\CyberLink\PowerDVD\PDVDServ.exe C:\Program Files\Winamp\winampa.exe C:\Program Files\Ahead\InCD\InCD.exe C:\WINDOWS\SOUNDMAN.EXE C:\Program Files\Common Files\Real\Update_OB\realsched.exe C:\windows\hffext\hffsrv.exe C:\Program Files\Google\Google Desktop …
Hello all, I want to programmatically add users to a distro list in Outlook 2003(server). I haven't been able to find a suitable solution nor have I been able to even determine which language to use. I'm guessing that C# could be used. Anyone know of any examples of this? …
Hi All, My name is Gail Edmonds and my business partner, Missy Scardina, and I own a small software training and consulting company called Core Solutions, Inc. in the Chicago area. Many of our clients are in the west suburbs, as in Naperville, Aurora, Lisle, etc. We do a lot …
Hello, I'm having a few problems getting Outlook to connect to a pop3 email account at work. I've just migrated a website to a new server and had to set up all the email accounts again. On Monday I was able to connect to the accounts with no problems. I …
Okay guys/gals, I'm hopeful someone can help me here. Here's my situation: I have a few custom fill in forms I've created for Outlook. And I want all of my users to be able to access them. This isn't the problem. The problem is ease of use. Our users aren't …
Hi I have recently been given a PC running XP pro, this had Microsoft Office installed but when I tried to open Outlook it wanted to look for the exchange server and when couldn't find it shut down. In an effort to sort this I removed the software and ran …
I have a laptop running Vista Business 64bit Edition (SP1) with Office 2003 SP3 installed (version number 11.8169.8172). It encounters severe slow downs or goes unresponsive for 30-60 seconds at a time when first opening documents on a network share with Word or Excel, or when running Outlook using word …
in vb.net how to export data from datagridview to excel
I am working out of Outlook 2003 on an Exchange Server 2003 system. One of my co workers is having problems reading some e-mails because of the font size of the lettering. He wants to have the option of changing the font size of an incoming e-mail from like 8 …
Hi, I'm new to C#. Can any one help with extracting info from a few .csv files and insert them into DIFFERENT sheet in excel(not necessary .xls format. .csv is fine). I'm not asking for the whole piece of coding. Just need some idea on where to start. :-/ Thanks!
Hello all, Forgive my ignorance but I could really use some help with writing a Word macro to open an Excel spreadsheet. Long story short is that our firm has a multitude of global (corporate) word macros that we use to open different documents and other functions. We now have …
The End.