2,270 Topics
I want to get rid of all my paper documents. (that I'm able to) These include recepts, invoice copies, bills, college work, sketches, etc. What software is best to use for this? I'm running Windows XP and have a scanner. My main concern is document organisation after I have scanned …
My vb 2008 app uses Excel, but only briefly. Can I avoid referencing the Interop library Microsoft.Office.Interop,Excel?? Is there another way to link to Excel? In terms of its dealings with Excel, my app does little more than open a workbook and shade some cells. Many thanks
hi there, i have a excel file which have purchase order information. the file contains of the information of the user and the the items that he ordered with the order item quantity and the price but there may be any amount of items in the excel sheet. the thing …
Hi, Office 2007 running on Windows Vista Home Premium SP1 I have been presented with the above specced laptop to see if I can change the Office 2007 suite from Slovak to English. I have tried the following but has not worked. [url]http://office.microsoft.com/en-us/outlook/HA102517871033.aspx[/url] Although I cannot understand the language I …
hey, first time post, hopefully somebody knows the answer to this; A user running XP Pro and Office 2k3 recently had her reply emails' font change to a larger bold font that is driving her nuts. I tried checking the font settings under Tools>options>Mail Format>fonts, but they were ok and …
hey guys, this is me once again moving around data access. my problem now hide in the import process of an excel file that would be inserted into sql db. the problem is the excel file may be updated or changed and i have to periodically import it and perform …
hi guys, i am doing a project in which i am trying to capture input from vb.net interface use the captured input to do calculation in excel and return the output to vb.net interface. the major haddle is linking vb.net with excel. can anyone help?
We're running Server 2000 on TS boxes for MS Office XP access. We have a number of generic email accounts set up for bouncebacks, etc. from email campaigns. With one particular account, when there is a bounceback, Outlook will not pull the .txt files that include the details (ex. no …
in the attach file I want the selected area will be fixed. I mean when I page down this section not go up. this will fixed and the above thing only move. how I do it?
Hello, My copy of Microsoft Word 2007 doesn't Work. When I start it up, the process takes up about 4200k of RAM for 2 secs, then it cancels, no GUI appears. I did a Process Monitor scan, and it appears that a registry key is the culprit. specifically "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-21-2116093324-2522989915-1662506377-1008\Components" However …
Dears, I have an application that deals with MS Outlook. I want to save(serialize) an AppointmentItem object as XML file. Can I ??? Thanks in advance...
Can anyone offer help for the following Macro I am needing in Excel 2007. The function would be as follows. Need help with turning this into code. Thanks so much in advance!! 1) Open file name: Y:/P21.xls 2) Open file name: Y:/PriceSheet.xlt (Note: Pricesheet.xlt pulls data from P21.xls) 3) Save …
Hi, I'm developing this query for a dashboard using System Center Config Manager Dashboard. The query needs to produce a table which shows the number of computers which have Office 2007 Standard edition in one row, and the next row should show the number of computers which do not have …
Hi, I have a problem with office xp 2003 installation: " The feature you are trying to use is on a network resource that is unavailable" actually the feature is the Hebrew language , and it already exists in the CD. What have i to do to solve the problem …
I want to make a program that control powerpoint slides for example, when I start power point in presentation mode as I click the button, then slide goes to next. And when I click one more, then go next slide. I don't know how to send message to powerpoint in …
I have the xml from an Excel worksheet as given below. I would like to have a xslt to parse and extract the Excel rows in asimple xml format as given below based on the data picked from the named cells. I was able to collect data for each row. …
People who are unhappy with the progress of the military actions in Iran and Afghanistan finally have something to blame: PowerPoint. “PowerPoint makes us stupid,” Gen. James N. Mattis of the Marine Corps, the Joint Forces commander, said in an [URL="http://www.nytimes.com/2010/04/27/world/27powerpoint.html?emc=eta1"]article [/URL]in the [I]New York Times[/I] this week. The article …
good day to all.. i am new in making macro in excel and i want to make a macro that will copy a certain range to my active sheet and print it... I have a multiple file so i already made a form for the program that will ask the …
Hi I have a database with many staff members and each staff member has many Customers assigned to them. I want to export customer details to a separate excel file for each staff member. I don't want to have to do this manually as its going to take up time. …
hi i created an outlook 2003 Addin project and i want to install he Addin on a computer that doesn't have visual studio installed. i created all the necessary registry keys in the setup project, before running the setup project on the target pc i installed visual studio 2005 tools …
Im just learning and have made some userforms with text box's and comand butttons and i am trying to make them create a new excel workbook and save it. I have try'd all sorts of different code that i have found on the net but carn't get any to work.
Bonjour, Je suis entrain de développer une application en Csharp (console application), elle permet de détecter les fenetres ouvertes (celles de la barre de taches) et de donner leurs noms. Enfaite ce que je veux faire, c'est de détecter les chemins de ces fenetres, par exemple pour les fichiers word …
Using Office 2007 on Windows XP pro printing to an HP Laserjet 2200d. Margins in Word 2007 are set to 1" all around. Tab stops are set to default. Page layout on printer driver and Word are set to letter: 8 1/2 x 11. I create a page with information, …
I have a list of 100 values in excel. I want to use check boxes to select out the two or three of these values that apply in a specific instance. Simple enough. I create a form check box for each entity, click the ones I need and add the …
I'm spending a lot of time in Microsoft Word/Office and am finally frustrated enough with my problem to look for a solution. I couple of years ago bought a Dell c610 Latitude laptop with MS Office 2003 installed on it. "My wife lost the CD" was the reason given to …
Question I want a drop down list, where each item would have a separate value and when one item is selected, the corresponding value shall be posted in a separate cell. For example, say the items to appear on the list are A, B, C, D and the corresponding values …
From last three month i am searching a solution for my problem any box or form that i copy paste from internet to my exel sheet it can not be removed i have to copy all data to another exel sheet doe's any body have solution for this.??????????
I am running a mail merge and the excel sheet uses lookup formulas, the problem I am having is that on the merged word doc the cells that have a zero value are coming out on the word doc. Is there a way that I can do the merge so …
i have a database with names and id number. i also create an input sheet for sales. then i creat an invoice. here is what i need help with. when i put in any data on the input sheet i want it to be populated on the invoice. so on …
Hi everybody, Again, your help is highly appreciated. I have to develop a tool in Excel (VBA). I have three different worksheets. The first two are information about products, sorted by product number. In the third one, there should be a tool, which needs to calculate with information from the …
Hi, I was recently posed a question by a customer. This person has an extensive folder structure in outlook 03. She somehow lost a folder but definatley did not delete it. It appears that she accidentally dragged and dropped the folder into another folder somewhere in her directory tree and …
I am trying to have a Macro save an Excel 2007 spreadsheet as a PDF (I have the Save as PDF or XPS installed.) How can I get the file name to save as 2 cells concatenated? I am working with the following code so far. Any help greatly appreciated. …
I am battling with this code. I want to open a word document from a button and want the document (attendance register) to be available to resources once compiled and using on CD from another PC. At present having issues getting it right!!! [CODE]Public Class Form2 Private WordApp As New …
I had a failure in my Office 2003. I cannot go into repair it and I cannot remove it. I went through the office removal tool and it didn't work. I still have all my icons and I can still get into the programs but I get errors. I want …
Hi all I am trying to install my copy of Office Enterprize 2007 on another pc of mine, operating with XP Servicepack2. During the installation process, I get the message that the installation cannot find a file, something like ww\Enterprize\owowo(somenumber).CAB (Cannot remember the exact name now) and that I must …
I have an excel sheet which i have not open for almost 6 months and I have forgotten the password. Is there a way i can retrieve password. I have searches on internet but not getting a perfect cracker.
Please help! I have the following code in the head section of my web page: <script> ..... var serverLoc = "http://www.mydomain.com/mypath/"; var serverFile = serverLoc+"myexcel.xls"; var ehandle = new ActiveXObject("Excel.Application"); //error occurs var eWBhandle = ehandle.Workbooks.Open(serverFile); var eShandle = eWBhandle.ActiveSheet; var cell1 = eShandle.Cells(1,1).Value; // get more data ..... </script> …
if calculate any thing like: 5/2 then the result show 2.5. here I want the result show is 3. I mean if it is over .5 then it show the ground figure not show decimal. if is 2.4 then it show 2. please any body help me. i did it …
Hi, Just trying to figure out the best way to do this. We need to have our extranet users click on contacts on a web page and launch office communicator web chat. My question is, what is the best way to: 1. To implicitly login web user to OCS (it …
I'm trying to write a program and am having some major issues. I've written a decent program but people are complaining about some of the cosmetic issues. I have very little experience with code (maybe 10 days of frustrating Internet research). Here A few issues that i have that keep …
Hello there, I'm using the word processor for the first time and just learning as I go. Can anyone tell me how to remove or delete a blank page that I am not using?? Thank You :)
Hi, I'm exporting from a datatable to excel document (not CSV because I need some cell formatting) using this method found here: [URL="http://social.msdn.microsoft.com/forums/en-US/csharpgeneral/thread/08d69589-4052-410f-a85c-c38493c0a664/"]http://social.msdn.microsoft.com/forums/en-US/csharpgeneral/thread/08d69589-4052-410f-a85c-c38493c0a664/[/URL] Locally, it works fine, but when I upload to the server, I have been getting errors. The latest one is this: [CODE]Microsoft Office Excel cannot open or …
Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; how will the above code change when used in a website.. plz do reply fast..:'(its very urgent
One of our PCs is not printing footers with field codes; it is printing the field codes rather than the field results. For instance, one of the items in the footer is using the "Page X of Y" deal. It shows up correctly in the document itself as "Page 1 …
I've used the following code to open Excel. It works but generates a browser error warning the visitor that the web page is trying to run an add-on with an unknown name, and control with an unknown name. Is there a better way to open Excel (read only) in order …
hi there!!! need some help here everyone's welcome to help, i am currently viewing my output in excel & i have 5 columns in it ( a, b, c, d & e) column a & b must have 3 digits, c,d & e must have 4 digits, my problem is …
I am using XSL to transform the XML.I am generating a Excel sheet using XML/XSLT. I want to password protect the sheet. If a user try to modify any cell then it ask for password? <?xml version ="1.0" encoding ="utf-8" ?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:user="urn:my-scripts" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" …
Oracle 10g I have been trying to import an excel .xls spreadsheet into oracle. I can import everything fine but whenever I need to import a sheet that includes dates it does not work. Is there a special formatting I need to do with excel(THE DATE COLUMN??)(I have tried just …
Hello, I am using word 2003, and I want to print the gridlines that I have on the page. I copied the chart from excel. I can't seem to find where to change it in the print options. Can Anyone help. Thanks
Hi, I am extracting data from datagridview to Excel. But for columns with so many numbers Excel turns the format to 6,45646E+11 Is there a way that I can prevent this. I tried to use worksheets but I could not even save the data by using that. Here is my …
The End.