[office-suite] Forum Topics

Good day I am experiencing issues with Microsoft Excel 2013 32- bit running on Windows 7 Ultimate 64-bit. Whenever I start Excel or switch to it from another program the following error message pops up: "An unexpected error occured: Object reference not set to an instance of an object" To …

Hi, I have a spreadsheet with data that I need to sort into a more 'usable' format, I want to repeat (/apply) this macro for all the data but am not sure on how to make it loop every 2 cells. Sub Macro1() ' ' Macro1 Macro ' ' Range("C2").Select …

Is there some way to get more that two (2) search folders into the Favorites part of the navigation pane in Outlook 2010? I really need more than two and have been unable to find a solution to this problem. Thanks in advance...

Group, I'm trying to import an EXCEL table into an SQL Server Table. Although new to SQL, I've done it several times. However for the first time I'm having to import a column that is a date. I'm not sure how the EXCEL column should be formatted so that it …

Hi, I recieved an VB.NET solution to study and then maintain, but I can't compile it, it's giving a lot of errors about Office integration like **'MsoTriState' is ambiguous in the namespace 'Microsoft.Office.Core'** So I checked the object browser and indeed there's the same object in two diffente namespaces: [Microsoft.Office.Core] …

I have created an Macro-enabled Excel file using Excel 2013, and I wanna integrate it with Visual Studio 2015. I've created forms in VS 2015, and in that form, I have created several numeric textboxes. So my question is, how can I export all those values in the textboxes, to …

Total VBA novice, trying to do some simple file modifications in excel via access. I need help navigating to the bottom row in excel to do some copy/pasting. Getting an "application defined or object defined error", marked by the "#" below. Please help! Sub MRFDATAIMPORT() Set xlApp = CreateObject("Excel.Application") With …

hi i am currently developing a reminder in outlook to issue or notify the user on license reminder (due date). I am using vba editor in developer using macros. does anyone can share me anything that u all know regarding this matter? i am confused on the reminder notification.. and …

Hi I have an excel macro question in VBA. I have this code. I want it to go down each cell in row C and run the same if statement instead of just depending on cell C2. I want it to continue to C3, C4, C5, all the way till …

Hello everyone, I have a txt file with data which I want to import to an excel file, by button click. The first couple of lines of the txt file contains general information which I don't want to export. The program should only read the lines which contains a word …

I have a PDF file full of addresses (>3000) in this format: Name Street Address City State Zip Phone Number Is there any program that will allow me to convert it into a Excel file or CSV? Thanks!

Hello! I've been debugging this VBA program that computes the root of an equation using Newton Raphson method and with the use of the UserForm. The user will type the equation, the initial guess and the number of iterations. I was able to search on automatically differentiating the equation unlike …

Hi all. I'm really sorry if it is not the right forum branch for this question but. I`ve got some problem: "PowerPoint cannot read **.pptx" why could this be? It used to work yesterday, and now this. Just saved my presentation. It's been a hell lot of work to make …

We recently enabled folder redirection for a few staff members. After their PST file is migrated to the network share, Outlook can't read it. When we run the Outlook Inbox Repair Tool. We get this error: This data file appears to have been created using a newer version of Microsoft …

We have someone with Outlook 2010 from an old system that is no longer is use. Outlook 2010 still works because it's using an OST file to see the emails. How do I convert the Outlook 2010 OST file in to a PST file and use on our New O365 …

Hi, I'd been working on a MS Word document for 2 hours when Word crashed. When I restarted Word, all of my changes were GONE. Can anyone tell me how to recover my temporary document? I tried to look at my Windows/Temp folder but I'm on my work computer.

Hi i got a sheet in a work book that i am working on now with form control (dropdown). The code i made changes the color for the text in the entire row, or highlights it, works fine. But i would like to add code to change the cell value …

How to php export to excel

Hi All, I would like to create Formula for Answered Calls & Abandon Calls, so that when i enter the call details such as answered timing and abandon timing which should show numbers is answered & abandon with time slot. Total number of calls answered and total number of abandon …

Hi all, my boss want me to send an calendar invitation event to Microsoft Outlook i have tried many time already and it still give me the result "This is no a valid internet calendar file" and here my code: [CODE] $vcal = "BEGIN:VCALENDAR"; $vcal .= "VERSION:2.0"; $vcal .= "PRODID:-//CompanyName//ProductName//EN"; …

i do an export to excel in asp.net and one of the columns does hold quite a bit of data (4k) [directly below]. as you can see below it's tabbed and has multiple newlines. using string builder does keep the data together in one cell, however the formatting is gone …

Hey Everybody. I have been asked to create a spreadsheet that will create a list of matches, for example in Table 1. (Please see the tables attached). OK, fair enough, basic table so far. What I want to do is have three columns, that will return the results that match …

i have listview named : listview1 and a button to export listview data presented. all i want is to export that data to an excel probably to edit or print them. Is there anyone can help me about it? i had gone into but still cant find exactly what I …

Hi, I could import some numbers from notepad to excel 2010, and after right click the cells were converted to General from scientific format. However, when I drag the notepad file to Excel 2013 they cannot be converted to General format. I tried different ways to convert them from text …

