4,334 Topics
 | |
| | 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 … |
 | Several people have asked how to export data to Excel. This code snippet shows how to export the data from a listview in details mode to a new Excel spreadsheet. Take note of the comments in the header to avoid having orphaned Excel.exe tasks eat up your system memory. |
 | Dim Values As Range Dim CurrentSheet As Worksheet Set CurrentSheet = ActiveWorkbook.ActiveSheet Set Values = Rows(5) For j = 0 To 20 For i = 1 To Values.Cells.Count - 1 Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _ Formula1:="=Delimit2!$A$" & i, Formula2:="=Delimit2!$B$" & i Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority With Selection.FormatConditions(1).Font Color = -16383844 TintAndShade = 0 End … |
 | Hello everyone, I will take this chance to reintroduce myself to the community. I was a member on the Daniweb forums back in 2006 and 2007. I can see a lot has changed on the site since then, and its great to see that the community is still alive. In … |
 | Hello Daniweb-Community, I got a node in my xml-File for a java-link. it looks like "C:\Program Files (x86)\Tool7\javaw.exe -splash:splash.png -cp ./cl/cl.jar; -Dawt.useSystemAAFontSettings=on" If i start the tool by double click on the node, it doesn´t start it, because it doesn´t load the arguments. Next i createt a new attribut (called …  |
| | Hi Everyone I am trying to achieve a cell that is dependent on two different cells. Basically what I want to do is: *Item 1* If the contents of Cell U20 equals the contents of W12 or W13 the cell will equal a certain value. *Item 2*Depending on the date …  |
| | Is anyone familiar with Microsoft Remote Desktop? I'm referring to the application with the name MSTSC.EXE. I used this years ago at the office to remote into the servers from home but MS has made changes since then. I have one laptop downstairs that is usually unattended and I have …  |
 | Someone left a comment on one of my posts similar to, "Linux won't be popular on the Desktop until it runs [URL="http://www.microsoft.com"]Windows[/URL] applications." To which I silently responded, "Huh? and, "You've got to be kidding me." We have [URL="http://www.winehq.org"]WINE[/URL] for running Windows applications and it works reasonably well for those …  |
| | I am new to Office 365 API. We have a requirement of developing a Web API, that will access office 365 APIs for accessing calendar information, send emails etc. I have an Azure account with Administrative access. I also have a Office 365 tenant with a system account. I have … |
 | I just did the latest updates to Microsoft Office 2016. But after updates I cannot open one very important .RTF document. I click the file to open, the following message came: 'Check the file permissions for the document or drive.' So i uninstalled it and reinstalled Office and same thing. … |
 | I have about 15,000 emails in google that were sent from a wordpress webform. I need to be able to extract data from that email and export to excel. Are there any suggestions? I have started using Parseur. But I need to be able to foward all 15,000 emails but …  |
| | This is puzzling. We have a small organization running our own Exchange 2003 server for about 25 users. We hired a new employee recently, and I created a new user in Active Directory by copying an existing account, same as I have done for over 10 years. That all went … |
| | The following works to calculated the date for Easter any given year. I don't understand why it works ... =FLOOR.XCL("5/"&DAY(MINUTE(YEAR("1/1/2017")/38)/2+56)&"/"&YEAR("1/1/2017"),7)-34 I'm a novice - in the above, "1/1/2017" is used to provide a year. That could be done a number of ways, and is not the same way I have … |
 | How to restore the corrupted *.xlsx file? At me installed Office 2007. I created the file in Excel. And then saved its as usually. Everything was normal, but now the file don't want to open. error: not found.  |
 | I have 2 sheets in same Excel. First excel sheet contains the following fields No Material 10th july 11th july 1 DATUM DCP ESD Black 2 DATUM DCP ESD Blue My second worksheet contains the following fields No Date Material Stock size+Wastage 1 10th july DATUM DCP ESD Black 283.47 … |
| | I am currently developing in Visual Studio 2008 (Visual Basic) and I have no problem reading, editing, saving, etc. to a 2007 Access database that is stored locally using the following code: [CODE]Dim NotifyDS As New DataSet() Dim NotifyCon As New OleDb.OleDbConnection NotifyCon.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Data\Settings.accdb" NotifyCon.Open()[/CODE] Ultimately I am … |
| | **Video players** 1. [VLC Media Player](http://www.videolan.org/vlc/download-macosx.html) - VLC is a cross-platform and open source multimedia player for Mac OSX. 2. [Perian](http://www.perian.org/) - Perian is another open source video player for that are based on multi-platform form of FFmpeg project. 3.[ Mac Media player](http://www.macblurayplayer.com/mac-media-player.htm) - Mac media player provided all the …  |
 | I am developing an application for people to learn but i realised the need to time the quizzes in the programme. Could someone please help me with a sample multiple question codes with timer? So far this is what i got: Public Class Form1 Dim questions(2, 4) As String Dim …  |
 | To all database genius out there, I hope you can help me with this error I encountered when importing excel file to SQL Server 2005. This is the error: [CODE]Executing (Error) Messages Error 0xc020901c: Data Flow Task 1: There was an error with output column "Description" (21) on output "Excel … |
 | According to Microsoft, 75% of organizations with more than 500 employees, have extended AD into either Azure AD and/or Office365. Have you / or are you planning to extend Active Directory into either Azure AD or Office 365 or for any other purposes? |
| | hi everyone, Im doing a project of creating a office application.I want to to add all the options that in my project that are available in the microsoft word.I have a doubt in adding table in the work area.Can any one tel the solution to my problem.  |
 | Hi, I really need help and this is my first time of trying to link 20 sheets into a survey chart (Chart 1). How to do that? The chart in "Chart 1" is only based on sheet 1. Excel file: https://1drv.ms/x/s!AqKGcmac7PpVz2StIkZ445NRYVat |
 | I got a new laptop and I didn't have enough money to buy Microsoft Office so I got Kingsoft Office instead. I'm trying to copy and paste a questionnaire that I completed online for a quiz for class. The questionnaire has the question and a box where you select true …  |
| | I am using visual studio 2008 (vb.net). I have a long list of file names in column A on an excel sheet. These files are located in a directory on my network drive. I have to copy these files over to another folder. I know how to copy files in …  |
| | Hi, I am trying to open a large excel file (.xlsx) to ad some rows of data from another excel file. However, due to the size of the destination file i am getting the memory error. I tried the below, however when i create the worksheet object it is creating … |
| | I have checked everywhere in Daniweb to see if this has been asked before but could not find the question. Forgive me if this is too simple an issue and it is my hope that my question is clear. I have an excel worksheet (see attached) with 4 columns. Column … |
 | Hi, I need to write a macro that has one row of dates. Row D. I need the macro to go down row and depending on the date I need to input a number to the cell to the right of that date. Example. If date < 12/22/16 insert value … |
 | Hello. Please help me to stop an Excel error message. Every time I try to open the file, I get this error: "The file is unknown". Has anyone any experience in this and if so could you help point me in the right direction? How to repair Excel file? Any … |
| | I prepare a table in Excel within a Using () statetement. At the end I UsedRange.Copy() to what I understand is the clipboard. Then I Selection.PasteExcelTable in a Word document. I get an COM Exception "command failed". When I activate the word document and press Ctrl+V the table gets copied. … |
 | Hey guys, I have a code on excel, that will count the critera if there is more than one box filled out. =COUNTIF(C5:D14,"<>0") But now i am converting this code to jquery and i cannot figure it out. on my page, there is a toggle button, yes/no selector for autopay, …  |
 | Hello Group! I've developed an app that takes the data in a text file and moves it to specific columns in an Excel file. My computer has the Excel 2010 installed. So the application works fine with no issues. However we've begun to upgrade computers and software in the office … |
| | Hi group, I'm discovering that my Excel spreadsheets that are being created by a VB.net app I've written isn't completely closing them as they should be. I'm struggling to understand why and how to fix this. Here is the code for the portion of the app that creates the workbook, … |
| | hi, I have an excel sheet and the is a row filled with data the row starts from B5 everytime, what i want to do it to read the values of the cell until the row comes to an empty cell how do i do it, thanks appreciate a reply, …  |
 | Hi All, Can some one please assist me. How to get rid of this error. concurrency violation the update command I have been struggling from the last couple of days. Tried many solutions from the internet but unable to resolve this issue. May be, I am completely rookie. Imports Microsoft.Office … |
| | have been looking at MSDN for onenote, but most of it , is over my head :-( i did find this https://msdn.microsoft.com/en-us/library/office/hh377180(v=office.14).aspx have been trying to get it to work, but on luck so far.... do not have MS Office installed. the idea is to get the data(mostly text) from … |
 | Hi Dear could you please help for below issue Description: Previously our client is using ms office 2007 now client want to upgrade office to ms office 2013 we have VB5 application with access database (previouly it was .mdb and now it is converted to .accdb) so for that purpose … |
 | I have the following: string oledbcmd = ""; string constr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Excel.xls;@Extended Properties='Excel 8.0;HDR=Yes;"; oledbcmd = "Select top (1) * From [CLIENTES$] ORDER BY id desc"; OleDbCommand oconn = new OleDbCommand(oledbcmd, con); OleDbDataAdapter sda = new OleDbDataAdapter(oconn); DataTable data = new DataTable(); sda.Fill(data); It fails. What is wrong with … |
| | 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 … |
| | Hey Guys, So using a webform textarea I am passing some data into PHP. This data is basically 4 columns of an excel sheet and potentially unlimited rows. Now I want to be able to go through this data, select each of the four individual elements from each row, insert … |
| | Hello, guys i am having a problem with the Printing some tickets i need to print each ticket in a different page beacause the printer i'm using can only print the size you customize it to print and my program can have different variations knwint that i import an Excel … |
| | Good time of day all. Today I saw this error "The database has been placed in an unexpected state; Microsoft Access can't open it." I was working with it I mean with this particular file not long ago, then my PC was shut down due to power surge. And now …  |
| | 1. Crystal Reports SAP Crystal Reports is known as a robust production reporting tool. With SAP Crystal Reports, you can create powerful, richly formatted, dynamic reports from virtually any data source, delivered in dozens of formats, in up to 24 languages. SAP Crystal Reports turns almost any data source into … |
| | 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 … |
| | Good day guys I need help for adding rows in datagrid where the rows to be added are equal to the number of rows copied from excel. I can copy the data but it displays only the first row from excel on the last row of datagrid but if I … |
| | 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 … |
| | 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! |
The End.