Questions for excel


8231

Errors Raised within Class Debug As If Raised at Property Call

I am (unfortunately) developing an application in Excel 2000 VBA. I believe I have discovered that any error raised within a Custom Class property, function, or sub debugs as if the error were rai...
9991

Looping VBA Case Statement

Currently I have the same code in each Case statement and sometimes I have to repeat it 50 times, is there a way to simplify this:
3567

ColdFusion CFSpreadsheet reads empty cells

I give my client a template that they are supposed to populate and then they upload the spreadsheet and I read the file with cfspreadsheet in order to copy the data into a database table.
6502

How to use the excel if function to return a variable concatenated with a string?

If E1 is a cell, how do I return E1 dynamically concatenated with a string?
893

Relative Referencing - Steps

I am trying to do relative referencing for a specific column (in Sheet "OA") where I need to retrieve the content of cells in a new sheet in steps of 110
1979

VBA: Using worksheet name and/or range name as inputs to function

I have a simple function that shades every other row of a given range in a worksheet:
7288

VBA - copy text from Combobox in User from and paste in loop onto excel worksheet

I am new to excel VBA and I have tried to adapt some of the solutions found on Stack Overflow, but I'm still stuck!
2156

Vb.net : Interop exception when showAllData() on Excel sheet?

I have some filters applied on my input excel sheets, so I decided to remove them using showAllData() method in vb.net.
8034

Excel VBA: Setting a Workbook-level default save directory

I want my workbook to have a default save directory, e.g. "n:\mydirectory\hello", So each time I open it and try to save it, it will suggest this directory regardless of which other Workbooks I have
7366

Find which cells have the smallest levenshtein distance

So, I have this Function which will quickly return the Levenshtein Distance between two Strings:
2244

IE7 & 8 Cause Excel to Prompt for Credentials

I have an ASP.NET MVC3 website with custom authentication (i.e. <authentication mode="None" />). It's hosted on IIS with only Anonymous Auth enabled to support some SSO work we're doing. That'...
9758

How can I only sort thru the rows with data?

I have a macro that sorts the rows by a specific column, the problem is I'm manually setting the range for the number of rows to sort (i.e. A2:A174) every time I add a new row. How can I change my...
4089

How to extract each color bar and copy them in a table?

I made a diagram to show unique columns with several colors in each, as shown in the picture.
8571

Save graph from R as editable graphic in Excel

I am writing a GUI in R, and one of the functions I must implement is a button to save graphical output to an Excel sheet, ideally the graphic should be editable in Excel. I am trying to do this the
8861

How does Excel compute the resolution of the metafiles it generates when copying a range “as shown on screen”?

I have some C# code I got from http://bytes.com/topic/c-sharp/answers/572657-net-clipboard-metafiles that copies a cell range under the following two settings:
3965

In Excel, add 1 if not number, or else add the number

In excel, how do I write a formula that does the following:
2035

Database Schema Generator

i have an excel file which describe all the table structure of a database table
3710

VBA Output Write To Cell - #VALUE! Error

I'm trying to make a UDF of mine work (in Excel 2003), and after debugging the problem appears to be summarized in this condensed version of my function:
9966

Error 1004 using Range.Columns - using same syntax as Range.Rows

I'm having some problems with a subroutine in VBA (Excel 2010).
6092

SSAS 2012 - Dimension Modeling

I am working with a structure that results a lot of single attribute dimensions that require no hierarchy. Examples:
2842

How can I make it to automatically 'rewrite' the .xlsx file I'm trying to save?

So, I have the following code to save the highscores into an excel file, it works, I only have one problem, it always asks if I want to rewrite the existing xlsx file, how can I make it to say
1081

How do I count cells that are between two numbers in Excel?

I need a formula to count the number of cells in a range that are between 10 and 10.000:
4335

Error in creating Excel through Android Application

I am using the jxl package for creating a excel file and export it to SD card through my android application. I have added the jxl.jar to my referenced libraries in my application package in eclips...
2861

delete excel worksheets programatically

have an excel workbook with many, many sheets. I want to delete all the sheets except for three of them.
3943

VBA check if file exists

I have this code. It is supposed to check if a file exists and open it if it does. It does work if the file exists, and if it doesn't, however, whenever I leave the textbox blank and click the submit
4445

Killing an interop Application process

I have the following in a program (written in VB.NET):
8871

