14 Answered Questions

[SOLVED] How to avoid using Select in Excel VBA

  • 2012-05-23 05:57:58
  • BiGXERO
  • 270377 View
  • 526 Score
  • 14 Answer
  • Tags:   excel vba

13 Answered Questions

[SOLVED] Error in finding last used cell in Excel with VBA

9 Answered Questions

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

  • 2014-03-20 19:09:13
  • Portland Runner
  • 852155 View
  • 570 Score
  • 9 Answer
  • Tags:   regex excel vba

41 Answered Questions

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

44 Answered Questions

[SOLVED] How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?

  • 2008-09-29 22:30:28
  • mistrmark
  • 1069368 View
  • 1845 Score
  • 44 Answer
  • Tags:   c# .net excel file-io

6 Answered Questions

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

3 Answered Questions

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

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

3 Answered Questions

32 Answered Questions

[SOLVED] Reading Excel files from C#

3 Answered Questions

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

  • 2011-11-08 08:55:07
  • Aziz
  • 67844 View
  • 36 Score
  • 3 Answer
  • Tags:   excel vba

34 Answered Questions

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

  • 2011-07-11 11:23:56
  • Shailesh Sahu
  • 980390 View
  • 424 Score
  • 34 Answer
  • Tags:   c# .net excel vb.net ole

8 Answered Questions

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

3 Answered Questions

[SOLVED] How to copy a line in excel using a specific word and pasting to another excel sheet?

  • 2012-07-24 12:58:01
  • user1548751
  • 26121 View
  • 16 Score
  • 3 Answer
  • Tags:   excel vba

2 Answered Questions

[SOLVED] Clean up Excel Interop Objects with IDisposable

26 Answered Questions

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

  • 2011-05-14 13:53:39
  • Lyubomyr Shaydariv
  • 475644 View
  • 435 Score
  • 26 Answer
  • Tags:   excel csv utf-8

22 Answered Questions

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

  • 2009-06-22 10:37:13
  • Jonathan Sayce
  • 1125641 View
  • 480 Score
  • 22 Answer
  • Tags:   excel vba passwords

53 Answered Questions

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

  • 2008-10-08 06:55:01
  • robertkroll
  • 223187 View
  • 465 Score
  • 53 Answer
  • Tags:   c# excel

6 Answered Questions

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

  • 2013-06-28 07:51:16
  • Chris
  • 216704 View
  • 172 Score
  • 6 Answer
  • Tags:   excel vba

5 Answered Questions

[SOLVED] How do I put double quotes in a string in vba?

10 Answered Questions

21 Answered Questions

[SOLVED] Test or check if sheet exists

  • 2011-07-14 03:23:52
  • yse
  • 449159 View
  • 106 Score
  • 21 Answer
  • Tags:   excel vba scripting

7 Answered Questions

[SOLVED] Detect whether Excel workbook is already open

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

1 Answered Questions

[SOLVED] Vlookup using 2 columns to reference another

3 Answered Questions

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

  • 2014-05-02 16:44:00
  • Tim Williams
  • 5464 View
  • 64 Score
  • 3 Answer
  • Tags:   excel vba

5 Answered Questions

[SOLVED] How do I use FileSystemObject in VBA?

6 Answered Questions

[SOLVED] OleDB & mixed Excel datatypes : missing data

3 Answered Questions

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

  • 2016-04-02 01:32:56
  • user4039065
  • 875 View
  • 16 Score
  • 3 Answer
  • Tags:   excel vba range

20 Answered Questions

[SOLVED] How to read and write excel file

  • 2009-10-04 10:54:38
  • user177785
  • 736032 View
  • 168 Score
  • 20 Answer
  • Tags:   java excel

13 Answered Questions

[SOLVED] How can I find last row that contains data in a specific column?

  • 2008-09-16 10:54:53
  • Lipis
  • 344919 View
  • 61 Score
  • 13 Answer
  • Tags:   excel vba

22 Answered Questions

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