534 Topics

Member Avatar for
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
35
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
118
Member Avatar for help distressed

Even after formatting cells as numbers their sum adds up to zero. How to correct this anomaly?

Member Avatar for help distressed
0
71
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
142
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
217
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
584
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
104
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
337
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
65
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
27
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
35
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 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 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
119
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
442
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
427
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
139
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
853
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
213
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
159
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 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 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
541
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
436
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
440
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
331

The End.