Questions tagged [vba] - KnowledgeHub

13

votes

4

answers

VB6/VBScript change file encoding to ansi

asked 2011-03-03T14:35:37.207

20

votes

1

answers

Checking for #N/A in Excel cell from VBA code

excel vba

asked 2011-02-28T14:43:15.543

17

votes

4

answers

Set property of vba class with object reference

vba

asked 2011-02-23T15:05:40.770

9

votes

3

answers

Excel: Check Sheet Dependencies within a Workbook?

excel excel-2003 vba

asked 2011-02-21T09:55:50.503

49

votes

5

answers

How to Freeze Top Row and Apply Filter in Excel Automation with C#

c# excel vba office-interop export-to-excel

asked 2011-02-20T22:22:50.167

9

votes

5

answers

Why does CLng produce different results?

vba casting rounding floating-accuracy

asked 2011-02-14T08:03:10.680

9

votes

5

answers

Turn off Excel Background Error Checking on opening the workbook

vba excel

asked 2011-01-21T00:04:17.967

9

votes

2

answers

Is it possible to pass a reference to a pointer from Excel VBA to C++?

c++ vba pointers excel

asked 2011-01-10T17:20:56.597

9

votes

8

answers

Alternate Row Colors in Range

excel vba

asked 2011-01-07T18:47:53.833

11

votes

5

answers

How can I check for or cancel MULTIPLE pending application.ontime events in excel VBA?

excel vba ontime

asked 2011-01-05T00:20:53.860

9

votes

2

answers

How to execute a query in ms-access in VBA code?

ms-access vba

asked 2010-12-31T01:08:29.400

43

votes

3

answers

How to unit test Excel VBA code

unit-testing excel vsto vba

asked 2010-12-28T16:22:46.720

12

votes

9

answers

Charts Do Not Automatically Update When Data Changes

excel excel-2007 vba

asked 2010-12-16T22:50:47.250

11

votes

1

answers

Architecture of an Excel application

architecture excel excel-2007 vba

asked 2010-11-30T22:16:21.697

10

votes

5

answers

Display a message box with a timeout value

excel vba winapi messagebox wsh

asked 2010-11-25T05:48:11.453

90

votes

9

answers

How to put a tooltip on a user-defined function

excel vba

asked 2010-11-24T00:24:08.087

9

votes

4

answers

how to make VBA code compatible for office 2010 - 64 bit version and older office versions

vba ms-office 32bit-64bit

asked 2010-11-22T23:05:33.847

32

votes

4

answers

Recommended IDE for VBA

excel vba

asked 2010-11-19T18:11:33.040

39

votes

14

answers

How to get started with Visual Basic for Applications?

vba

asked 2010-10-26T05:04:49.723

16

votes

2

answers

Getting the unicode value of a char in VB

vba unicode

asked 2010-10-23T21:48:41.853

16

votes

7

answers

How to stop VBA code running?

vba excel

asked 2010-10-20T16:02:15.747

34

votes

4

answers

VBA: How to display an error message just like the standard error message which has a "Debug" button?

vba scripting excel ms-office

asked 2010-10-12T05:43:32.987

57

votes

4

answers

Loop through each cell in a range of cells when given a Range object

excel vba

asked 2010-10-06T17:48:53.787

10

votes

2

answers

How do I programmatically turn off the wavy red lines in a Microsoft Word document via VBA?

vba ms-word spell-checking

asked 2010-09-29T13:37:12.290

11

votes

3

answers

Embed an R process in a VBA macro

vba r embed

asked 2010-09-16T20:03:14.530

10

votes

3

answers

Excel VBA get range of user selected range by mouse

vba excel excel-2007 excel-2003

asked 2010-09-10T17:25:44.763

18

votes

5

answers

Best way to define a large vba string - i.e. heredoc equivalent?

vba

asked 2010-09-08T19:40:28.663

25

votes

1

answers

How do you get a Range to return its Name?

excel vba named-ranges

asked 2010-09-02T19:27:13.030

10

votes

2

answers

How to permanently allow macro for a trusted worksheet?

excel vba excel-2007

asked 2010-08-31T03:46:41.443

16

votes

5

answers

Unit testing in MS Access

unit-testing ms-access testing vba

asked 2010-08-25T19:09:33.810

10

votes

1

answers

Extract Data from Word Document to an Excel SpreadSheet

excel vba ms-word

asked 2010-08-25T15:17:34.533

13

votes

6

answers

Calling a Python script from Excel/VBA

python vba excel

asked 2010-08-25T15:10:56.767

10

votes

8

answers

What if any links exist to free Excel "helper" class libraries for C#?

c# .net excel vba vsto

asked 2010-08-24T02:17:31.913

49

votes

4

answers

How to get name of the computer in VBA?

vba environment-variables computer-name

asked 2010-08-23T19:38:41.767

15

votes

7

answers

VBA. How to find position of first digit in string

vba digit

asked 2010-08-23T13:00:27.737

19

votes

4

answers

Calling web service using VBA code in Excel 2010

excel vba web-services excel-2010 office-2010

asked 2010-08-19T12:45:49.930

10

votes

3

answers

Connection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect

excel vba oracle-database ms-access ado

asked 2010-08-03T15:50:35.393

9

votes

2

answers

VBA: Difference between & and +

vba operators concatenation

asked 2010-07-29T17:09:43.333

41

votes

7

answers

How to Insert Double or Single Quotes

excel vba double-quotes single-quotes

asked 2010-06-30T01:49:31.323

22

votes

3

answers

Sending HTTP requests with VBA from Word

vba ms-word httprequest

asked 2010-06-25T15:21:17.120

134

votes

4

answers

Display milliseconds in Excel

excel vba time

asked 2010-06-22T17:09:03.820

13

votes

4

answers

How can I write to a text file reliably from Excel VBA?

vba excel

asked 2010-06-21T14:41:09.490

67

votes

6

answers

How to name an object within a PowerPoint slide?

vba powerpoint

asked 2010-06-19T03:34:14.577

11

votes

1

answers

Programmatically rebuild .exd-files when loading VBA

visual-c++ vba apc office-2010

asked 2010-06-11T08:59:08.397

17

votes

6

answers

Get start range and end range of a vertically merged cell with Excel using VBA

excel vba

asked 2010-06-01T15:32:48.303

15

votes

3

answers

cycling through values in a MS Access list box

vba ms-access ms-access-2007

asked 2010-05-28T23:29:35.950

31

votes

3

answers

Bang Notation and Dot Notation in VBA and MS-Access

ms-access vba vb6 notation

asked 2010-05-27T18:49:39.073

22

votes

7

answers

VBA Sleep Doesn't Work

vba sleep

asked 2010-04-29T13:32:30.660

11

votes

2

answers

Excel VBA: how to cast a generic control object into a ComboBox object?

vba excel

asked 2010-03-03T01:43:20.273

15

votes

4

answers

How can I use an optional array argument in a VBA procedure?

vba default parameters option-type

asked 2010-02-15T10:47:01.000

Questions tagged vba