2,270 Topics
hi, i want to disable menu bar button(left-top) in office 2007 word document opened in windows form. please provide sample code. ASAP Thanks in advace...
Hi guys, I've got a strange, potientally easy problem with Outllok 2003/exhange 2003. When you click on reply, it opens up the message okay but it changes the font size to a stupidly small size. When you highlight the text, the font size says its 11 but its not. When …
Hi All, I am tasked to generate report templates in excel and I am new to excel, VBA and still learning. A little more information on my task, the information for the report will be extracted from different sheets in the workbook which contains a whole list of calculation and …
Hello, I have a bit of a problem. In C# I am doing an Windows Form Excel Addin using Visual Studio 2010. In my form I have a DatagridView that is connected to an Access databe and by pressing a button the user can send data to an Excel spreadsheet …
Hi, This is a problem googled easily, but no solution helped me. Locally I am trying to open a PowerPoint application to read and import a ppt (or pptx) file. this is the command where exception is thrown (ASP.NET VB): [CODE] objApplication = New Microsoft.Office.Interop.PowerPoint.Application [/CODE] the exception text is …
Dear Daniweb members. I am having quite a troublesome time here with OleDb. What I am trying to achieve is to allow my users to connect to an uploaded Excel workbook, then to be able to select data from the sheets. I have a query designer in the front end …
From this [article](http://www.daniweb.com/web-development/asp/threads/42314/exporting-asp-pages-to-excel) i found this code snippet that imports html data to excel: <% Response.ContentType = "application/vnd.ms-excel" Response.AddHeader "Content-Disposition", "filename=excelfile.xls" %> <table> <tr> <td>Category Name</td> <td>Category Description</td> </tr> <tr> <td>Software</td> <td>Holds data for software</td> </tr> <tr> <td>Hardware</td> <td>Hardware related data</td> </tr> </table> However, what i want to do is …
First of all, I realise there are a fair few related questions on many other sites, in addition to Microsoft Support pages. I have spent many hours on this issue, and this is where I stand and what I know/have been able to achieve: * I have an application written …
hi sys_ads, if you deploy office 2010 using GPO at Startup, does the users requires an Admin privileges for the setup to work? thanks for any input :)
Hi, I wanted to find out if there was a way to design a macro that takes information from a column in Excel to a text box on a webpage. I have over 600 records that I can input 15 at a time. I would like to run a macro …
Is it possible to alter Excel Viewer print settings via VB.NET and, if so, what is the syntax I need to do this? I would like my application to be able to change the printing preferences of an Excel spreadsheet opened in Excel Viewer (through the application via `Process.Start()`). This …
Hello, I am trying to read values from an excel spreadsheet but just for specific cells at a time; say Cell A1 and B1. Then I want to save the respective values into a variable and use the variable through out the rest of the code. Then loop at the …
Hi, I have taken one fileupload control and listbox. I wanted to show that, When i upload the excel file then after postback the following sheets should come in the listbox. Then after selecting the particular sheet, the data from that sheet should go in the database. So guys any …
I'm struggling to think of a reason why I should be getting an 'Access denied' error when trying to save an Excel document opened through a program written in VB 2010 Express. The program is essentially glorified Excel automation. It converts information from hundreds of Excel documents into a few …
Hi Guys.. I recently discovered that I am having issues with Windows Installer. I searched the web and tried a couple different things and finally found a thread on this site. I went through the steps and will post the results below. Also, when I open up Services, Windows Installer …
I need Delphi 2011 XE code for editing an Excel file. If there is found a text in a row of column A of the Excel file, to change the number of the same row in column B. That's all I need. Thanks!
how do i import my externanal contact in my ms outlook by using classic asp vb script programatically
I have a client who is running SBS 2008 and Windows XP Pro. On the Windows XP computers is running Office 2007. I am trying to stop people deleteing files but want to allow creation and modification. If I stop modify in the server 2008 SBS people are unable to …
How can I make a template with 4-6 pictures the will have some descriptive caption under each picture, my boss is wanting me to create a template for him, but I'm having trouble finding that in a premade template or maybe I have not looked in the right place. Please …
Hello guys, I am trying to insert watermark as text in word 2007 using c# but getting error can u pls help me out. here is my code... //THE LOGO IS ASSIGNED TO A SHAPE OBJECT SO THAT WE CAN USE ALL THE //SHAPE FORMATTING OPTIONS PRESENT FOR THE SHAPE …
Hello all, I have this C# code where in I am writing some datato an excel sheet and then saving it using saveas. But when I run the program again for the next time it is asking me prompt whether or not replace the exisiting file. I want it to …
hi.. im trying to export crystal report to excel. the export toolbar already appears.the crsytal report viewer is working properly.i can generate the report i want. but when i opened the excel file being exported,it shows blank worksheet, no data is being displayed.even headers and footers. im using cr 8 …
Office 2007 on a Windows 7 PC. A user has an intermittent problem where when she copies a cell with a formula in it, clipboard picks it up as text. Typically, if one pastes a copied cell with a formula it also puts the formula in the cell. Not always …
Hi, I am trying to add content to an excel sheet using the below code. However, when I open the excel sheet, nothing is added. Please advice. public class StepNoToExcel { HSSFWorkbook wb = null; String fileName = "C:\\StepNoForEvidences.xls"; File file = null; StepNoToExcel() { file = new File(fileName); if(!file.exists()) …
Hi, I have an application that converts the ascii characters within the excel file into hexa conversion ie. Ã to & #x00E0; but my application has one strict requirement and that is the excel file must be properly encoded in UTF-8. I have noticed that simply saving the excel file …
So, I'm currently trying to open a .xls/.xlsx file, tell it to run a macro to refresh the workbooks, and then save the file as a different file name, thus leaving the original untouched. Now, technically, it is working, because the last person who held my position wrote a dll …
i just upgraded a user from office 2007 to office 2010, now her documents that user to print in 2 pages is now printing on 4 pages and so on, please assist
Hi all, I have a issue in writing excel worksheet through OLEDB/Excel 8.0 provider where an apostrophe is coming in every cell before the value. When the excel worksheet is created through provider,cells are not getting as Text format and remaining as General even though I have denoted it as …
Can someone tell me how to install the speech recognition with microsoft office 2007? so far i only found speech recognition installations for office 2003. i need to install speech recognition for my microphone. Thanks
I'd like to say "hello" to everyone as it is my first post. I looked for the solution to my problem on the internet for over 2 hours and I didn't find anything relevant. I hope you are able to help me. I have a bunch of invoices written in …
Hi, I am using ms word 2003. My native language is Malayalam (in kerala). Now my work is to translate the script of Disney's Aladdin to Malayalam. Sometimes i need to know the meaning of some words. MS word gives me a few synonyms in English. But i need to …
Hi, Can you please help me to figure out how I can insert DataGridView values into a pre defined excel template (Into Specific Cells)? I have a DataGridView on my windows Form which is getting the values from user input. Now I would like to enable users to export the …
Good day, I am new in programing (still a student). I whant to write a c# program using winform, which will populate data from an external text file(as a array) into a textarea in the form, to check if each data in the textarea is present anywhere in a specified …
Hi all, I am trying to read data from an excel file using "xlrd" functions. File contains many columns one of which is Date and time (in MM/DD/YYYY and HH:MM:SS AM/PM format). I am successful in reading all other type of data. But unfortunately for this column, program could read …
I was told in an email to revise a document and submit the revised document "in clean and track change version." Not knowing what this meant, I asked for clarification and the sender explained that "track changes shows the change you made and a clean copy means you have accepted …
I have the code below and what it does is I have 2 summary sheets (Summary and Summary2). I have a rebuild code that whenever changes are made that would change the Summary sheet, the Summary sheet is copied to Summary2 as a backup copy. The code below keeps track …
I am uploading ".xlsx" files to one of my web page in a calendar. While reading the file i am getting a message "Excel found unreadable content in 'test.xlsx' Do you want to recover the contents of the workbook? If i say YES then the content is loading properly. How …
i have a problem with execute the excel sheet in java code and also problem with execute asa same as pivot table in java
Looking for some advice from a Windows perspective. Hopefully someone can relate, or at least understands what I am trying to accomplish (keep in mind the "path of least resistance"). I am open to multiple suggestions and paradigms, just try to sugar coat if you can :) I know something …
Would any IT people out there have any IT word templates for statements, assessments, analyses? For an example, if we have to inspect a room’s tech equipment like computer and printers, then write up a quick summery or a detailed summery of what was wrong with the equipment, or asked …
I am trying to create a powerpoint quiz that tallies the scores, provides the results e.g. 95 out of 100 and the percentage %, then writes the users name and results to an excel spreadsheet. Oh, and all this has to be done using Office 2007 products. Can anyone help? …
Office Addin Hello all I've searched Google for hours, with no success. I have developed an Office 2010 addin application. The application adds another form to Outlook.(Form Region) The application (let's call it A) works great! I can send emails from my Outlook with this form (filled or not filled …
I brought the following text lines into Word 10 (aka 2002) & added the ~'s to the blank line paragraphs: How can I transform the address 'records' into tables sortable on name ? name phone adrs adrs ~ name phone adrs adrs ~ etc.... about 120 of these. If I …
My process is to multiply the given points in B8, D8, F8, H8, J8, L8, and N8 to A3, B3, C3, D3, E3, F3, G3 respectively. this procedure is to be processed in C8, E8, G8, I8, K8, M8, and O8. after multiplying, the process should perform =sum(C8,E8,G8,I8,K8,M8,O8) to P8. …
I would like to enter some text into a text box field in a Word Form and have the text printed next to it in barcode format. This is so I can have both human readable and barcodes available on the form. I have the barcode fonts that I need …
I am trying to program the last part of an application which needs to take data from an Excel sheet and add it to an Access table. I'm using Excel 2003 on XP. Any and ALL help is appreciated. The problem I'm running into seems to be on connecting to …
In C# i need to read the Excel File using Interop. I am using : **using Excel = Microsoft.Office.Interop.Excel;** And i am able to read data from Excel File. Problem is in my Sample Excel File there are only 6 rows and it also reading more than six rows. It …
Helloooo Firstly, ive done a bit of googling, and found a few articles relating to my problem. None seem to help though. I require a simple method of acquiring the "Page Number" of the selected cell. range1.Information(wdActiveEndPageNumber) Something like this, does not work. Even though i read that it does. …
My question revolves around increasing the maximum mailbox size in outlook and what the dword values represent in the registry. I recenetly encounted a problem where someone I support reached a 20gig mailbox size in outlook 2007 which is the maximum default size in outlook. The exchange server has an …
Firstly, im not sure if this is the correct location for a VBA question? Please move if necassary. This is my first major project using VBA - Ive previosuly used vb.net quite alot, and still adjusting to understand both, and the differences. My question is: I have a folder with …
The End.