[excel] Forum Topics

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 …

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?

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 …

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 …

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

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

Good day I am experiencing issues with Microsoft Excel 2013 32- bit running on Windows 7 Ultimate 64-bit. Whenever I start Excel or switch to it from another program the following error message pops up: "An unexpected error occured: Object reference not set to an instance of an object" To …

Hey Guys, So using a webform textarea I am passing some data into PHP. This data is basically 4 columns of an excel sheet and potentially unlimited rows. Now I want to be able to go through this data, select each of the four individual elements from each row, insert …

Group, I'm trying to import an EXCEL table into an SQL Server Table. Although new to SQL, I've done it several times. However for the first time I'm having to import a column that is a date. I'm not sure how the EXCEL column should be formatted so that it …

Good day guys I need help for adding rows in datagrid where the rows to be added are equal to the number of rows copied from excel. I can copy the data but it displays only the first row from excel on the last row of datagrid but if I …

Hi, I could import some numbers from notepad to excel 2010, and after right click the cells were converted to General from scientific format. However, when I drag the notepad file to Excel 2013 they cannot be converted to General format. I tried different ways to convert them from text …

I have an Excel sheet that I am looking to combine two columns from one sheet into a new sheet. I am including the Excel file. The columns are the B and R from the Title_Frame_Register sheet. I am trying to output to a new sheet and it what I …

Hi Everyone! Can anybody point me to the right direction or check what am i doing wrong. Im trying to export data from php to excel using phpexcel( which is working fine if im am only getting 1 specific record). but when i tried adding a loop to create a …

Hi everyone; I got no idea how to start this and if it is possible; I have a text file (.txt) that have lot of lines and I want it to transfer it in Excel (.xlsx / CSV) But not all will be transfer in excel, only a specific number …

Hi - I have a corrupted Excel file which I can't repair. Cannot attach the file writes that "The file type you are attempting to upload is not allowed." When I open the file writes that "cannot open the file because the file format or the file extension is invalid. …

What tools have people had the most success with for repairing corrupt Excel files? I have had 2 people come to me recently with corrupt Excel files (oolone was XLS and the other XLSX). I tried opening the files with versions of Excel and repair but nothing. I then tried …

Hello VB.net Programmers, Please help about delimited. I've been looking to the forum and other sites about this but can't find any. Here is my problem. 1. I need to put the text file to excel but this text file don't have comma and tab. This are separated only with …

Hi group, I'm attempting to create and write to an Excel spreadsheet with data from a text file. The code is meant to parse each line of the text and place the data into individual variables. I then need to place these variables into the appropriate cells on this newly …

Hello Group, I'm attempting to create and write to an Excel file. I'm sure I've hit the first of many snags. Hopefully you can point me in the right direction. In this first attempt, I'm getting an error code: "Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))". The error is attached …

Dear forum members, i a m trying to export the contents of datagrid to excel but i am facing errors.After searching i have seen that the problems occurs because one of my columns is of type TIME and taht is why i am getting the error : Object reference not …

Good day! I just want a little help on how to loop from one cell to the end and set a sum Formula. I have Columns From **F to O **and created a Sum formula for column F. Is there a way to make it in a loop and pass …

We had a need to factory restore our PC. It is Windows 7 Home Preimum with SP1. We copied all data off ran the factory restore drive, reinstalled Office 2007, restored all data files and now when we open Excel files we cannot format them proerly. The page breaks will …

I am having an issue with a formula in excel and am not understanding what it is doing =COUNTIF(J28:L31,"w")+COUNTIF(J28:L31,"l") is supposed to give me a result of the number of cells with the value of either w or l in that range But instead of displaying a number, it is …

My Mac address book syncs itself with my iPhone. Somehow (I think through Microsoft Entourage??) it silently added contacts to the address book for everyone I sent/received an email to/from. I now have thousands of contacts that have an email address only with no phone number, and I don't want …

Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me. foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*")) In advance, thanks …

My problem is this: I am trying to automate the download, parsing, and insertion of an excel file into a database. I have the parser and inserter done, but I can't seem to find a way to download the files automatically. The core of the issue is that the website …

Group, I've created some spreadsheets that others use. The headings of the spreadsheets are divided up with colors. However after I've created these and saved them formatted as I like, some of these cells are changing automatically after the other users open them up. I've read online there may have …

Hi Group, I've recreated a spreadsheet that has multiple macro's behind it. One of these macro's opens and existing file, copies the data in it and then pastes it into the original workbook (where the macro's originate) and then closes the existing file. After the copy and paste is done, …

Dearl all, Is there any way or codes for export dataset or datatabe to excel file. Whenever I use click event in the button, it will save my report in an excel file. My information inside in datatable (dataset) from database and I want to save it in excel file. …

Before upgrading to EXCEL 2010, I am able to open dbf files created in Visual Foxpro 7 or 9 in Excel 2003. I am not sure why after installing EXCEL 2010 I am no longer able to open the file. I get the error message when I tried opening the …