[excel] Forum Topics

Hi I have data set where I find it easy to sort data by using pivot tables. BUT one essential cell is not a part of each sample ID. I have tried to make a macro to insert this data without luck. So in b column every time an empty …

Am having a little problem with importing data from MS SQL to and Excel sheet. I followed previous answers on daniweb, but they couldn't help me out. Here my code. Private Sub btnExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExcel.Click Dim appXL As New Microsoft.Office.Interop.Excel.Application Dim shXL As …

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 …

Hello all, I am using Office.Interop.Excel.Application in which i have to save a file using saveas() but before saving it i have to disable the Excel's OverWrite prompt . I did tries Application.DisplayAlerts = false; But it's not working , How to do this??? Pl Help ?

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 …

I'm currently have and excel speadsheet that has 3 rows. What I would like to do is create a macro that reads the last populated row, usually will be column A1, and then created a new column listing the current date and time. So for example, I have ColA ColB …

How to export the column data from excel to listbox without using database. plz help

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 …

I am using following C++ code to enter a value of X which is used to print out variable CDF. This C++ code is expected to give very similar value we get from NORMDIST function in excel. However I get following error in debugger with out getting any output in …

Since upgrading to Microsoft Office 2007 I now have trouble reading PowerPoint documents from a particular client. Before I upgraded, I had no troubles reading their PowerPoint. Now, I have missing fonts and graphics - so much so that many pages are blank, or filled only with a few dots …

Good Afternoon: I would like to have this JSON object written out to a CSV file so that the keys are header fields (for each of the columns) and the values are values that are associated with each header field. Is there a best practice for working with this? Ideally …

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

Hi this is scorpionz I am uploading an excel sheet file using PHP Now the file code is working fine for gif files but not working if i provive xls extension Here is the php main code [code] <?php // include 'config.php' include 'uploadcode.php'; if(isset($_POST['upload_file'])) { $user_file = $_FILES["car_info_file"]["name"]; upload_files($_FILES["car_info_file"]["name"]); …

I have a computer that is running Windows XP with Office 2007 Professional. He is having problems only with the Powerpoint files in the office, specifically .pptx files. When you double-click on the file it opens up to a blank presentation. Once that is open if you click open and …

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 …

Hello all, Help me to understand how they create deal or no deal game in excel? is that converted? or made in excel? that would be very helpfull.

I am importing Excel into Data Base. I enter in Excel is 9-Oct-2006.I want to get the excel to php file but i am not getting. I am trying this code $date = date('m-d-Y',strtotime($dob)); echo $date; but getting o/p is 01-01-1970 any body help me to get date formate

i want a macro which can find the "$" select all the data and copy it to the next sheet The dollar symbols are dynamic so 1st and 4th dollar symbol will be copied sheet 1, data between 4th and 5th will be copied to sheet2,data between 2nd and 3rd …

Hi all, I am trying to create a script that I can run and edit a user's settings on their excel. IE: the script will edit the user's options by enabling macros and adding in the add-on. Anyone ever work on something like this?

Hi, I need to validate a text input with the rest of the data inside excel file. The following is my code. It just read the text input and only execute data in row 1 only instead of searching other model's data. Any suggestion where did the code goes wrong? …

Hi all, Want to write some data from C# to Excel. Code enough I thought, here at DANI's and on the web. So I managed to come up with this : [CODE=csharp]private void DoExcel(string Fname) { Microsoft.Office.Interop.Excel.ApplicationClass excel = null; Microsoft.Office.Interop.Excel.Workbook wb = null; Microsoft.Office.Interop.Excel.Worksheet ws = null; Microsoft.Office.Interop.Excel.Range rng …

guys, i have a bit of an anomole exporting to excel. on date formats, it seems no matter what i export to excel, it becomes a 24hr clock. for instance the date format thats being exported is stored as:: 03/11/2015 04:26:09 PM - however when it hits excel, it becomes: …

Guess this is javascript. Similar as in excel, (I have seen this before), lets say I have 3 fields in a form. Now when entering a numeric value in field 1, and lets say field 2 has the value of 5, then the value of field 1 times field 2 …