2,270 Topics
hi, i'm new to c# after some time in assembly, and a bit of c++. i'm trying to examine 2 cells and report back depending on their contents. i want to test A11 - if it is empty - exit - else test B11 - if thats empty then return …
Hi guys, am running xp pro and having problems with pc going into sleep mode when i open microsoft office outlook, sometimes it will open but as soon as i try and open a folder it shuts down and the only thing i see is a small window saying attention …
I'm using Outlook 2007. Up until recently, I was able to print e-mail with no problem until today. When trying to print, I get this error message "'One or more of the items you tried to print does not support printing and was not printed'. I know that someone previously …
We're getting this error on all computers on the domain, there were no changes done over the weekend and I can't think of any other ways of fixing it. We can get around by right clicking on the file, send to Mail Recipient and the file gets attached, but we …
I have an enquiry concerning office 2007 automation on windows 2008 64bit. Basically the issue is as follows: ยท I'm using office 2007 automation on windows 2008 64bit, my solution is using excel office automation (Excel interop assemblies) from a .Net managed DLL to export reports in excel format from …
I have posted this thread in the microsoft software forum as well but with no luck. If anyone can tell me how I can save a active excel file using a macro to save it in a folder using the current date as the file name. I hope that was …
I'm trying to export an excel file to my sql database. But not all the column inside the excel file i need. So, i just need some selected column for input to the database. But now i still cant finish with the code. HELP ME PLS.(red color word is where …
I need to input data into Excel sheet using a pop up window. Someone suggested I should use Macros. Can someone help me with it. I don't know where to start
Hello, i am working on a macro where i need to copy data from a sheet to a different sheet in the same workbook. i normally use "vlookup" or "Sumif" or "Sumproduct" formulae to do the job. the datas is quite large and it takes ages to refresh the data …
If I have no text highlighted and right click on the mouse the normal menu comes up but with cut and copy greyed out. If I highlight part of the text and right click the mouse the menu shows [B]Move here, Copy Here. link here (greyed out) and cancel[/B]. I …
Hi, I have two spreadsheets with the same structure and I want to find formula to be able to just open these two plus a master spreadsheet and have both sheets 1 on top of the other to make 1 big table in the master spreadsheet. I cant find a …
I have an add-in program that has several forms. When the program is done with one form, it automatically goes to the next method it needs. (Word add-in). My problem is this...When I hit cancel, I want it to stop all actions with-in my add-in. Right now, if I hit …
Greetings all, I'm having a problem programmatically calling SendAndReceive in my Outlook Addin. I'm using Visual Studio 2008 and Outlook 2007. I expect this is due to me not having a complete understanding of what is going on in my code, but I'm hoping someone will be willing to enlighten …
Hi all I bought Word 2003 and installed it on a computer that was pre installed with the trial version of 2007. I didnt want to uninstall the 2007 because it opens things I can't open in 2003. I use it as a viewer- but its not activated. I need …
I have a word issue where I open a document and the numbering levels are all the same eg. every new line on level 1 is numbered 1.2. On other people's computers the document opens up fine. It happens on selected computers and appears to be a word problem. When …
Hi all a collegue of mine has a relativly simple problem in excel. she has a table (just some data in rows and columns - not a real table) of data set up and needs to copy the sum created in this table to a different table but transpose it …
New to all this, so if I've done it wrong, tell me! EXCEL for MAC: I have a long (3000 names) mailing list stored as data in columns, of course. In combining lists, some of the address entries are in Caps others in Upper and Lower case. Is there any …
Dear members, Recently I had some difficulty in extracting data from Pivot table.. And Im not able to attach the Excel file along with this tread. May I know if .xls file is not allowed for attachment? Coming to the problem, the original table contains data in 2 columns.. 1st …
I've created an Excel spreadsheet that I use to incorporate data into a Microsoft word document. (Word/Excel 2003) When I do the mail merge and bring in the data, Excel takes a few of the data cells and adds zeroes after the decimal. I've attached a .jpg image of the …
Hello, I want to invoke oulook mail from my code in Delphi. It should be like if user select a menu option "Send Mail" , the new mail message window should appear . If outlook is not running aleady, it should start Outlook also. MS oulook 2003 and 2007 only. …
Hi all, Thanks in advance for the help. This issue has really got me stumped, so I'm hoping that you guys and gals here at Daniweb can help. So, heres the problem: Whenever I double click a MS Office file (word, excel, ect), the associated program shell starts up and …
For some reason I can't open any Microsoft Office files...the icon is that generic white icon with a tabbed corner and a window on it. Tried reinstalling office and I get an error.
Okay so I am new to programming but I have a very basic knowledge of some things. I have been working with vba and I need to write a macro for a word document that only allows the people that are allowed into it to view it and I havent …
Hi guys I'm trying to load office 2003 and get passed the inputting serial code and then when I get to install it comes up with I don't have administrator rights. Funny thing is I am the administrator. I am running Vista Home premium. Any help would be appreciated. Many …
Hi colleagues, How do I get the DISPLAY NAME, PHONE NUMBER and SMTP from Address book by searching with User ID? Actually i have a list of User IDs (U123456, U132154.......) in my MS excel sheet. i want a macro which may help me to extract the details of this …
Hello, I am trying to embed a html file (a report from sql) in to a word document in a particular location. I am trying to get this done using the Office Interop. 1) How can I embed a html file in to a word document ? 2) How can …
Hi to all, In general I have 2 questions: 1. I have the following function written VBA in excel: [CODE] Function Ro3(r As Range) As Variant Dim RefString As String RefString = r.Address Ro3 = r.Worksheet.Evaluate("CHEM.MOLWEIGHT(" & RefString & ") < 300") And _ r.Worksheet.Evaluate("CHEM.NUM.HBDONORS(" & RefString & ") <= …
I keep getting this message when I try to open Excel, Word, Outlook, etc. It seems to be a common problem. MS Office was installed by a network guy at a place I no longer work HJT log Logfile of HijackThis v1.99.1 Scan saved at 12:30:33 PM, on 4/20/2006 Platform: …
Hi I use C# to read excel file.So user has to enter path of the excel file into application.However problem is, if there is null value in excel sheet for particular column then it generate the exception.so i want to create another application that check null ,how do I find …
Hello All, I copied my hardrive as separate hardrive for removal of one hardrive to be used and save the other one. Some copied icon does not open up the software like the original. Mainly the microsoft office 2003 software. How do i make or link them to the software …
Hi, I created a group of macros in Word 2003 and they have been working fine. Recently a client upgrade to Office 2007. I went in and changed all the Application.FileSearch commands that I had in my macros, knowing that that command was no longer supported. But when I try …
Hi Guys, I want to convert .pptx/.pptm file into .ppsm file using VB6. As like we do Save as functionality in Microsoft Office PowerPoint Application. In PowerPoint, we open .pptx/.pptm files and then save as this file in .ppsm type. Now this file converted as .ppsm type and functional as …
Hi I'm very new to C# and I'm working on a project in the office where I can practice. At the office I can open the project ok. But if I tried it at home in my own laptop, I'm getting an error. Yesterday I tried to add the reference …
data's in datagrid is not all from database/recordset.. i have 2 columns coming from a textbox.. is it possible to move all the data's in my datagrid to an excel sheet?
Hi, I have 15000 excel lines of option data, with dividend rate, risk free rate, option price, strike, maturity, underlying...and I would like to compute the ilpied volatility of my options using the Newton-Raphson method, which is faster than the bisection method. But the problem is that I have a …
Hi, When I create a new message in outlook 2007, a clipboard shows up in the left panel. I tried to remove this by "x" but every time when I restart outlook it shows up again. even when the "collect without showing office clipboard" is selected. I don't want to …
I have a problem with my outlook. what is happening is that it won't alow me tto open the page that alows me to send emails. It just pops up saying that it is opening outlook's editer. and that is where it stays. I've done a pst scan and that …
Hi I am doing a project to read the output of an instrument and store in excel sheet. I have succesfully read the data thru mscomm1 and am able to show it in a text box. The data from serial it read from 3 second in 3 second using a …
Hi ! I am getting a strange error message when opening MS Word. I have downloaded the Office 60 day trial and when I tried to open Word, I get an Error message 'The operating system is not perfectly configured to run this application' Can any one pls advise...is it …
Hi i set up my mail in outlook using IMAP. And I've noticed, whenever I deleted or moved emails to my other folder, I'm seeing this crashed out in the emails. Is there any way I can avoid it this crash out? Thanks
Is there a way to read MS Office document word by word in C#. I could read the whole stoyr like [code] doc.ActiveWindow.Selection.WholeStory(); doc.ActiveWindow.Selection.Copy(); IDataObject data = Clipboard.GetDataObject(); [/code] However then can we use any method using data object to read the ms word documents word by word?
Hi !!! i need to make an application , in which i can open a excel file lying on the server update it and save. any ideas please !!
HI Iam created project in visual studio 2008,and once I compile coding,it give me error meassagee.The Error Meassage is [COLOR="Red"]Error 1 The type 'Microsoft.Office.Interop.Excel.Workbook' exists in both 'c:\WINDOWS\assembly\GAC\Microsoft.Office.Interop.Excel\11.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Excel.dll' and 'e:\Test\Test\Test\obj\Release\Interop.Microsoft.Office.Interop.Excel.dll' E:\Test\Test\Test\Test.cs 13 67 Test [/COLOR] So what I did is I delete the Excel.dll in (\obj\Release\Interop.Microsoft\Excell.Dll,but once I complie it …
Hi there, Please can you assist or advise to this issue: I have a user on Windows XP Pro, SP3, Ms Office 2000- Outlook (2003). Sometimes when he opens Outlook and word at the same time he gets the message or error below: Faulting application winword.exe, version 9.0.0.2717, faulting module …
Dear All, I wrote a program in C# to start the powerpoint slide show using example of [url]http://support.microsoft.com/kb/303718[/url] . I wanted to update the content periodically using this C# program when the slide show is running. The content is an excel table. However, the content does not change. Anyway to …
Hi, I was wondering if anyone might be able to help me here. Is it possible to restore a folder that was deleted from microsoft outlook 2003? What happend was i accidentally deleted the folder called junk-email. Also, if i may ask this question. On the folder say "junk Email", …
Hi Nowdays Iam developing application that use for read excel .So Once I run and close the application there are more than 5 excel.exe process are running.How to stop these process.Below I mention code which I used. [CODE] xlApp = new Excel.ApplicationClass(); DataSet ds = new DataSet("DataSet"); xlWorkBook = xlApp.Workbooks.Open("C:\\Test.xls", …
:sad: :sad: my web page C#.net is work properly in my iis .but when i publish in another server it give errers.i used vs2005 and ms word 2003. but in the server there is no vs2005 or word installed. it has only .net frame work installed.folowing the error, Parser Error …
Hi I'm posting this here, because i'm not sure where else and i have a gut feeling i will be doing this with VB. My goal is the following: I have an Access database (with four fields, of which the first one is the key) which I'd like to use …
The End.