[office-suite] Forum Topics

I need to open this pptx-file. Can anyone help me with that? Made in Microsoft PowerPoint 2010 and cannot been seen or open with any applications... If it can't be open, how can I fix the file.

After running a custom Windows Update a few days ago, I am now receiving an error message when opening various PowerPoint files: "PowerPoint" was unable to display some of the text, images, or objects on slides in the file, "filename," because they have become corrupted. Affected slides have been replaced …

Hi, I'm trying to learn VBA for a personal project I am working on for excel. Right now I have in cell A2 - "2 years 1 month" and in cell B2 "1 year 2 months." I am trying to get it so it prints in C2, "3 years 3 …

What tools have people had the most success with for repairing corrupt Excel files? I have had 2 people come to me recently with corrupt Excel files (oolone was XLS and the other XLSX). I tried opening the files with versions of Excel and repair but nothing. I then tried …

Cell C4 has the expression =565+660+709+1093 Is there a function/nest of functions that can output the number of values being added? BIG NOTE: I AM NOT ASKING FOR THE SUM OF THE EXPRESSION!

How do I repair a PPT file that has the error message:The file may be corrupt, in use, or of a type not recognized by PowerPoint.?

Dear brother Sorry for my bad english Please help me in this case I import with big data to Datagridview It's take long time, and i want to using progessbar for wait I try to do this But it's seem not good Please help me Thank you so much! `Inline …

Hello VB.net Programmers, Please help about delimited. I've been looking to the forum and other sites about this but can't find any. Here is my problem. 1. I need to put the text file to excel but this text file don't have comma and tab. This are separated only with …

Hello VB Masters, Firstly, apologize if my question is in the wrong place :) I would like to create a loop that will copy a data from rows in the first sheet to the columns in the second sheet. The data in the Sheet1 looks as follows: A B C …

Hi group, I'm attempting to create and write to an Excel spreadsheet with data from a text file. The code is meant to parse each line of the text and place the data into individual variables. I then need to place these variables into the appropriate cells on this newly …

Hi I have data set where I find it easy to sort data by using pivot tables. BUT one essential cell is not a part of each sample ID. I have tried to make a macro to insert this data without luck. So in b column every time an empty …

Hello everyone! I have a problem with Outlook 2007, I create successfully a new account but it doesn't send or receive any mail... Who can help me please? Thank you in advance!

Am having a little problem with importing data from MS SQL to and Excel sheet. I followed previous answers on daniweb, but they couldn't help me out. Here my code. Private Sub btnExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExcel.Click Dim appXL As New Microsoft.Office.Interop.Excel.Application Dim shXL As …

Hello Group, I'm attempting to create and write to an Excel file. I'm sure I've hit the first of many snags. Hopefully you can point me in the right direction. In this first attempt, I'm getting an error code: "Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))". The error is attached …

Dear forum members, i a m trying to export the contents of datagrid to excel but i am facing errors.After searching i have seen that the problems occurs because one of my columns is of type TIME and taht is why i am getting the error : Object reference not …

Good day! I just want a little help on how to loop from one cell to the end and set a sum Formula. I have Columns From **F to O **and created a Sum formula for column F. Is there a way to make it in a loop and pass …

We had a need to factory restore our PC. It is Windows 7 Home Preimum with SP1. We copied all data off ran the factory restore drive, reinstalled Office 2007, restored all data files and now when we open Excel files we cannot format them proerly. The page breaks will …

Hello all, I am using Office.Interop.Excel.Application in which i have to save a file using saveas() but before saving it i have to disable the Excel's OverWrite prompt . I did tries Application.DisplayAlerts = false; But it's not working , How to do this??? Pl Help ?

I am having an issue with a formula in excel and am not understanding what it is doing =COUNTIF(J28:L31,"w")+COUNTIF(J28:L31,"l") is supposed to give me a result of the number of cells with the value of either w or l in that range But instead of displaying a number, it is …

We are building a mission critical application in OneNote 2013 and I want to develop a backup methodology that lets me restore from a few days back in case we discover a corruption. I changed the option 'Number of backup copies to keep' to 10, then have it set to …

Hello, I have been reading some posts about you to repair a file and it says to use the text converter. I dont see how to use it though. The attached file is corrupt and I think it is because my HD crashed a few days ago. I want to …

I'm currently have and excel speadsheet that has 3 rows. What I would like to do is create a macro that reads the last populated row, usually will be column A1, and then created a new column listing the current date and time. So for example, I have ColA ColB …

How to export the column data from excel to listbox without using database. plz help

Hi All, I have created Add-In for Outlook 2007, 2010 and 2013 with VS 2010 (VSTO 4) The requirment is to store the Email addresses (FROM and TO addresses) to one table. I can able to get the TO email addresses in Outlook version 2010 and 2013, but unable to …

Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me. foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*")) In advance, thanks …

How to view corrupted mpp file of microsoft project ?exported a large (4,000 tasks) mpp to xml and when I attempt to open it with Project I get the error “An unexpected error occurred… The file may be damaged.” I tried exporting it several times but get the same error …

Since upgrading to Microsoft Office 2007 I now have trouble reading PowerPoint documents from a particular client. Before I upgraded, I had no troubles reading their PowerPoint. Now, I have missing fonts and graphics - so much so that many pages are blank, or filled only with a few dots …

There is a lot of empty space above and below my text (55 pgs. with 115 footnotes). Even though top and bottom margins are set to 1 inch, there are over two inches of space above and below the text. When I go to Layout and adjust the Margins measurement, …

Group, I've created some spreadsheets that others use. The headings of the spreadsheets are divided up with colors. However after I've created these and saved them formatted as I like, some of these cells are changing automatically after the other users open them up. I've read online there may have …

Hi Group, I've recreated a spreadsheet that has multiple macro's behind it. One of these macro's opens and existing file, copies the data in it and then pastes it into the original workbook (where the macro's originate) and then closes the existing file. After the copy and paste is done, …

Hi this is scorpionz I am uploading an excel sheet file using PHP Now the file code is working fine for gif files but not working if i provive xls extension Here is the php main code [code] <?php // include 'config.php' include 'uploadcode.php'; if(isset($_POST['upload_file'])) { $user_file = $_FILES["car_info_file"]["name"]; upload_files($_FILES["car_info_file"]["name"]); …

I have a computer that is running Windows XP with Office 2007 Professional. He is having problems only with the Powerpoint files in the office, specifically .pptx files. When you double-click on the file it opens up to a blank presentation. Once that is open if you click open and …

Dearl all, Is there any way or codes for export dataset or datatabe to excel file. Whenever I use click event in the button, it will save my report in an excel file. My information inside in datatable (dataset) from database and I want to save it in excel file. …

Before upgrading to EXCEL 2010, I am able to open dbf files created in Visual Foxpro 7 or 9 in Excel 2003. I am not sure why after installing EXCEL 2010 I am no longer able to open the file. I get the error message when I tried opening the …

I just installed and added a user. Then I copy the old .pst file to the Outlook folder. When I open my Outlook email, I don't see the calendar. How do I get it back? Thx

Hello all, Help me to understand how they create deal or no deal game in excel? is that converted? or made in excel? that would be very helpfull.

I use windows 8.1 with MS word 2010.Every time I open a word documet it copies itself with the title's first 2 words altered to a dollor sign($) and ~. even same showing for recyclebin also along with $ sign. so if I name a file new microsoft word documents.docx …

i want a macro which can find the "$" select all the data and copy it to the next sheet The dollar symbols are dynamic so 1st and 4th dollar symbol will be copied sheet 1, data between 4th and 5th will be copied to sheet2,data between 2nd and 3rd …

Hi all, I am trying to create a script that I can run and edit a user's settings on their excel. IE: the script will edit the user's options by enabling macros and adding in the add-on. Anyone ever work on something like this?

Hi, I need to validate a text input with the rest of the data inside excel file. The following is my code. It just read the text input and only execute data in row 1 only instead of searching other model's data. Any suggestion where did the code goes wrong? …

Hi all, Want to write some data from C# to Excel. Code enough I thought, here at DANI's and on the web. So I managed to come up with this : [CODE=csharp]private void DoExcel(string Fname) { Microsoft.Office.Interop.Excel.ApplicationClass excel = null; Microsoft.Office.Interop.Excel.Workbook wb = null; Microsoft.Office.Interop.Excel.Worksheet ws = null; Microsoft.Office.Interop.Excel.Range rng …

guys, i have a bit of an anomole exporting to excel. on date formats, it seems no matter what i export to excel, it becomes a 24hr clock. for instance the date format thats being exported is stored as:: 03/11/2015 04:26:09 PM - however when it hits excel, it becomes: …

Hi! Firstly, here's the code: if(new File("ATM.xls").exists()){ System.out.println("File exists"); } else{ File excel = new File("ATM.xls"); } What I'm trying to do is check whether or not a file exists and then create said file, if it does not exist. This all works fine, but somehow, I'm unable to use …

Not sure how to put my code in to excel. 1.#include <iostream> 2.using namespace std; 3. 4.int main() 5.{ 6. const int n = 20; 7. int Array[n] = { 3, 5, 2, 9, 6, 12, 16, 11, 18, 4, 14, 8, 1, 15, 17, 7, 19, 13, 20, 10 …

Good day guys I need help for adding 2 column in datagridview my project is : the import and the varibles are : Imports Excel = Microsoft.Office.Interop.Excel Imports Microsoft.Office.Interop.Excel Imports Microsoft.Office.Interop Imports System.Runtime.InteropServices Public Class Form2 Friend xlApp As New Excel.Application Friend xlWorkBook As Excel.Workbook Friend xlWorkSheet As Excel.Worksheet Friend …

Hi, how to plot a chart from imported excel in Datagridview? I tried the tutorial from [HERE](https://www.daniweb.com/software-development/csharp/code/492766/display-excel-data-in-a-datagridview), but I do not know how to plot the chart. Previously, I used MS.Access for my Datagridview, then I manage to choose the Datasource. But, for this case, I imported an excel and …

Hello !! I use vb.net with excel I have a buttom "get the name of the column from worksheet" with a combobox thi is the code of the button: Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click Dim Excols As New Dictionary(Of Integer, String) Form2.xlWorkSheet = …

Hi. In my application I'm using Excel to get some data into an array from a worksheet. Here is my method. public string[,] WorksheetToArray(string path, bool visible = false) { oExcel oXL = new oExcel(); // here new icon appears. if (oXL.Error > 0) { MessageBox.Show("An Error Occurred" + "\r" …

Hi Dan, i am looking for something where i click on the button and the excel sheet opens. i have created buttons on the VB excel but i am looking for the coding about how should i link the excel sheet with the command button? please can you help? regards, …