Excel - Advanced Text Filters

I have a long list of strings:
6064

How to correctly Public and Set a Worksheet?

Public sp As Worksheet // on top of ThisWorkbook module
542

How could I have image URLs in column “C” display their corresponding images in column “N” in Excel?

I've an Excel file with a bunch of columns, one of which is "ImageURL", which, of course, displays unique URLs as text.
783

Read a value from spreadsheet X, compare adjacent values between spreadsheets X and Y

I have an Macro Based Excel file that generates a list of items received and their status (i.e. received, repaired, etc). This program runs daily, and right now I have it capture the previous day'...
8134

excel into matlab

I have several excel spreadsheets in a folder, where each spreadsheet contains several worksheets. I've written a code which loads a specific worksheet from each spreadsheet into matlab. The worksh...
4920

Excel VBA: How to find max/min of a range while ignoring error cells

How can I use VBA in Excel to determine the max/min of a range that contains error cells such as #N/A or empty cells? I know this is a fairly easy task to conquer with Excel array formulas using
6507

Crystal Reports exporting to Excel Issue

In a current C# application I do maintenance on, we have upgraded to Visual Studio 2008 from Visual Studio 2003. We have always used the included Crystal Reports that came with Visual Studio.
804

ms-excel: extract decimal and integer part of a number and disable fields changing

I have a numeric field (say A). I have to extract its integer part in another field (say B) and its decimal part in another field (say C).
4051

Data Conversion Issue in SSIS package - Text to GUID

I am developing a SSIS package that will open an Excel spreadsheet and import the data into a database table in SQL Server 2008. When I try to convert the Excel column data type: Unicode String
684

Invalid Formula Does not throw Error - VBA Excel 2010 64 bit

I have this project that works fine with Excel 32 bit but I am having problems running it in 64 bit.
4133

MS Excel - existing connection strings correspond to which datatable

I have an excel spreadsheet that has 8 connections. I would like to know what connection string corresponds to which datatable/pivot table in excel. A solution in 2007 or 2010 method is fine.
9307

Creating a new excel workbook

Can someone please help me with the following code:
4567

Rave Reports Excel File Render Object?

I notice that Rave reports for Delphi 7 (default version) comes with PDF, HTML, RTF, and TXT Render Objects. Does anyone know of a place to download a free or opensource render object for Excel, or
7340

C# Excel to Gridview OleDB Error

I got an error about OleDB. I just want my excel file import to Gridview.
4555

Formula only if cell not empty

I'm trying to do a formula that will fill the cell value, but only once, when the cell is empty. Once filled I want the value to stay as is, even though cells that are part of the formula changed.
9120

How to check Excel time values in Access VBA?

I'm processing an Excel workbook with Access VBA (see Reading an Excel workbook from Access) and now I want to check if a cell contains a valid time value. For dates I use IsDate() and it works fin...
713

Clear radio-buttons after completing forms

I'm having a series of userforms, making a questionnaire. Each userform consists of a couple optionbuttons/checkboxes. The program works fine.
7248

Is there a constraint on the depth level of grouping in Excel?

I am trying to write a macro in Excel which will allow me to automatically do groupings based on the number located in the first column. Here is the code.
5647

Generating Excel file based on folder contents

Is it possible to create a excel spreadsheet based on a folder tree, including its subdirectories and filenames? Is their a way to do it with excel itself or is there a program out there that makes...
2262

Excel VBA WorkSheet.Copy After Excel 2013

I want to copy a worksheet and place it DIRECTLY after another sheet. But I having trouble when there are hidden sheets involved.
3658

Using the left-function

I'm trying to create a simple macro that copys the two first numbers in each cell in a column and printing them in a different column. This is in a excel-document with more than 1 worksheet. I've t...
1671

Making all pivot tables on one sheet mimic each other in terms of rows expanding and collapsing

Alright, I'm new to VBA but I know this has to be possible. I spent a while coding android applications, but I wouldn't call myself nearly an expert, probably not even intermediate to be honest. Ho...
6706

Java & Excel: value being read wrong

I am parsing data from an excel file and adding it to my data base using HSSFCell to parse the Excel file, I am using the following code to read the file
6683

is it possible to recalculate only a cell or a range in VBA

is it possible to recalculate only a cell or a range in VBA ? What I like to use for a sheet is the following, but how to do it on a cell only ? Or range ?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.