[office-suite] Forum Topics

Sorry - might be a noob question and there's no section for Microsoft office, but this is the closest section I can get. I just installed outlook and am using it for the first time. I added an email and it shows up on the left, but I also want …

Hello Community, I was wondering if there is a way to make a program that will copy text from an excel spreatsheet and place it in another using visualbasic.net not vba? Please Help

hi everyone there, yesterday we were trying to extract the text from jpeg file and wanted to add it to word,but we couldn't Is there any way out there to do that workout,is any software available there which can help me???/ please answer this..........

Hello Community, I was wondering if there is a way to replace a cell value from one excel spreadsheet and save it as another spreadsheet but with the replaced cell value. Please Help

Here is what I am trying to do: From VB.net open a word template --- Done Populate it from a database ------Done Have word report back with the saved file name so as I can add it to the database history ----Not done. I know is has something to do …

I have always used Excel.interop before but I thought oledb would be simpler because, for this application, I only have to read the data which it can't seem to do. It accesses the file alright because I can't open the file while I am at a breakpoint. It attempts to …

Hi , I am developing a windows application using C#. In that I want to display all the outlook profiles in a listbox and on selecting one, The folder structure should be displayed on a treeview control. I can display all the profiles in the listbox and on its changedindex …

Hi, I've been searching net for quite some time now, but I can't seem to find what I'm looking for, which is simple software where I can add my clients and track who has payed his bill, who hasn't and who will soon have to . I know that microsoft …

Good day, I keep running into a very persistent "Could not fine installable ISAM" error when trying to connect to an Excel sheet (office 2010) by opening an OledbConnection Here's my connection string: Dim strCon As String strCon = "Provider=Microsoft.ACE.OLEDB.12.0;ACE OLEDB:Database Password=" & strEnter & ";Data Source= " & strExcel …

