[office-suite] Forum Topics

The select case construct is moving to the Case Else line every time the programme loops, even though there are "Longvue" & "Roseleigh" entries in the worksheet.[code]Option Explicit Option Compare Text Sub Complete() Dim HOComplete As Range Dim Client As String Dim JobNumber As Range Dim workrange1 As Range Dim …

hi... im using a word editor in my app..i want to save all the data in the word editor to be saved in microsoft's word. does anybody have a code to create and save the data into the word doc. automatically? like when i click a button, it should automatically …

Hello, I was wondering of it was possible to have a query sheet with two drop down menus, and a search button. I have all my data on a seperate tab but I would only need certain information at any time. Could I have drop down lists that have every …

...Even in safe mode. It starts to open and then I get a white screen and it is not responsive Running Outlook 10 on XP machine. I saved the PST to an external hard drive and am thinking of uninstalling Office XP pro and reinstalling. Advice?

I can't get window office to except the key code to load office 2003 into windows 7. any help? Thanks

I am trying to enter the following formula but I am coming up blank. Ok, I have excel 2007. I created a purchase order. On the purchase order I am trying to calculate multiple sales tax possibilities depending on which state I place in the State cell. The 3 cells …

I am trying to import mails from Outlook to my Database during execution of code it is throwing the "Excepiton ComException unhandeled by User Code" [COLOR="Red"]Array index out of bounds[/COLOR]. it was working fine in the biggening but suddenly start throwing this exception. Here is my code [CODE] try { …

Hey guys, im new here and i was wondering if some people could help me out? ive recently been employed in an IT company, and although i am quite familiar with c++, i have been asked to work on making a custom Ribbon in Excel (creating a new tab for …

I am trying to import mails from Outlook to my Database during execution of code it is throwing the [COLOR="Red"]"Excepiton ComException unhandeled by User Code"[/COLOR]. it was working fine in the beggening but suddenly start throwing this exception. Here is my code [CODE] for (int i = 0; i <= …

Here in the UK it is pantomime season. A peculiar form of traditional slapstick stage play that is performed during the Christmas season. In essence favourite tales such as Peter Pan, Aladdin, Jack and the Beanstalk and Aladdin are retold with the lead boy played by a girl and an …

I was trying to uninstall the trial version of Ms Office 2007. during that process my system got auto shutdown due to overheating. Now i am unable to uninstall it. It exists in add-remove progs menu. and if i click on remove it says "Product installation corrupt. Run setup again …

I'm using Word interop to create a new instance of Word, and load a document into that instance. I'm using the same technique shown [URL="http://support.microsoft.com/kb/316384"]here[/URL], except instead of creating a new document, I'm loading an existing one. This is working fine, except in the following situation. 1. There is already …

Hello Guys, How can i display the content of MS Word document to my ASP page? How can i upload ms word document? How can i download ms word document from the page? Hope somebody would respond. regards, AV

Hi: I have a workbook that has several sheets. One sheet called FORM is password protected (by me). I have a macro that clears all sheets but when it gets to FORM it prompts for the password (which I don't wan't to give to my users). Is there a way …

Hi, I have an assignment to read mails from Outlook and store them in DB in C# plateform. When I read the attachment File and store its contents in BYTE[] when I run the query to store contents in Database it is throwing EXCEPTION [quote]"An object or column name is …

Hello, I am trying to figure out if it is possible to share just One Week of your calender via email. For example if the CEO of a large company wants all of his managers to email him their weekly scheduel every week how would you go about doing this. …

It would appear that Ask.com, the search site which used to be known as Ask Jeeves, [URL="http://news.yahoo.com/s/cnet/20080704/tc_cnet/830110784399841617"]has purchased[/URL] Dictionary.com Dropping the 'Jeeves' branding after 10 years, the search engine retained the same 'ask a straightforward question' approach to Internet searching. With the acquisition of Dictionary.com, Thesaurus.com and Reference.com that concept …

I generally do not participate in discussion groups, my life is just too busy but I noticed a post that I thought I could help with so as a teacher I could not resist. I have been active in content managment since 1997 and in site creation since 2001. I …

Dear All, I have installed Visual Studio 2008 Express edition " Free by Microsoft ". I have done some of my assignment in vba using excel 2007. i want to learn office programming in visual Studio 2008 Express Edition the enhanced features and their advance application in office 2007. Please …

The Los Angeles City Council voted unanimously earlier this week to outsource its e-mail system to Google Inc., according to an [URL="http://latimesblogs.latimes.com/technology/2009/10/city-council-votes-to-adopt-google-email-system-for-30000-city-employees.html"]article[/URL] in the Los Angeles [I]Times[/I]. The contract is worth $7.25 million and covers 30,000 employees. In June, Washington, D.C. made a similar decision, signing a contract worth almost …

How do I Load an excel file to the PrintPreviewDialog? [CODE=vb] Imports Excel = Microsoft.Office.Interop.Excel Private Sub btnPrintPreview_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPrintPreview.Click Dim xlApp As Excel.Application Dim xlWorkBook As Excel.Workbook xlApp = New Excel.ApplicationClass xlWorkBook = xlApp.Workbooks.Open(Application.StartupPath & "report_summary.xlsx") MyPrintPreviewDialog.Document = xlWorkBook If MyPrintPreviewDialog.ShowDialog() = …

I need a new computer and am wondering whether to buy a bare m/c and install XP, or to buy one with Windows 7. I use Office 97 which works fine with XP, though no longer supported. It seems it aslo works with Vista. Has anyone tried it with Windows …

I am attemting to load Microsoft Ofice to on second computer, first one stolen. It will not load. Error message MAP132.DLL is corrupt or wrong version. This could be caused by installing other messaging software. Help Please!!!!!

I have an Add-In for Excel 2007 (can't post the code here unfortunately) and in some instances, when the user makes a certain change within the Add-In then closes Excel 2007, they are prompted to enter the password for the VB code within the Add-In. The password prompt dialog can …

dear experts, how to compare two different columns to check that whether the values in the cell are same or different using excel 2007... thanks in advance, 4ukh

Hi All, Can we embed a object in excel sheet using ASP code as we do manually. If so please provide me the code.

Is there a "correct" way to draw a line betwee the header and body of a document in word 2007? I've been using a Shapes->Lines line, but it seems silly because there is no way to center it, etc. Any ideas? Thanks, Dave

Help My Microsft word program has suddenly lost its spellchecker. It gives the error message "Word cannot find the spelling file MSSpelll3.dll or Mssp232.dll". I have done nothing to change it and restore has not worked. A search of the computer cannnot find the files. The Woird program is a …

With normal folders, you can right click them and say "Remove from favorite folders, as per here: [url]http://office.microsoft.com/en-us/outlook/HA011176721033.aspx[/url] However, Calendar and Contacts don't have that option. How would one remove them? Thanks, David

dear experts, I just want to wave the last digit of each cell's value like 20001 should like 2000 using ms excel 2007. please consider this table: 20001 2000 20011 2001 20021 2002 20041 2004 20042 ???? 20043 20044 20045 20046 20051 20052 20053 20061 20062 20063 20071 any help …

i created an application by VSTO with MS Word 2007 and its all completed. but, the word document includes some check boxes and lables, and when i am opening the sheet its not showing the contents (the text) of lables or checkboxes. its giving me blank tool. please advise.

Typed letters keep getting thrown back into earlier part of sentence on ms word

Here's possibly the single most useful function that I use. It simply takes an ADO record set and dumps the column names and row values into an Excel worksheet. To use it make sure you have Excel marked in your project references.

I have a computer that I am de-commissioning which has Microsoft Office 2003 on it. I would like to move this software to the new computer which is replacing the old computer. 1. Can I do this or will the Microsoft Activation Process stop me in my tracks? I've already …

need to read and write to xls (excel sheet) using javascript read and write should be to specific cell in that sheet if its possible , please help do it thanx .

Can anybody tell me .How should i insert logo .simple i want to send my company logo.when send any email.When i go Tools->option-> Signature.i did not get any option regarding picture.i am using ms outlook 2007.kindly me know the idea.Any help would be highly appreciated.

I have to reboot a file server (with Home drives) but I have many users with gigantic network residing psts connected and I don't want to affect them. I'm not totally convinced anything will happen to corrupt the psts but I want to be careful. I could just send out …

Hi, I am creating an Excel 2007 add-in using Visual Studio 2008 and I have a Windows Form that allows a user to select a date. What I want to do is store that date in the Workbook that the user saves so that the plug-in can reference that date …

I have a ACER laptop and it has vista on it and from day one (2 years ago) it has been giving me problems. The most recent is that all of a sudden I can not access my documents. I have Microsoft office 2007 and its there I can see …

(Originally posted in XP forum, advised to try this forums) I have a ACER laptop and it has vista on it and from day one (2 years ago) it has been giving me problems. The most recent is that all of a sudden I can not access my documents. I …

If I am on a network and setting up a new pc for an established user.....when he goes to log in to outlook, I have to reset up his outlook account under his user name or can it be done through the admin account some way without having the user …

I want to make a rule when a e mail comes in to reply with a message, I know how to add the persons e mail in & then check off reply with .... ect.. Do these have to be certain type of files for it to work? Can anyone …

Hello everyone!! I have come to this community as a desperate seeker!! My IT knowledge would be considered minimal, but I get by in most instances with a search and give it a try attitude. Right now I'm having a problem with Outlook hanging up and I can't seem to …

Hi all, I have ms office2003 installed on my machine. Therefore I use Excel 11. I have excel export button which worked perfectly well before I installed VS2008 SP1 . After the installation I'm getting exception from my excel export button saying " Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" I delete and …

Hi Im composing a paid search campaign report and never done one before. What would you recommend me to do it on? Powerpoint or Excel? or even Word? Please advice. Thanks!

Hi, Im trying to transfer some text from the richTextBox into an existing MS word template at a specific location. I am able to transfer text to any location i like, but i want to retain the formatting of the text from the richTextBox. Im trying to copy the text …

Hi guys, I am writing (trying to write) a program in VBA for Excel 2003 and I got stuck, I need your help, please. I have an excel range where the upmost cell is initially fixed and the downmost cell moves down as more data arrive. In other words I …

We all know most business users use Excel to track sales and metrics. Thus, which tricks on Excel do you use that you strongly recommend for others to use? Please do share.

Dear Members, Please Help Me. I am in huge problem. Please Send a solution of this problem. problem is:- Read Table of Word File and take cell value and store in excel file using vb.net in VB Please Help me............ thanks Requesmd

Hi everybody I have've been asked to do something but I can get only to a point and I am now stuck. Please help. I have written a Sub in VBA for Excel 2003 (see below) in which the top cell of a range (WorkRange) is initially set at Cells(1,2), …