13 Answered Questions

[SOLVED] How to avoid using Select in Excel VBA

  • 2012-05-23 05:57:58
  • BiGXERO
  • 204494 View
  • 425 Score
  • 13 Answer
  • Tags:   excel vba excel-vba

12 Answered Questions

[SOLVED] Error in finding last used cell in VBA

6 Answered Questions

[SOLVED] How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops

36 Answered Questions

[SOLVED] How do I properly clean up Excel interop objects?

40 Answered Questions

[SOLVED] Create Excel (.XLS and .XLSX) file from C#

  • 2008-09-29 22:30:28
  • mistrmark
  • 935554 View
  • 1620 Score
  • 40 Answer
  • Tags:   c# .net excel file-io

2 Answered Questions

6 Answered Questions

[SOLVED] Loop through files in a folder using VBA?

32 Answered Questions

[SOLVED] Reading Excel files from C#

3 Answered Questions

[SOLVED] Why MS Excel crashes and closes during Worksheet_Change Sub procedure?

  • 2012-12-13 13:31:14
  • derek
  • 33229 View
  • 32 Score
  • 3 Answer
  • Tags:   excel vba excel-vba

31 Answered Questions

[SOLVED] 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

  • 2011-07-11 11:23:56
  • Shailesh Sahu
  • 622261 View
  • 300 Score
  • 31 Answer
  • Tags:   c# .net excel vb.net ole

5 Answered Questions

[SOLVED] What is a correct mime type for docx, pptx etc?

3 Answered Questions

3 Answered Questions

[SOLVED] Excel VBA, getting range from an inactive sheet

47 Answered Questions

[SOLVED] How to convert a column number (eg. 127) into an excel column (eg. AA)

  • 2008-10-08 06:55:01
  • robertkroll
  • 195180 View
  • 409 Score
  • 47 Answer
  • Tags:   c# excel

21 Answered Questions

[SOLVED] Is there a way to crack the password on an Excel VBA Project?

5 Answered Questions

[SOLVED] What is the difference between .text, .value, and .value2?

  • 2013-06-28 07:51:16
  • Chris
  • 166503 View
  • 132 Score
  • 5 Answer
  • Tags:   excel vba excel-vba

7 Answered Questions

[SOLVED] Detect whether Excel workbook is already open

  • 2012-02-21 06:19:48
  • user1222679
  • 259389 View
  • 57 Score
  • 7 Answer
  • Tags:   excel vba excel-vba

2 Answered Questions

[SOLVED] Clean up Excel Interop Objects with IDisposable

24 Answered Questions

[SOLVED] Is it possible to force Excel recognize UTF-8 CSV files automatically?

  • 2011-05-14 13:53:39
  • Lyubomyr Shaydariv
  • 389922 View
  • 326 Score
  • 24 Answer
  • Tags:   excel csv utf-8

6 Answered Questions

[SOLVED] OleDB & mixed Excel datatypes : missing data

3 Answered Questions

[SOLVED] Is the . in .Range necessary when defined by .Cells?

7 Answered Questions

2 Answered Questions

[SOLVED] Using a UDF in Excel to update the worksheet

  • 2014-05-02 16:44:00
  • Tim Williams
  • 3853 View
  • 54 Score
  • 2 Answer
  • Tags:   excel vba excel-vba

19 Answered Questions

[SOLVED] How to read and write excel file

  • 2009-10-04 10:54:38
  • user177785
  • 608092 View
  • 145 Score
  • 19 Answer
  • Tags:   java excel

5 Answered Questions

[SOLVED] How do I use FileSystemObject in VBA?

20 Answered Questions

[SOLVED] Test or check if sheet exists

12 Answered Questions

[SOLVED] How can I find last row that contains data in the Excel sheet with a macro?

  • 2008-09-16 10:54:53
  • Lipis
  • 324462 View
  • 53 Score
  • 12 Answer
  • Tags:   excel vba excel-vba

11 Answered Questions

[SOLVED] Microsoft Excel ActiveX Controls Disabled?

  • 2014-12-10 21:44:09
  • Mike Pedersen
  • 229915 View
  • 107 Score
  • 11 Answer
  • Tags:   excel vba activex

22 Answered Questions

[SOLVED] Microsoft Excel mangles Diacritics in .csv files?

34 Answered Questions

[SOLVED] Stop Excel from automatically converting certain text values to dates

  • 2008-10-02 23:30:43
  • user16324
  • 398174 View
  • 439 Score
  • 34 Answer
  • Tags:   excel csv import