[office-suite] Forum Topics

Hello DaniWeb community. I haven't been on the site in quite some time - it's so intense now that I almost feel a bit silly for asking a simple question but here goes. I have a personal account set up with Microsoft 365 and all is well for the most …

My shortcut bar has broken and I can't fix it. I'm using Win XP Home, and MS office 2000. The shortcut bar has been fine ever since I got this machine but now it's gone wrong. There are a lot of shortcuts on my desktop, each of which has an …

Hey! Someone can help me advice good recover app for it?

Hello all How do I recover excel password protected spreadsheet Thanks

Hi All, Good day. I am trying to develop a roster for my team in Microsoft Power Apps. We are 6 teammates which do the duty in following format. SUMMERS: 6A, 6B, 11A, 11B, 12A, 12B WINTERS: 7A, 7B, 11A, 11B, 1A, 1B. Please note that in every shift there …

The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)) My Code is Private Function GetXlUsedRange(ByVal filePath As String) As Object(,) Dim xlApp As Excel.Application Dim xlWorkbooks As Excel.Workbooks Dim xlWorkbook As Excel.Workbook Dim xlSheets As Excel.Sheets Dim xlWorkSheet As Excel.Worksheet Dim xlRange As Excel.Range xlApp = New Excel.Application xlWorkbooks …

Hello, Below is an example of what is happening to SOME, not all of my letters. I have letters that are all drawing from the same spreadsheet yet sometimes there will be a new line started and sometimes not. There doesn't seem to be a pattern. Has anyone else experienced …

Hello, i have an excel-file whith 2 sheets. There are much columns, but I need only a few of them. I want to delete some columns by name. I found this code but, I don´t know why it doesn´t work!?!? It tells me ".UsedRange" is wrong. Can you help me, …

Even after formatting cells as numbers their sum adds up to zero. How to correct this anomaly?

I’m trying to find a way, either with Excel or another program, to find out what combination of numbers will equal a predetermined sum. I’ve tried Excel Help and the internet, and it appears possible, but all the examples are far more complicated than what I’m trying to do and …

Excel time difference error I am using a time difference =A1-B1 =A2-B2 =A3-B3 and it's value =23:50-23:40 =00:50-00:40 =02:40-02:30 But in the middle returns 0:00 And first and third return correct answer please suggest to correct the result

I have an application that opens up Excel, reads some information, then closes Excel. I developed this application using Microsoft Office XP 2007. A few weeks ago, my company upgraded to Microsoft Office 2010. The applications still works fine, but I can not compile in VS 2008 anymore. I get …

I am trying to rewrite Excel 4.0 macro in VB.NET by calling the DLL from VBA code in excel. Looking for an example that can detect the range of cells selected by the user in order to perform some operation. The macro when executed present a dialog to let the …

How would I know if an e-mail originates from Office 365? I know I can look at the oldest `Received` header of a message to see where it originates from, but how would I use that header value to know it was sent from an Office 365 account? It looks …

I am trying to automate my monthly tax reports that tax me depending where in the state I am located. The state provides a "database" but it is just a map that I click on where the job was, so I can be taxed at that rate. It seems simple …

I wish to read from a closed excel file, a few years ago I found a website using ADO and it worked but now I cannot find this website I have tried over 100 with no success please help Ernest

I am trying to convert an 11 page Pdf document to excel and have the formatting work correctly. If anyone knows of an easy way to do this I would appreciate it. Thank you,

Thank you all for being here to help me with this problem I'm having. I've used computers for years but this is over my head. I saw a post here when you guys helped a lady a few years back having a similiar problem with her software. I hope you …

Hello Microsoft community, Actually I am the developer and has created my site. I want to integrate it with Microsoft Office migration. There are four types Microsost Office 365 Migration and also let me if I can integrate all of them. And also let me know the process and the …

Ok. This might be a little long winded but i will try to give as much information as possilbe. I started with Office 2003 and then tried the 2007 Student trial version. When it expired I could not get it to uninstall so I dealt with the annoying problem until …

Please save the above xml contents of my Excel Office add-in manifest as manifest.xml. If you insert the add-in using the manifest file the add-in gets installed from the add-in files from my github repository. I want to embed this manifest.xml into Open office xml. So, when I send my …

Ok this is a weird one and its been ongoing for many months, wondering if anyone has any ideas. We have 10-15 office 365 exchange email accounts and they all work perfectly fine apart from one account on one device. This particular account has intermittent issues with sending and emails …

hi everybody, I was trying to read a certain range from column in excel into an array in c# then to write it back in another column(as a matter of a simple trial), where the column is written into textbox3, the start of the range is written in texbox1 & …

public bool Kayit_Ekle() { sorgu = string.Format("Insert Into [{0}] ([SERVİS FORM NO],[ÇAĞRI NO]) Values ({1},{2})", sheet, formno,cagrino); cmd = new OleDbCommand(sorgu, Baglan()); cmd.Parameters.AddWithValue("@{2}",cagrino); int etkilenen = cmd.ExecuteNonQuery(); if (etkilenen == 0) { return false; } else { return true; } } Hello there, I am writing recording program with c …

I have been having nothing but trouble trying to get C# to read excel. I haven't even gotten to the writing part, but I imagine it's going to be a challenge, too. FYI, I'm pretty new at this, and don't have a ton of experience, so I'm sure I'm missing …

