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
39
Member Avatar for Blocingzxcz
Member Avatar for diodepump
Member Avatar for rproffitt
0
25
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
50
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
154
Member Avatar for help distressed
Member Avatar for help distressed
0
75
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
221
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
248
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
33
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
598
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
117
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
350
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
74
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
31
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
578
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
55
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
121
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
443
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
431
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
22
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
885
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

The End.