I am trying to create a PDF file that has typeable text boxes, so I guess I'm trying to create a PDF form. I'm using MS Word 2010 to create the document then I select Save As and select PDF. After doing this the text box does not show up …

Hello, I hope this is the right forum to ask this question. My requirement is as mentioned below: -> I need to create an appointment on my Default calendar and the same on other calendars that are shared with me by using Exchange Services (EWS). -> By shared, i mean …

Get difference of two text files in excel and highlighting the difference using python. eg. file1.txt alok|test1|test2|test3|test4 alok1|test2|aewer|262771|262772 Rest|t1|rang|banh|test Must|t1|rang|banh|test file2.txt alok|test11|test2|test3|test4 alok1|test2|aewer|262771|262772 Rest||rang|banh|test In excel the difference should be shouwn as below: file1.txt|alok||`test2`|test3|test4 file2.txt|alok|`test11`|test2|test3|test4 file1.txt|Rest|`t1`|rang|banh|test file2.txt|Rest||rang|banh|test `file1.txt`|`Must`|`t1`|`rang`|`banh`|`test` Basically if a record is present but with some field with different …

I would like to know if MS office 2003 can be installed and run correctly on a 64bit PC running win7 . I couldn't find an answer in my search. Google search results were mixed. Thanks

Hello I've found a working script for what I want to do: https://www.daniweb.com/programming/software-development/threads/384778/copy-files-from-a-list-in-excel Imports Excel = Microsoft.Office.Interop.Excel Public Class Form1 Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load 'get the last saved settings btnCopy.Enabled = False txtExcel.Text = My.Settings.ExcelFile txtSrce.Text = My.Settings.SourceFolder txtDest.Text = My.Settings.DestinationFolder SetCopyButtonText() …

Hi everyone, I'm new here. I don't know VBA and have been tasked with a VBA project for whatever reason. We have a recurring bug wherein a report we receive has semi-fake rows, causing all kinds of hell. The current logic I am attempting to execute should run as follows: …

My PowerPoint has gotten buggy, the slide templates are invisible. Also, word runs slowly and seems to crash and not close files properly. I have my installation CD. When I put it in the CD drive, it brings up a window with dozens of file icons and no explanation of …

I have an Excel sheet that I am looking to combine two columns from one sheet into a new sheet. I am including the Excel file. The columns are the B and R from the Title_Frame_Register sheet. I am trying to output to a new sheet and it what I …

Hey guys. So I'm currently building an app and I'm having a bit of trouble. So I have an Excel file and it reads it and opens it fine(I imported microsoft.office.interops.excel but what I want to know is how to loop through column A and pick out the rows that …

Hello.. i want to read a microsoft word file and i did search for this subject but i did not find a response. can any one help me, and thank you.

Hello C++ Programmers; I would like to know if fill color can be automatic fill up a whole row when in two column have a number 6; for example: A B C D E F G H I J 1 98 132 3 146 6 54 8 210 8 2817 …

i am using msoffice,but the ms words is not open they tell permissionto acces how can i rectify

Hello all, I tried to open my MS Outlook 2010 and couldnt open it. I started scanpst and it showed me: "The Microsoft Outlook Inbox Repair Tool does not recognize the file <filename>. No Information can be recovered." Does anybody have a fix or have any suggestions?

Hi everyone; I got no idea how to start this and if it is possible; I have a text file (.txt) that have lot of lines and I want it to transfer it in Excel (.xlsx / CSV) But not all will be transfer in excel, only a specific number …

Hi, I'm a web developer for a small company, I had programmed using ASP about six years ago, thus my skills are very rusty at the moment...recently, my boss had asked me to export the database information from the ASP pages to an Microsoft Excel file, allowing the users to …

I have a corrupt OUTLOOK PST file that is rather large and needs fixing. I ran "scanpst.exe" and it fails. I have looked for a tool to fix, and every tool fix's the file then wants either money or a key (money) to fix the file. Does anyone know of …

How to unprotect excel sheet without knowing the password.

I have three separate presentations with the same problem and I have read the other thread regarding this and have tried to load the presentation up through Open Office and this has failed. Does anyone else have any ideas as these are extremely important to me!!! F.Y.I - When I …

I have lot of values in mysql database. I want to display all that data in excel file. How to do? without plugin is it possible? or how to do? Without any plugin, is comfortable. I am new to this concept.

Hello VB.net Programmer; Good day Daniweb'ers; I have a problem to my Excel Data going to DGV; Only Selected items in excel will be put in the DGV; I don't have a database for this problem; So here it is; This example from excel file: 1 2 3 4 5 …

Hi - I have a corrupted Excel file which I can't repair. Cannot attach the file writes that "The file type you are attempting to upload is not allowed." When I open the file writes that "cannot open the file because the file format or the file extension is invalid. …

Hi guys, To make Some things easier, I want to make a program that can do the following: 1. Import a .txt file to a specific .xls file. The .txt file contains several lines of data which is build like this: (aaaa,bbbb,cccc,etc.) sererated by comma. Imported in excel, I would …

I have got 3 MS-Word 2007 document files (DOCX) which MS Word is now unable to open because they are corrupted. MS Word's recovery could work. Tried Stella Phoenix, Recovery Tool Box and a few more: they do the job but are for sale. Is there any free one which …