I would to add row values in an array each column will be an array value. echo '<table>' . "\n"; for ($row = 1; $row <= $highestRow; ++$row) { echo '<tr>' . "\n"; for ($col = 0; $col <= $highestColumnIndex; ++$col) { $values = '<td>' . $objWorksheet->getCellByColumnAndRow($col, $row)->getValue() . '</td>' …

Hi Using VB.NET I created an excel sheet with list of items in dropdownlist. Using the below code With xlWorksheet.Range("A2", "A101").Validation .Add(Type:=Microsoft.Office.Interop.Excel.XlDVType.xlValidateList, AlertStyle:=Microsoft.Office.Interop.Excel.XlDVAlertStyle.xlValidAlertStop, Operator:=Microsoft.Office.Interop.Excel.XlFormatConditionOperator.xlBetween, Formula1:=[COLOR="Red"]"Construct,Testing,Review,Look Ahead Meetings,Process Audit,Process Improvement,Project Monitoring and control,Project Planning,Project Setup,Project Team Management,RCA Activities,Re-Estimation,Review,Review-Rework,Senior Management Reviews, Testing,Testing Rework,Training, Work Product Audit"[/COLOR]) End With But i can able …

im making a student marksheet generation project.....and i need a facility to print from turbo c++ to excel.... i have used only file handling and no database(tht was the criteria). pls help.....

I need to export DataTable to Excel file. Is tehre anyone help me? I dont want to listview to excel... Regards.

I want 1 dialog box which is having a login username and Password field. ANd it must have 12 buttons. whenever i click on any button, it must open 1 Excel sheet associated with it. Just want 1 skeleton code.

The cell values in excel are all formatted as text. Each value in the source array is not a String but to a proper data type based upon its value but I want the cell formatted value as it would appear on the screen in excel. Some of the cells …

A client of ours uses Outlook 2007. They have recently reported an issue with attaching files to emails. Here is the issue that pops up...  This happens when trying to open a folder to find the file to attach. This only happens with a couple of the folders. …

long time listener, first time caller... I'm trying to generate Excel charts using c#. I'm using Excel.Range to set a range (series of values) to plot. However, I'd like to plot two series that are not next to each other. For example, B1:B10 and G1:G10 versus A1:A10 on the x-axis. …

I am trying to open an instance of Excel 2007 and load some text into a new file's cells (such as a list of something) through my Delphi4 program. I have already tried the ShellExecute and ComObj (variant) methods. ShellExecute works fine on the Windows XP platform, but not on …

roll no. name 2/12/2012 14/12/2012 23/12/2012 12 james 56 90 88 23 philip n/a 99 76 45 rosy 55 n/a 85 6 peter 59 74 45 13 sam 69 73 n/a this data i have in excel sheet,i want to write a vba code that depicts individual student's performance in …

When I see an article starting with the sentence saying a company offering free software has urged people to start reaping the benefits of free software, I get this sinking feeling. I mean, they would, wouldn't they - it's a bit like Microsoft saying everyone should get the benefit of …

I wasn't quite sure where to post this so I thought considering SSRS in VS 2005 produces XML scripts i thought this would be the best forum. I have a table grouping which produces a number of tables using the same section of xml code. Due to this the problem …

Hi All,, I want to add new leave type which its respective purple color to the already existing template by microsoft office available at "http://office.microsoft.com/en-us/templates/results.aspx?qu=employee%20attendance&queryid=194963f8-3883-4599-b317-3dbd92b705c5#ai:TC102780235". Anyone could help me how to add new add new leave type and its color to the year column. Thanks in advance Jos

I want to make student management system in which student will enter his data and we can save it in any other program such as word, excel. And when he will open again he can get his data back..

http://oi48.tinypic.com/9rovuc.jpg 1.see the image. Let's see there are hundreds of different families like that in another sheet. how to group those by family members? EX: all FATHER,MOTHER goes to a one group. all FATHER,MOTHER,SON goes to another group. like that. first, all the mother,father families are grouped together. then all …

I downloaded McAfee Personal Firewall Express v4.5 to my computer. Since I have done this, my computer sometimes freezes when I boot up. When it freezes, I hit Ctrl + Alt + Dlt. It says that Microsoft Office Shortcut Bar Not Responding. When this happens, I turn off the computer …

Macro to import excel files into another excel and another macro to automatically plot graph with the data imported from the excel file. Pls assist with a demo sample. Thank alot for coming to my aid

Not sure if this can be done. There are word files in a directory with all familiar names. i.e. fr001, fr002, fr003, etc... all with the extension .doc. I would like to know is there a code that will link an excel file to a directory and then be able …

Sir I have a doc file,which doesn't open in any microsoft office.when you open this file in any microsoft office,its shows some unreadable characters as shows in below picture.so what can i do? any help plz..... Hamza Murad 

Dear C++ Gurus/Experts, I am writing a program to automate excel.My program is working well when I use integer (Write/Read) in excel.My program also works well when I use string.But the issue appears when I use array of strings.I am getting the issue as below **"error C2664: 'SysAllocString' : cannot …

Hi! I have a php code that generates an excel file that is populated with mysql data of course through a mysql_query.. Here it is.. <?php require("aacfs.php"); header("Content-type: application/ms-excel"); header("Content-Disposition: attachment; filename=Reservation Summary_sortbydate.xls"); header("Pragma: no-cache"); header("Expires: 0"); $head1="Ayala Aviation Corporation"; $head2="RESERVATION SUMMARY"; $head3="For the period ___________"; $heads="$head1\n$head2\n$head3\n"; $query = "select …

Hi, I'm trying to generate Docx files using python. I searched the web and found a module: https://github.com/mikemaccana/python-docx/blob/master/README.markdown It says to install using easy_install or pip, which I have no idea how to do. I also have a mac so I think that makes it a little more complicated. I'm …

I have problem with writing csv file using **fputcsv**. Its putting the page html also into the csv file. Whats wrong with my code ? //Excel header header("Content-Disposition: attachment; filename=\"Delivery_Reports.csv\";" ); header("Content-type: application/vnd.ms-excel"); $out = fopen("php://output", 'w'); $flag = false; // $result = mysql_query("SELECT * FROM senderids ") or die('Query …

Hi Daniweb, I've been using perl for Regex recently and I want to know is it possible to create an Excel Movie Library with the movie poster, the name of that file and a hyperlink of that clip is attached to the poster. Any help is appreciated. thanks.

Hi, I'm trying to export data from excel sheet to my grid, I'm using the foll code, but I get an error at DataGridView1.Rows.Add(), saying rows cannot be added programmatically. Private Sub btnexport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnexport.Click Dim xlsApp As Microsoft.Office.Interop.Excel.Application Dim xlsbook As Microsoft.Office.Interop.Excel.Workbook …

Hi all, Not sure if this is something that is possible or not but what i'm looking for is as follows....... I have an excel sheet of football league tables. The sheet automatically updates when I enter in results I'm looking for a way (prefibally in HTML as i'm fairly …

help i have this set of data: (X),(Y) 10,50 20,15 30,100 40,100 50,150 how do i get a simple (y=mx+c) line out of it in excel ??? Like this-> http://img21.imageshack.us/img21/1134/graphvn.png the graph tools are very confusing

Hi, I've written a routine for a customer to import sales orders into their Sage system. Everything was going well but the client has come back with a particular excel sheet that is not importing. He is getting a message to tell him the sheet is not in a valid …

I have been googling this and have read close variations of the following issue from others. It seems that if you are running MS office 2010 Excel and go to delete a group of rows, sometimes below where you are working a blank row will appear at maxamim height size …

Hi Guys!! I am creating an addin in Excel using VB.Net. I want to access the current worksheet using a ribbon designer. I have tried all sorts but to no avail. Also all the resources that I have checked are providing solutions by adding or opening new workbook. What I …

I am looking for a way to use MS 2003 Excel with dropdown menus to display a list of information. I have one year of data collected and am looking to have it setup to display a sected month's collected data by day. If possible could this compile a table …

I am trying to do the following in excel 2010: For instance: If I have a directory file name "Brazilian Navy Ku" and then I have another directory file folder name " Brazilian Aeronautical VSAT Spares"; then it will go through the first directory file folder name, search for excel …

Hi to everyone. I have created jsp report in that date column is there where am showing the date format like this (02-01-2012) <% String Rcheckdate=""; SimpleDateFormat df = new SimpleDateFormat("dd-MM-yyyy"); Rcheckdate=df.format(rs.getDate("tr_dt")); %> <td align='center'><%=Rcheckdate%></td> In report i have given the excel button from there am exporting the data to …

Hi I hope someone can shed some light on the problem I am having at the momment with an Excel 2010 Sheet, the workbook has 13 sheets with formulas and I rotate the 2 values using vba there are other things going on like a link to SQL server that …

hi there, i have an application that opens an excel file and get the values to the mdf file in visual studio database file. the code for opening the file is below [CODE] Microsoft.Office.Interop.Excel.ApplicationClass tt = new Microsoft.Office.Interop.Excel.ApplicationClass(); String path = a; tt.Workbooks.Open(path, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, …

Hi, I want to change the numeric value in a cell to a string with 1000 Separator(,), e.g. numeric 1000 will to string "1,000" and 123456789 will change to string "123,456,789". How to do that in VBA? Thanks

Hi, I want to develop a C# console application that will read one excel file and make copy of that file first. Then in the copied file i need to add one column at 2nd last position in excel and remove the 2nd column from the copied excel. The added …

I want to automatically increase 15 minute interval to the cells once I enter in one cell in the Microsoft Excel (.xls)file. For Example: In cell D11 I enter manually 3:00(i.e format h:mm), then automatically data should come to other cells i.e(E11, F11, G11, H11, I11, J11, K11, L11, M11, …

How to merge excel cells by comparing the text with next cell data.

hey does anyone here knows how to change excel page orientation to portrait? i get landscape as default <?php header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=transactions.xls"); header("Pragma: no-cache"); header("Expires: 0"); ?>

Hi, Actually I am not familiar with Exchange server environment so i have a qn. Can we convert ost file into pst using outlook inbuilt import/export option while disconnecting to Exchange Server. I mean If I am not connected to Exchange so i will be not able to read ost …