[office-suite] Forum Topics

Hello All, I need some help to convert the macro I recorded in Excel into a working Vb.Net application. It involves attaching a file into a Excel cell. The file is a Word document named "File.doc". Here's the recorded macro: Sub DemoAttachFile() Workbooks("Book1").Activate Sheets("Sheet1").Select Range("B2").Select ActiveSheet.OLEObjects.Add(Filename:= _ "C:\Documents and Settings\File.doc", …

Hi, I have 13 OpenOffice Impress files (ODP) with a total of about 300 slides containing text and pictures. I need to convert these into 1 OpenOffice Writer file (ODT). I have been trying and searching for some time now, but I didn't found a good solution yet... besides manually …

is there any way to show a powerpoint presentation on a webbrowser control ? office 2007 .net 3.5 ?

OK, so I am attempting to create a workbook which when opened has only a main page with several buttons for the user to use. When a button is activated, it takes a hidden sheet and copies it into the document with certain fields altered. Each sheet has its own …

Office 2003 on Windows 7. Phone number fields can only be formatted as text. There are no other options. Any Ideas?

I have been trying to resolve this an to no avail. I tried creating an instance of the objects and it is still not debugging correctly ...I would greatly appreciate any assistance possible... The code I have entered is supposed to create a word table in word with a heading …

Hi, I need to write a program to send data from a particular excel sheet in a workbook to a notepad. Say,I've an xl sheet with the following columns: "Name,Age,Salary" with values "john,24,1000" respectievely,Now I need a C# program to read the xl sheet and write the values onto the …

Working with MS Project Professional 2007. My business is too small to use Project Server. Looking for a workaround so that I can post milestones, tasks, alerts, etc. so that others can see. I have a website and can create a sub web. Is there a 'poor man's' way to …

Hello All, I am in a roadblock right now and I really need some help on the code below. What I wanted to do is close all opened workbooks. This code does the work IF there is at least one or more opened workbooks. My problem is IF there is …

I've recently written a C# application that used Word input files and outputted a single Excel file. The output part worked flawlessly, yet the input part caused me a lot of headaches. It were a hundred or so Word files, and every so often the program would crash (on a …

Office 2010 awaits us later this year, and I've been wondering what it could possibly offer customers that would compel us to buy or upgrade to this software. Office software in general progressed about as far as most of us needed it to go somewhere in the 90s. Since then …

Hi All, I am new with the send keys in VBA. Basically I'd like to send a bunch of sendkeys. I don't have problem with the synthax but the problem is that excel only execute the 1st sendkeys I have written. [CODE]Sub test() SendKeys ("^+F") Wait SendKeys ("^+L") End Sub[/CODE] …

Hey, Im not sure if this is the right place to post this, but I need some help. I have 14 classes of 40 students each and I need to make a grade book with excel. Here's what I need help with: I'm adding grades to column G, in column …

when i tried to uninstall ms office 2003 i got error this action is only valid for Products that are currently installed.can anbody tell me why i am getting this error.program still there in the add/remove Programme.Kindly let me know the idea.Any help would be highly appreciated.

Hello everyone! I am a geotechnical engineer and have been tasked with editing hundreds of excel files all in the same way so I decided to go back to my college intro to C days and make VBA do all of my dirty work! Anyhow, *I* think I am having …

Hi guys, i would like to ask that is there anyway to embedded an excel file into a vb.net project? i know the way to read an excel file from vb.net, but i would wanna know is there anyway i can include the excel file inside the vb.net program. This …

Hi I have been trying to figure something out in Excel but have been getting nowhere. My problem is that I need cell J5 to highlight and display a message if all the cells from D5 - I5 are highlighted. I would be grateful if someone could could help me …

Title says it. Old Dell died, I had Office 2003 Professional from Dell, but on MS disks that appear to be retail type. New computer is running Windows 7 (64 bit). Install appeared normal with activation codes, program operations are OK with one or two unexplained shutdowns. Ive been running …

I i have a table in excel with some movies and i want to extract it to XML using XSLT. How can i do that. movie 1 | actor 1| 2009 | ... movie 2 | actor 2 | 2010 | ...

At the moment I cannot use any of my Office applications (word Excel etc.) because as soon as you start typing anything spell check comes up and makes it unusable. If you close the box, the very next letter the spellceck box opens again. This makes life incredibally frustrating as …

1. My adult daughter’s Toshiba Satellite computer started acting strangely lately. At first only rarely, but finally almost every time it was used, it kept popping up a dialog box purporting to show “search results” even though none had been asked for. Closing the box merely brought up another one, …

Hi Everybody, I am writing a simple program which connect MySQL reads each line of a table content and writing to an Excel file line by line. I want the procedure start onClick of a start button. I am quite new to c# and NOT good with the classes etc. …

Hello All Does anyone know how to pass data from a textbox into a pre-defined outlook message? I have some code I found which does a search for certain words in Microsoft Word documents and replaces them with the values from a textbox but when I try to convert this …

I have an excel addon and a user defined function the formula of which does some computations. The results after executing the formula must be stored and retrieved when the same excel file opens again. I am using a DataSet object to store the results from the formula at present. …