I make the windows form on which on a single button click performs like this ' private void button1_Click(object sender, EventArgs e) { Excel.Application exapp=null; Excel.Workbook exbook=null; Excel.Worksheet exsheet = null; object misvalue = System.Reflection.Missing.Value; exapp = new Excel.Application(); exapp.SheetsInNewWorkbook = 1; exbook = exapp.Workbooks.Add(misvalue); exsheet = (Excel.Worksheet)exbook.Worksheets.get_Item(1); exsheet.Cells[1, 1] …

Ok. This might be a little long winded but i will try to give as much information as possilbe. I started with Office 2003 and then tried the 2007 Student trial version. When it expired I could not get it to uninstall so I dealt with the annoying problem until …

Hi, can someone help me solve this please I have tried so hard but can't figure it out? In past years, approximately 20% of all U.S. families purchased potato chips at least once a month. You are interested in determining the fraction of all U.S. families that currently purchase potato …

Hi all, Before I begin this question, and before you tell me we dont do homework, I would like to state that I have read a few articles, I have tried a couple of functions (=REPLACE, =SUBSTITUTE) but i'm not able to get the reuslts require, I'm new to Excel …

Hi helpful people. Its been a while since Ive been here, ever since I employed someone who knew about IT to look after it for me. I'm back on my own again, and looking for a bit of guidance please? I run a small sales company and receive daily sales …

I have list of unique names of players in column A in sheet 1. And in sheet 2 I have data of cricket score of different matches for that particular player with same unique names. And in sheet 3 I have data of same players for football matches. Now I …

Hello everyone, I want to put my *string[]* (array uni dimensional) of values in to excel row and every time the first number of this array was different of "500", the program will add another row with the values on the excel sheet. I only have on the program to …

hai, my project title is student's feedback generation vb.net is front end and excel as back end. i have one text box and combobox. to get row value from excel sheet and display into combobox when the text box value matches the cell value

hey! :) all the WindowsXP users here is a hidden mystry of XP of any version Now u can create your own charaters by following the below simple steps...... ;) [LIST=1] [*]open run dialog box from start from taskbar [*]type the string as :- " eudcedit " [*]follow the rules …

Hi Team, I have an excel which has multiple rows and each row can have multiple images associated with that , which are postioned on a specific cells of that particular row.I know while we are positioning a image on top of a cell, that is not associated with the …

Hi all, Now I have no programing experience, I know very little about this, so please bear in mind. I am trying to turn a particular excel spreadsheet I have made (the user inputs information and it creates a final answer(result)) and I want to be able to turn this …

I try to mark content from a web-page (with pictures, hyperlinks etc) to clipboard and then paste it into Microsoft Word (belonging to the Office 365 Home suite). Then I discover problems starting with the following warning: "A potential vulnerability has been identified in Microsoft Office. This document contains fields …

To start I want to make it clear I have no experiance with office 365 or the associated exhange stuff, and I would never personally recomend such a package to my clients, hence why I am totally in the dark about this. I have taken on the management of IT …

How to remove edit protection from Excel 2016? Can't edit anything in a given worksheet.

I've been looking tutorials and examples of setting the value field of a input tag. I'm trying to enter two IP addresses into the text fields on [this](https://www.ipaddressguide.com/cidr) website, under IP Range To CIDR. But my code won't enter anything. There's no ID tag, so I can't use the getElementById …

To start I want to make it clear I have no experiance with office 365 or the associated exhange stuff, and I would never personally recomend such a package to my clients, hence why I am totally in the dark about this. I have taken on the management of IT …

Ok I have a a list of about 392 items that needs to be put into an excel form. I manage to get Column A (which is the inserted worksheet names) to name the worksheets that is automatically inserted. I have attached an example of my table When the code …

I am using Cell 2 and cell 3 of Column A Column B and Column C Column B is the Profit % and Column C is the Selling Price cell 2 of column A is my **search box** where I want to enter Selling Price. Presently, with the help of …

Im not sure what code to use as I am not that experienced with VBA. No matter what i try i cannot get this macros to stop once it reaches a blank cell in E column. Here is the code: Option Explicit Sub PDFTemplate() Dim PDFFldr As FileDialog Set PDFFldr …

How i do remove duplicate questions from my excel file??? There are more then 150 questions in my excel file

Hello All, I have an issue with Windows 7: sometime the copy paste doesn't work and when this issue appear => the only way to remove it is by rebooting my pc. The copy paste doesn't work (wether using using [Ctrl]+[C], [Ctrl]+[V] or by context menu (right-click menu)) for all …

Hi everyone i am getting an error that says Microsoft Office Excel error '800a03ec' Unable to get the Open property of the Workbooks class when i try to open an excel work book in my code . The line of code where i get the error is [icode] Set ExcelBook …

Dear Friends, I am facing a problem, I have two forms, Form1 Has one DataGrideview and Button redirect to Form2, which has Button(Browse Excel File) and combobox(Sheet No of excel file) and Button to load Excel file list in Datagrideview , **want to show excel file list in Datagrideview of …

The following (see the full code below) successfully adds a page in a section in Onenote. What I don't seem to be able to do is to get the lastly created page on top of the section. Here's the code that is puzzling me. onenoteApp.GetHierarchy(sectionId, OneNote.HierarchyScope.hsPages, out string xmlPages); var …