Alex Rivera | Logout

Questions tagged excel

385 questions · page 3 of 8

Sort by: Newest Votes Active
34
votes
3
answers

Write from R into template in excel while preserving formatting

excel r
asked 2012-06-27T14:48:26.880
19
votes
3
answers

macro - open all files in a folder

excel excel-2010 vba
asked 2012-06-22T08:41:55.567
10
votes
4
answers

How do I format Time in [h]:mm excel format using format() function in VBA

vba excel
asked 2012-06-21T17:42:13.467
10
votes
5
answers

How convert XLS to RESX?

asp.net excel resx
asked 2012-06-21T07:33:34.140
15
votes
2
answers

How do I redefine a named range with VBA?

excel vba
asked 2012-06-14T11:14:26.413
12
votes
7
answers

Excel Calculate the date difference from today from a cell of "7/6/2012 10:26:42"

excel date
asked 2012-06-07T08:50:18.777
19
votes
4
answers

melt / reshape in excel using VBA?

r vba excel pivot-table reshape2
asked 2012-06-06T20:32:26.453
35
votes
3
answers

Excel dropdown with name/value pairs

excel
asked 2012-06-06T14:45:41.887
12
votes
5
answers

Spellcheck a single word in Excel function

excel vba spell-checking
asked 2012-05-27T18:16:42.187
8
votes
2
answers

VBA WebBrowser capture full screen

vba internet-explorer-8 excel browser
asked 2012-05-25T18:23:58.133
651
votes
15
answers

How can I avoid using Select in Excel VBA?

excel vba
asked 2012-05-23T05:57:58.193
9
votes
6
answers

Fastest way to transfer Excel table data to SQL 2008R2

excel vba sql-server-2008 import large-data
asked 2012-05-22T18:42:30.987
8
votes
3
answers

Excel 2010: Replace a table by an external connection without impacting other sheets

excel excel-2010
asked 2012-05-21T12:08:34.577
12
votes
4
answers

VSTO Excel Workbook add-in not loading via Visual Studio debugger on 1 computer

excel vsto ms-office
asked 2012-05-21T00:22:22.980
11
votes
2
answers

Assign event handlers to controls on user form created dynamically in VBA

vba excel excel-2007
asked 2012-05-15T00:10:26.070
53
votes
4
answers

Why use arrays in VBA when there are collections?

arrays vba excel
asked 2012-05-14T07:59:28.417
24
votes
2
answers

Create Chart from Array data and not range

arrays excel vba charts range
asked 2012-05-13T07:30:17.290
396
votes
12
answers

Convert xlsx to csv in Linux with command line

linux excel csv converters xlsx
asked 2012-05-11T19:18:12.767
12
votes
2
answers

BUG: Can't choose dates on a DatePicker that fall outside a floating VSTO Add-In

c# .net excel vsto datetimepicker
asked 2012-05-10T00:45:10.480
24
votes
6
answers

How to highlight a cell using the hex color value within the cell?

vba excel excel-2010 conditional-formatting
asked 2012-05-04T20:00:32.970
17
votes
2
answers

VBA Range from String

vba excel
asked 2012-05-01T20:20:44.010
16
votes
4
answers

Using VBA to check if below cell is empty

excel vba
asked 2012-04-21T22:38:33.870
21
votes
2
answers

Assign code to a button created dynamically

vba excel
asked 2012-04-19T08:41:11.590
15
votes
11
answers

How to lock specific cells but allow filtering and sorting

excel vba
asked 2012-04-17T19:24:58.450
19
votes
6
answers

Split Uppercase words in Excel

regex vba excel excel-formula
asked 2012-04-17T11:23:22.167
12
votes
4
answers

Best way to export data from Java to MS Excel

java excel
asked 2012-04-17T07:49:30.860
11
votes
2
answers

Creating a Workbook with a custom name without saving it to disk

excel vba
asked 2012-04-15T19:45:48.700
32
votes
4
answers

How to call function from another specific workbook in VBA?

vba excel
asked 2012-04-04T13:49:08.813
46
votes
8
answers

Excel compare two columns and highlight duplicates

excel excel-formula
asked 2012-04-04T09:45:38.470
8
votes
2
answers

Reading Excel InterMixed DataType Without Modifying Registry Key

c# excel registry oledb registrykey
asked 2012-03-30T03:31:07.640
59
votes
13
answers

xls to csv converter

python excel csv xls export-to-csv
asked 2012-03-27T06:25:09.013
41
votes
4
answers

Exporting to .xlsx using Microsoft.Office.Interop.Excel SaveAs Error

c# excel winforms-interop
asked 2012-03-19T11:55:32.923
8
votes
1
answers

Adding data to an Excel file using jxl

java excel jxl
asked 2012-03-11T21:17:12.587
9
votes
7
answers

Date formats/values change when file is opened programmatically

excel vba date csv
asked 2012-03-08T22:51:23.640
10
votes
2
answers

Error while reading Excel sheet using Java

java excel apache-poi
asked 2012-03-08T16:27:12.180
21
votes
14
answers

VBA Excel Button resizes after clicking on it (Command Button)

excel vba button resize
asked 2012-03-06T09:49:08.893
18
votes
2
answers

Preventing Excel VBA compile errors due to users having an older version of MS Office (MS Outlook) installed?

vba excel
asked 2012-02-28T23:16:08.127
9
votes
1
answers

How to hide code in VBA applications

vba excel
asked 2012-02-24T04:34:47.610
9
votes
4
answers

Excel VBA: Enabling Macro Settings

excel vba
asked 2012-02-23T21:44:55.837
81
votes
7
answers

Detect whether Excel workbook is already open

excel vba
asked 2012-02-21T06:19:48.500
37
votes
6
answers

Unmerging excel rows, and duplicate data

vba excel
asked 2012-02-09T16:45:26.473
30
votes
3
answers

To infinity and beyond in VBA

.net vba excel
asked 2012-02-09T01:45:46.563
8
votes
2
answers

Creating a new excel worksheet via .Copy() and moving it to the last position

excel powershell copy position move
asked 2012-02-01T10:30:52.123
10
votes
2
answers

Creating excel sheet from template in Java, new versions of Excel

excel apache-poi xssf poi-hssf excel-template
asked 2012-01-25T23:33:44.177
13
votes
1
answers

Excel 2010 Redim Preserve crash

vba excel
asked 2012-01-19T18:06:58.920
35
votes
4
answers

html parsing of cricinfo scorecards

html regex excel xml vba
asked 2012-01-10T03:39:18.783
32
votes
3
answers

Are there any spreadsheet widgets for Android?

android file excel view spreadsheet
asked 2012-01-09T11:13:13.257
8
votes
3
answers

VBA - Generate Excel File from Access (QueryTable)

excel ms-access vba stored-procedures
asked 2012-01-03T17:47:21.010
9
votes
1
answers

Dynamically insert macro into a new excel workbook

excel vba
asked 2011-12-26T11:18:17.553
38
votes
5
answers

VBA Count cells in column containing specified value

vba excel
asked 2011-12-21T16:16:10.327
← Prev page 3 of 8 Next →