2,270 Topics
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 …
For some reason, when I open Microsoft Word the top and bottom margins are non-existent. When I go to File>Page Setup, it says the top and bottom margins are set to 1 inch. I've tried changing them to a variety of different numbers, and they don't change at all. Any …
How to the excel data please help me In the original excel sheet data show column wise. But now I want to same change to data showing structure and re arrange the data structure. I can't upload the excel sheet that for i attached the IMG please help me https://ibb.co/jdzC4m …
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 …
(Mod: if this is not the appropriate area for this post, please move. Thanks.) I am attempting to Find and Replace text in an Excel 2016 spreadsheet. For example, I'm searching for the following URL in the spreadsheet: https://sample.com/user Upon located this URL in the spreadsheet, I want to replace …
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 …
Lady and gentlemen I want to ask you. I have the document in OneNote 2007, but there is a problem, I can't open it cause of - This file does not appear to be a OneNote file. This message has appeared today at opening it. Yesterday the document was valid.
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 …
Writing article in Microsoft Word i forgot to save my materials...How to give back all i’d wrote?
My problem with excel document. I made a lot of actions in excel file and forgot to save file and shut computer down.
hello my teacher put a surprise quiz and due tomorrow as im seeking for desperate help :( she didnt teach anything yet on this topic so i dont know where to start :/ any kickstarter topic is appreciated task: make a program that reads and display 10 data in excel …
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 …
This past summer I was "treated" to an automatic update by my Win 10 OS (updated for free from Win 7). Ever since then my computer has been an unending source of operational frustrations: 1. My Logitech webcam (C260) has become non-operational. 2. My DVD drive stopped reading disks. 3. …
I have an excel template with 30rows starting from A19:J19 TO A49:J49 From a50 to a65 i have clauses etc. How do i get my datagridview with 55 items to export to the template and then open another page 2 for the balance of the items on the datgridview. private …
Hi All kindly i need your help with one Excel Sheet to convert it to a PC program since im haveing every day a issue with bracking the forma all the time and it will be alot easy for me to work with it as a app . Thank You. …
how to export the my php file table in to excel???
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 got a problem with outlook from microsoft. when i tried to send a message the program hangs up for several hours about 5 or 6 and finally the message is sent. it if very frecuent in my machine. does anybody have had this kind of problem? any solution? thankyou …
Hi all, I'm trying to give a user access to a shared calendar (that the rest of her team have access to already) but I can't figure it out. The calendar was originally set up by a staff member that has left so I'm in the dark with it. What …
ScanPST.exe fails repeatedly while error “Microsoft Outlook Won’t Start” still exists. Why it happens in Outlook 2016? Help me!
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?
I was write code for excel vba xml database values write into text file. when i using without any special characters xml values parsed into their text file without any issues but when i using special characters xml cannot parse special characters (&,- etc) error getting on my macro page. …
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 …
Hello Guys, I am working on a Movie Platform and using XML file to upload/Publish Movies on to the platform. So for each Movie title I have to Edit and create an XML which is very time consuming and to be honest stupid. I want your help to suggest me …
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 …
I have a project where I have to send data from an Excel spreadsheet to an Oracle database. Here is the code I am using and I need some help. It stops at the second string statement. I am trying to use an Excel range name to Insert or Update …
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 …
I export datagrid to excel file using this below code. But it doesn't export datagrid header. I'm just change values at for loop. But it doesn't help me. Please help me. Dim xlApp As Excel.Application Dim xlWorkBook As Excel.Workbook Dim xlWorkSheet As Excel.Worksheet Dim misValue As Object = System.Reflection.Missing.Value Dim …
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 …
Just a quick question. Does anyone have an opinion as to wether it is best to Import or Add Data file when using Outlook .pst files after a re-install and you are putting the customers data back onto the machine. I would normally use Import to put all contacts and …
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. …
Hello to all! I am going to make a stock management and Point of sale for a person on Ms Excel file. Actually my client has a store of bedding accessories (e.g pillows, blankets, quilts, cushions. bedsheets and many other items).I have to maintain such an excel file that should …
Hi, i'm a beginner and i need a macro that look for a specific word, then merge that table an go further. I've created a macro but it doesn't go out of the loop. I have this Word: Sub MergeSpecificRowInOneCell() Selection.WholeStory Selection.Find.ClearFormatting Selection.Find.Font.Italic = True Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = …
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 Dw. If there is anyone who knows how and which languagies are used to develop software's like word processing, Excel, Access, basically things like Office suite. I know Linux has their own different tools for office, as well as Microsoft as well and other OS have different Suites for …
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 all, How can i save embedded pictures in Outlook 2007 when it only gives the option Copy. I hope someone can advise. Thank you misschillout
Here is the order of what happened. Some of it seems weird: 1. I downloaded a web page with Firefox Save Page As. The site should be trustwoirthy (a local newspaper). 2. I edited the HTML file with Notepad to remove everything (ads, scripts, etc) from the page except the …
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 …
The End.