629 Topics

Member Avatar for
Member Avatar for tjeckley

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 …

Member Avatar for tjeckley
1
55
Member Avatar for Blocingzxcz
Member Avatar for diodepump
Member Avatar for rproffitt
0
26
Member Avatar for JModak

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 …

Member Avatar for tinstaafl
0
52
Member Avatar for joshi1984

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, …

Member Avatar for rproffitt
0
159
Member Avatar for help distressed
Member Avatar for help distressed
0
79
Member Avatar for Fian_1

AttributeError Traceback (most recent call last) <ipython-input-1-2b6855960796> in <module> 15 csvFile = open(search_key+".csv","a+",newline="",encoding="utf-8") ---> 16 csvWriter = csv.Writer(csvFile) 17 c = [] 18 i = [] AttributeError: module 'csv' has no attribute 'Writer' Help🙏🙏

Member Avatar for Reverend Jim
1
244
Member Avatar for dlh6213

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 …

Member Avatar for JamesCherrill
0
254
Member Avatar for jithan.palakkal

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

Member Avatar for jayblingham
0
36
Member Avatar for bklynman01

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 …

Member Avatar for shahidul263
0
610
Member Avatar for niksirat

Hi, I want to write a program whose input is the names of the companies and when adding the name of each company, it will take various information from that company of different types, 1- TextBox (daily production rate), 2- CheckBox (select product features), 3- OptionButton (the gender of the …

Member Avatar for Reverend Jim
0
120
Member Avatar for EpifaniaPersons

Hi Everyone! I am new here, and the main purpose of joining this community is getting some help. Actually, I am designing a PHP website where I need to fetch US vehicles data into PHP. I have already used this source to get the vehicle's dataset from here https://www.back4app.com/database/back4app/car-make-model-dataset. Still, …

Member Avatar for RayPalmer
1
357
Member Avatar for Robert_147

Hello, I am fairly new to VBA development trying to upgrade my employee training database in VBA from a single listbox with single line select/add/edit capability to one that pulls employee data from listbox1, searches training available by job title in listbox2, and combines the data into listbox3 also adding …

Member Avatar for Robert_147
0
83
Member Avatar for builder7

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 …

Member Avatar for AndreRet
0
32
Member Avatar for Игорь_6

Hello everyone. I saw services on the Internet where you can search for keywords in the Instagram biography. These services have their own base and they search for it and sell it later. Are there forums on the Internet where there is already a parsed database in the form of …

Member Avatar for rproffitt
0
37
Member Avatar for Bile

--Hi DaniWeb. I have been doying bulk data Uploads from Excel Sheet to MySql data base and hence thought that I may need the reverse of this process and so Export MySql Tables into Excel Format for Backup purposes (I also will be happy for a better suggestion for a …

Member Avatar for juniperoites
1
4K
Member Avatar for DinoJamin

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,

Member Avatar for orichisonic
0
586
Member Avatar for Andrew_77

Dear Experts, I have a requirement to capture data from my workforce (4000+ users) on a regular basis. I've developed a form for this using MS Forms and it does it's job perfectly. However, due to GDPR constraints (and the nature of the data) I need to clear the data …

Member Avatar for rproffitt
0
1K
Member Avatar for riahc3

Trying to get the last row inserted from a Excel sheet. The sheet is called clientes. I have id, name, description Since ID is auto incremental, I can sort by ID: My idea is: oledbcmd = "Select top (1) * From [CLIENTES$] ORDER BY id desc"; but it does not …

Member Avatar for rogerwigaa
0
1K
Member Avatar for cicice1743

Williams said she doesn't hold Zelle responsible for the fraudulent activity, but she does believe they're responsible for having no telephone number to call and inadequate customer service and support. And she had a hard time getting a response from the company through email and Twitter. She said she did …

Member Avatar for rproffitt
0
69
Member Avatar for BreighA

Looking for directions. Where would one go to find a downloadable excel sheet, listing the streets of Algeria city?

Member Avatar for BreighA
0
126
Member Avatar for NuGG

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 …

Member Avatar for NuGG
0
4K
Member Avatar for johnnysnowman38

Hi there, Not sure if I am in the right place, but I wanted to ask where I can access a csv file for all the streets in Belgium?

Member Avatar for rproffitt
0
444
Member Avatar for vlad44

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 & …

Member Avatar for Jack Green
0
2K
Member Avatar for mikecole79

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 …

Member Avatar for jackflint
0
435
Member Avatar for subhraakasuny

Hi All, I have an excel file containg chart.I am able to read the chart from excel file using POI XSSF. But I am not able to save the XSSFChart as an image.I want the chart to be stored in my harddrive as an image(.jpg or .png).Please find my code …

Member Avatar for GovindSharma
0
4K
Member Avatar for ami_2

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 …

Member Avatar for rproffitt
0
142
Member Avatar for samueljacoob967

Tried all steps as per (**Moderator removed spam link**) but not working. Any help will be so much appreciated.

Member Avatar for rproffitt
0
25
Member Avatar for ami_2

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 …

Member Avatar for Gilbertsilva123
0
892
Member Avatar for Barbra_1

Hi there i need help on how I am supposed to do this ER Diagram based on this question. I need to have entities, attributes, relationships and primary/foreign keys. here is the question You are given the following business scenario. SmartService is a newly setup car repair and servicing workshop …

Member Avatar for pritaeas
0
215
Member Avatar for St3v3boy

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 …

0
163
Member Avatar for v.gangani

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 …

0
109
Member Avatar for subhraakasuny

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 …

Member Avatar for orichisonic
2
1K
Member Avatar for webinvest

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 …

Member Avatar for Getahun_2
1
22K
Member Avatar for it@61@sec

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 …

Member Avatar for rproffitt
0
2K
Member Avatar for Start4me

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 …

Member Avatar for Start4me
0
2K
Member Avatar for NuGG

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 …

Member Avatar for rproffitt
0
3K
Member Avatar for Divinedar

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 …

Member Avatar for xrjf
0
586
Member Avatar for Divinedar

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 …

Member Avatar for Divinedar
0
452
Member Avatar for kehar

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 …

Member Avatar for rproffitt
0
447
Member Avatar for HOT3

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 …

Member Avatar for happygeek
0
630
Member Avatar for Reverend Jim

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.

Member Avatar for Reverend Jim
7
9K
Member Avatar for Sheba_1

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 …

0
332
Member Avatar for squeak24

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 …

Member Avatar for Shankar.Shiv
0
296
Member Avatar for khess

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 …

Member Avatar for subhankar_2
3
2K
Member Avatar for cassyjack

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 …

Member Avatar for rproffitt
0
277
Member Avatar for Hawkeye249

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 …

Member Avatar for rproffitt
0
387
Member Avatar for jean_8

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.

Member Avatar for Lena_2
0
311
Member Avatar for infoitmanoj

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 …

Member Avatar for rproffitt
0
313
Member Avatar for aplee

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 …

Member Avatar for Sai_421
0
1K

The End.