First, my disclaimer is that I am not familiar with Excel or VB :( That being said, one of my users is getting an error when running a macro in Excel 2007 from his personal.xlsm. The macro is a simple color change which we have re-recorded several times but when …

I want to assign a color to my excel column [CODE] currentRow.Interior.ColorIndex = 17; [/CODE] But I don't want to use one of the colors in the excel palette I do I add my own color. for instances: [CODE] currentRow.Interior.Color = Color.LightBlue; [/CODE] Thanks for the help

Hi, I am having problems with Outlook 2000 ([URL="http://www.daniweb.com/techtalkforums/post347611.html#"]PC[/URL]). Often, I have to restart my computer 3 times before I can get Outlook to launch! Either the program hangs/freezes on the splash screen when i try to launch it, or it freezes when I try to switch from 1 folder …

السلام عليكم ورحمة الله وبركاتة Hi All, I have a small problem, I'm making a small application to change the attributes of a word documents so I created a word object and at the end of my code I called the Word._Application.Quit Method, When I run the code on a …

Hi Within AD (win2003) I have got two separate users accounts one of them is called General Manager and other is called info. General Manager user has an email address which is : [email]generalmanager@forum.org[/email] and info has an email address which is : [email]info@forum.org[/email] While a go a general Manger …

Yesterday, the [URL="http://www.businessweek.com/technology/content/dec2009/tc20091222_416170.htm"]Federal Appeals Court ruled[/URL] in what appears at first blush to be a shocking decision, that Microsoft must stop selling Word 2007 by January 11, 2010. But a closer look at the decision suggests that this isn't as big a deal as it first seems. Sure, Microsoft has …

I really need Microsoft Visio 2003 for our flowchart in cs120. Can anyone help me where can I download it? I tried to download the sp3 but it won't work. It said that i am not allowed or something like that. pretty please? thank you.

How do I assign a macro for a selected check box in one worksheet and copy the entire row onto another worksheet? What should I do if I have selected some rows and I want all of those selected in the check box appear on the new worksheet? Anybody out …

Oh dear, now I do not believe that was meant to happen. It appears that users of Office 2003 who also protect their documents with the Microsoft Rights Management Service (RMS) have found them so well protected that nobody can open them - not even the person who created the …

Hello ! to all viewer, Please solve my hot issue that is my word file is corrupt, when i open word (*.doc) file then display Convert text option and not display my text data only show garbage style. How i can recovery or repair word file please Urgent Help required.

This is the first time it has happened. I opened my calendar in Outlook 2003 and a mass of entries are missing. The operating system I use is Windows XP Professional version 2002 service pack 3. The anti virus I use is ‘Avast!’ which seems to update daily. Outlook has …

Is there a fix to make Word 2000 run in Windows 7? Compatability tester says it is incompatible but offers no suggestions. I have tried to run it in XP compatability mode without success.

Hello i want 2 install 003 in win 7 which i have office 07 is trail version ....if its possibele 2 install and reinstall another office 07 which i have .

hi im creating an application that query data from fox pro, manipulate it and export it to excel. here is the code im using to creat excel object: Dim oExcel As New Excel.Application Dim obook As Excel.Workbook = oExcel.Workbooks.Add im getting excell.application underlined(error msg:new cannot be used on an interface) …

Hi I'm currently stuck in an infinite loop because of the code I've written and i can't stop the code, close excel etc. Basically the code runs after a cell change, displays a msgbox and then causes itself to run again, and while this is happening i can't do anything …

Hi, i am new to python world my problem is that i am getting a output file from a software which is very messy first i just want to delete first 3 rows and the columns F onwards from the excel file and that i just want to change the …

hi guys does their any software that do the followings: suppose you have two different sheets of Microsoft excel 2007 like sheet 1 and sheet 2 in sheet one their are three columns A, B and C on other hand we have sheet 2 that contains only two columns like …

Hi, just a quick question.. say a user enters a number in a cell how would i be able to get all cells that contained that number to be highlighted? Thanks

I have a login form created in VS 2008 and I want it to run an Outlook 2007 addin i created in C# if the login credentials are correct. So the basic process would be to 1. Enter login details 2. Click Login button 3. If correct details, run Outlook …

First off, let me be honest in saying that this is homework. I am not asking for it to be done for me, merely some help in figuring out what I have messed up. Secondly, I am not good with VB, nor do I particularly care for it, but seeing …

So I just got Windows 7 64-bit and I also have a copy of Microsoft Office Home and Student 2007. My computer isn't recognizing the disc at all. It's as if there is nothing in the E drive. Any suggestions? (I have a key, but I can't seem to download …

Greetings...I am new to this sort of thing and hope I am in the right place. I need help from someone who has had a similar problem and can help me. My problem has only occured in the last week or so. When I try to open a file in …

Hi, Can someone please show me step by step how to use the Microsoft Office Spreadsheet COM component in VB.NET, and how to package and deploy it to a client machine which only runs XP with .NET framework 3.5. I am a newbie, please help. Thanks.

signup for now for Microsoft Office 2010 Beta ,if you want . [url]http://officebeta.microsoft.com/en-ca/products/?CTT=97[/url] support after .same site actually [url]http://officebeta.microsoft.com/en-ca/support/?CTT=97[/url] ====================== Here are a few new features to help you get started with Microsoft Office 2010. Introducing Microsoft Office Backstage™ view and customizable Ribbon. Whether it’s creating a new file, adding …

Hey everyone, I've been working on a project for my job and I've become stuck. I'm trying to figure out a way to extract or export all macros from an excel workbook to a folder on my filesystem. Is there a way of doing this with out creating a program …

Hi, just a quick question.. say a user enters a number in a cell how would i be able to get all cells that contained that number to be highlighted? Thanks