629 Topics
 | |
 | 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 … |
| | 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 …  |
 | 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 … |
 | I have a worksheet of about 388 items that each item is exported into a template worksheet that is created to itemize each item. It creates the worksheets but I can't get it to stop looping at the line of code in bold comments icons. The line that it stops …  |
| | 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 … |
| | I had made a Microsoft Office Access 2007 database with more than 2000 records. A copy of which was given to my friend. We both made a number of amendments and added new records in our respective copies. Now I want to compare both databases & merge the databases into …  |
 | 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 … |
| | 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 …  |
 | 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 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 … |
| | 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 … |
 | 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 … |
 | 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 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, … |
The End.