[office-suite] Forum Topics

Hi everyone, I have a code which converts a html page into excel file. The following code has been working well so far, but Im having a problem of converting the html page into excel file after I had changed the localhost to another server. It's not able to generate …

hi friends,when i tried to open my Ms Access 2003 file in Ms Access 2007 .i am getting the following error .Kindly let me know the idea .any help would be highly appreciated. [code] This error can appear if you try to convert an Access 97 database to a more …

Hi guys, i am facing problem when i need to create an excel file and insert some data inside. Can anyone help me? i am using vs 2005 and excel 2003.

Hello for all i want to collected data from pdf form inserted in excel spredsheet i try many methode and some program for (PDF to Excel) but not work i have acrobat x pro and my pdf form (text,number ,pictures). and get data for all it's possible if any body …

first go to toolbar it is in office 10 >more commands->show all commands ->speak selected text -> add this now select Ur whole text and press speak toolbar "now enjoy" in older ms word try this Click on the View option at the top of your Word document. Open the …

I need to do the following: -> open Excel file -> change values of required cells -> then save the file right now I am doing this: [code] Excel.Application xlAppoutput = null; Excel.Workbook xlWorkBookoutput = null; Excel.Worksheet xlWorkSheetoutput = null; Excel.Range rangeoutput = null; try { xlAppoutput = new Excel.ApplicationClass(); …

I am creating an application using Microsoft.Office.Interop framework (C#) for Excel. And the issue that I am trying to figure out is whether or not I can somehow attach an existing excel file with a format template to the application? In other words, is there a way to use a …

Hi All, As shown below, I have already managed to disable all menu items from the QAT. However I would also like the menu option to be completely removed! [code] <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <commands> <command idMso="ApplicationOptionsDialog" enabled="false"/> <command idMso="FileExit" enabled="false"/> <command idMso="Help" enabled = "false"/> </commands> <ribbon startFromScratch="true"> <officeMenu> <button idMso="FileCompactAndRepairDatabase" …

I have created an application that uses Microsoft.Office.Interop for Excel. I'm trying to implement both an OpenFileDialog and a SaveFileDialog. I got the OpenFileDialog to work, but I have run into a wall on the SaveFileDialog. Because when I get to the SaveFileDialog box, it lets me pick the location, …

Hi all I'm looking to do what as far as I know is a straight forward enough task in excel...............just can't think the best way of doing it!! I am taking registrations for a course and I have two columns (K&L) for paid and fee Column L is the fee …

I've been googling, and googling this topic, but can't seem to find an answer. I'm using the Microsoft.Office.Interop for Excel (and using C#). I have a worksheet that has a table with 7 columns, and a dynamic number of rows. I cannot for the life of me figure out how …

i have two dbf that should write in excel file,,ive already done writing on the first table my problem is how can i join the other table from the other but theyre not going to combine,,first table id in the upper part and the second table is in lower part,,

The project I'm working on has a bit of code in the workbook open event that makes excel go full screen, hide any toolbars that a user has configured to run in fullscreen (and make a note so they can be restored on exit) and loads a custom toolbar. [code] …

I'm looking for some help from anyone with some knowledge of the Microsoft.Office.Interop.Excel class. Specifically, what I am trying to do at the moment is to iterate through a single column range so that I can A.) extract each unique value in that range, and B.) also (in another method) …

Hi I would like to get the connection string for both 2003 excel (*.xls) and 2007 excel (*.xlsx). I want to read both files depends upon the selection. When I was using this code [CODE] Dim cn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & a_sFilepath & ";Extended Properties= Excel 8.0;HDR=YES;") [/CODE] I …

This code is to generate excel with grid lines in it with file name as you given in the code which will disply when you opening throug the download dialog box, Regards, khaleel

<!---to open excel with given name---> <cfheader name="Content-Disposition" value="attachment;filename=#lFilenameCreated#"> <cfcontent type="application/vnd.ms-excel"> <!---<cfcontent type="application/vnd.ms-excel" > <cfheader name="Content-Disposition" value="filename=SchoolReport.xls">---> </cfoutput> <html xmlns:o="urn:schemas-microsoft-com:office:excel" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <head> <TITLE>CTY Information System - School Report</TITLE> <meta http-equiv="Content-Type" content="text/html;charset=windows-1252"> <!---To get gridlines in excel file---> <xml > <x:ExcelWorkbook > <x:Name>School Report</x:Name> <x:ExcelWorksheets > <x:ExcelWorksheet > <x:Name>School Report</x:Name> …

Whenever I open in Microsoft Word (2003 & 2007) a Courier document created in a Mac program that has italicised words in it, Word converts those words into italicised Courier-Oblique font which looks very odd and I have to highlight those words and change them back to plain italicised Courier. …

I have a excel spreadsheet that contains the following information: part name, part number, calibration, rev. level and other information. I also have a form that I have to fill out every month using the information from the above mentioned spreadsheet. Is there a way to input the spreadsheet information …

Hi, I'm supposed to create a little program that will allow you to select a range of dates and graph prices based on those dates. The data would come from an Access table. I know Excel allows you to pull in data from Access, but I'm not sure how to …

I love my Office 97 (I fear change And won't pay bill gates hundreds of dollars for an upgrade to office 2007). I installed office 97 on my new Vista computer. Everything works (word, access powerpoint, excel) except outlook. i get an error message that says "cannot start microsoft outlook". …

Sometimes my Office 2007 Outlook clipboard captures a copy; sometimes it does not. I can't identify any pattern to it. What can I do to restore it to complete functionality?

I am trying to sum data from a database using excel. The following gets me results for one criteria but I need help with this formula for multiple criteria. In other words "sum values where condition is both criteria 1 and 2 at the same time"...the formula is below. Start …

Hi guys & gals, I accidentally deleted a folder from my outlook and then emptied the deleted items. The notes say i need to click the deleted items folder and then tools>[B][I]Recover Deleted Items [/I][/B]BUT I have No menu item for that! i've updated to the latest version of outlook …

I am just trying to get some information. Currently we have a C sharp code,looking into a trading, which drags real time date of a stock and stores it into a data base as a CSV file. However I require this live data to be autopopulated into an Open excel …

Outlook tips [url]http://office.microsoft.com/en-us/outlook/15-essential-tips-to-get-the-most-out-of-outlook-FX102628187.aspx?WT.mc_id=oo_enus_eml_MT2OLKprod2[/url] PowerPoint tips [url]http://blogs.office.com/b/microsoft-powerpoint/archive/2011/05/02/present-your-message-to-anyone-anywhere-with-broadcast-slideshow.aspx?WT.mc_id=oo_enus_eml_MT2PPTbroad2[/url] OneNote ,around the word in 40 days [url]http://www.microsoft.com/office/onenote-vacationplanning/[/url]

Hi, Does anyone know on how to convert vb.net to excel. I am new in this company and they are using Microsoft SQL Server Management Studio for their database. FYI, they are using stored procedure as well. Thank you

I am using Windows XP with Outlook 2003. I have a very frustrating problem with Outlook. I periodically toggle between sending in plain text and html. However, I know that any incoming html mail is supposed to default to be viewed in html. Every message that comes to me is …

Hello I need your help with a simple Excel issue: This is what I have COLUMN 1 COLUMN 2 COLUMN 3 125 YES 304 NO 1549 YES Here is what I need: If the string in COLUMN 2 is 'YES', copy the value in COLUMN 1 to COLUMN 3. What …

Hi, I have successfully downloaded the Service Pack for Office 2003, but the update will not install as I get the following error message: "The feature you are trying to use is on a network resourse that is unavialble. Click okay to try again or enter and alternate path to …

Hi everyone, I have this problem, I developed the program in C#(winform) in my computer, when I try to publish it and install in my computer, it works fine. But when other users with different computer install, the are receiving this error : unable to install or run the application. …

I have a problem with Excel 2003. Every time I open the program I get a MS Visual Basic Error that says: Compile error in hidden module: AutoExecNew (when i open it) Compile error in hidden module: DistMon (when i close it) I installed MS Office 2003 Professional on my …

hi the code which i use to export a data table to excel works fine..... but when i open the excel file it gives me the following warning THE FILE YOU ARE TRYING TO OPEN IS IN A DIFFERENT FORMAT THAN SPECIFIED BY THE EXTENSION. VERIFY THAT THE FILE IS …

Hi Everyone, Can somebody please help me with this. I have this gridview and I have binded it properly, now I have a button and I want to export the data inside the datagrid to excel. I can do this in asp.net because the code is quite easy for the …

Hi, I will be uploading the EXCEL data (or CSV data). By clicking the SUBMIT BUTTON, i wants [B]to open and to read the data[/B] of this uploaded excel file and at the same time wants to save this uploaded excel data(content) to my database. I don't wants to save …

I have loaded a .TXT file into an array, and want to display each of the posts in the array in a grid. Any pointers how to start attacking this beast? Have tried using Datagrid, and failed :( I have a "Learn by doing" approach to VB.NET, so I need …

I have this code: [CODE]import csv tally=0 i=0 n=1 numb=2 count = sum(1 for row in csv.reader( open('cities.csv') ) ) cityname = csv.reader(open("cities.csv", "rb")) citynames = [] citynames.extend(cityname) for data in citynames: citynames.append(data[0]) tally+=1 if tally>=count: break tally=0 cities_x = csv.reader(open("cities.csv", "rb")) cities_list_x = [] cities_list_x.extend(cities_x) names = [] for …

hi am having problem in saving datagridview data to excel file.. i have import excel namespace into my project but it shows [COLOR="red"] error : Namespace or type specified in the Imports 'class2' doesn't contain any public member or cannot be found. Make sure the namespace or the type is …

hi, i have a destop application and i have data in 4 arrays, what i want to do is to open an excel file and then add the array data into the excel file, nd then save the excel file . please how can i do it i tryied using …

Hi all, I'm trying to do something simple, but I've been away from writing any code for so long (and I wasn't that good at it to begin with) and I am trying to generate a rectangular arry in excel using a VB macro. For simplification, what I would like …

Hi All, Please find the following requirement and let me know the possibilities if any. We have some daily,weekly and monthly jobs which will run parallelly.we need to monitor the jobs.there we have start time ,we need to find out the end time and need to paste it in excel …

I am creating a Delphi program that needs to extract data from our database and create an Excel report. I would prefer to use the Delphi components TExcelApplication, TExcelWorkbook and TExcelWorksheet, but I haven't been able to get them to work. Most of the examples I have found are fairly …

Dear Helpful Members of Daniweb, I have been working on several projects to automate work in the company I am working for and have come to the following problem: I have a VBA6 program I have successfully programmed to calculate the costs of our fasteners and anchors, now it is …

Who remembers Clippy?[ATTACH=LEFT]18033[/ATTACH]

So I have someone send out a joke .ppt file in my office, and now im getting requests from users to install powerpoint on their machine. I know its because of the joke email, because its from users who would never need powerpoint for their job. How do you handle …

I've got a funky situation here that I think a script could solve, but I'm no good at scripting Excel, so there! It's Excel 2007 btw. My online store exports a CSV of orders along with the line items of the order. To accomplish this, it outputs one row as …

Hi, I'm building an application that tracks certain information of my customers so that I can keep it all in order and in one place so I'm pretty much done however I'm trying to populate the excel sheet, but I'm not too sure how to add new customers without deleting …

Hi All, I am not an ardent developer in vb.net programming. But off late I am using vb.net to develop a windows application. The following is what I am trying to do: I am reading an excel file and storing the string value present in each cell, and trying to …

Hello, Could someone please help me with this problem? I have developed a small application that calls up several powerpoint slideshows that are saved as .pps. The user interface screen has a textbox, when the user enters the file name of the powerpoint it is called up, but it opens …

Hi, This is my code : [ICODE] Microsoft.Office.Interop.PowerPoint.Application application = new Microsoft.Office.Interop.PowerPoint.Application(); string filePath = Server.MapPath(@"~\\Staf\\TestDoc\\" + strFileName.ToString()); Microsoft.Office.Interop.PowerPoint.Presentation pptPresentation = application.Presentations.Open(filePath, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoFalse); application.Visible = Microsoft.Office.Core.MsoTriState.msoTrue; StringBuilder sb = new StringBuilder(); int page = pptPresentation.Slides.Count; for (int num = 1; num < page + 1; num++) { Microsoft.Office.Interop.PowerPoint.Shapes …