Questions tagged [vba] - KnowledgeHub

30

votes

2

answers

How to get the size of a range in Excel

asked 2010-02-10T15:19:53.997

13

votes

2

answers

Referencing an Excel address within a cell, but also additional text

vba excel

asked 2010-02-09T19:50:05.063

13

votes

6

answers

How can I write to the console from Excel vba code?

vb.net debugging excel console vba

asked 2010-01-26T20:14:02.270

32

votes

6

answers

Using Python to program MS Office macros?

python excel vba ms-office

asked 2010-01-26T19:23:23.700

15

votes

1

answers

How to know number of sheets in a workbook?

java excel apache-poi poi-hssf vba

asked 2010-01-16T14:17:01.890

9

votes

1

answers

Add an Image to Word Document and Scale it using VBA

vba ms-word

asked 2010-01-08T18:21:35.010

26

votes

5

answers

how do I express the term if x is integer in VBA language?

vba vb6

asked 2010-01-02T21:30:47.887

13

votes

6

answers

Build add-in for VBA IDE using VB.NET

vb.net vba add-in vbe

asked 2009-12-21T21:04:59.270

15

votes

5

answers

Record cannot be read; no read permission on 'MSysObjects'

excel ms-access ms-access-2007 vba

asked 2009-12-21T01:06:04.353

12

votes

8

answers

Requery a subform from another form?

vba forms ms-access

asked 2009-12-18T16:20:00.250

17

votes

5

answers

Why can't the VBA Me keyword access private procedures in its own module?

vba scope encapsulation

asked 2009-12-13T05:25:13.800

52

votes

7

answers

How to get the excel file name / path in VBA

excel vba

asked 2009-12-13T05:12:04.430

9

votes

1

answers

How do I reference to another (open or closed) workbook, and pull values back, in VBA? - Excel 2007

vba excel

asked 2009-11-26T04:52:17.673

79

votes

16

answers

How to extract file name from path?

string vba

asked 2009-11-16T16:39:21.080

89

votes

3

answers

How can I concatenate strings in VBA?

excel vba

asked 2009-11-13T07:31:24.123

87

votes

9

answers

How do I test if optional arguments are supplied or not?

vba function vb6 arguments optional-arguments

asked 2009-11-02T11:38:43.010

23

votes

7

answers

How to get the current datetime in UTC from an Excel VBA macro

datetime excel timezone vba

asked 2009-10-21T13:32:43.023

15

votes

2

answers

How can I find the index of the selected choice in a combobox?

excel vba combobox

asked 2009-10-20T10:11:17.620

12

votes

4

answers

Excel VBA - connect to sql with a trusted connection (no uid/pwd)

sql excel vba connection-string adodb

asked 2009-10-15T17:01:35.767

10

votes

5

answers

Is object clearing/array deallocation really necessary in VB6/VBA (Pros/Cons?)

vba vb6 static-analysis

asked 2009-10-06T13:58:35.127

13

votes

2

answers

VBA Shell and Wait with Exit Code

vba shell

asked 2009-09-17T14:20:01.217

13

votes

6

answers

Access sometimes jumps to existing record on save new record - Access2k FE/SQL2005 BE

sql database sql-server-2005 ms-access vba

asked 2009-09-15T05:14:07.807

94

votes

2

answers

Iterate over VBA Dictionaries?

excel vba

asked 2009-08-18T20:14:31.673

37

votes

5

answers

Export all MS Access SQL queries to text files

sql vba ms-access

asked 2009-08-14T00:56:28.387

35

votes

7

answers

Exit a while loop in VBS/VBA

vba vbscript

asked 2009-08-13T13:28:28.783

11

votes

3

answers

HTTPS POST request using VBA for Excel

excel vba post https

asked 2009-08-12T05:09:39.977

28

votes

6

answers

Accessing SQL Database in Excel-VBA

sql vba excel adodb

asked 2009-07-13T16:46:08.840

23

votes

3

answers

excel vba: Special Types - Functions as Arguments of Functions

function excel functional-programming arguments vba

asked 2009-07-13T08:48:53.370

13

votes

6

answers

How do I get the data from an SQL query in microsoft Access VBA?

sql ms-access vba

asked 2009-07-12T00:58:03.467

13

votes

11

answers

Convert Word doc or docx files into text files?

perl vba text-files docx doc

asked 2009-07-10T15:53:12.230

40

votes

5

answers

Show "Open File" Dialog

vba ms-access

asked 2009-07-07T10:12:54.597

12

votes

4

answers

How do I call WCF client from Excel 2003 VBA?

wcf web-services vba excel

asked 2009-06-18T15:37:26.313

13

votes

7

answers

Excel 2007 conditional formatting - how to get cell color?

excel excel-2007 vba

asked 2009-06-15T14:21:46.280

24

votes

7

answers

How to get a DateDiff-Value in milliseconds in VBA (Excel)?

vba excel datediff

asked 2009-06-02T12:24:44.217

17

votes

4

answers

How can I run SQL statements on a named range within an excel sheet?

sql vba excel

asked 2009-05-27T10:17:20.133

11

votes

7

answers

How to retrieve this computer's IP address?

vba excel msinet

asked 2009-05-06T07:53:27.140

27

votes

6

answers

Source control of Excel VBA code modules

vba excel

asked 2009-04-01T09:28:53.023

24

votes

3

answers

How to get logged-in user's name in Access vba?

ms-access vba

asked 2009-03-24T12:10:00.517

12

votes

4

answers

Open Excel file for reading with VBA without display

excel vba file-io

asked 2009-02-23T23:08:38.413

9

votes

3

answers

What is the best way to access a serial port from VBA?

vba serial-port powerpoint com-interface

asked 2009-02-20T14:19:13.407

14

votes

3

answers

Adding controls to a frame in an Excel userform with VBA

vba excel userform

asked 2009-02-19T04:39:39.157

10

votes

7

answers

Prevent moving to next record when hitting Enter?

vba ms-access

asked 2009-02-12T20:42:15.780

9

votes

6

answers

How to Reverse the Order of a Selected Range of Excel Columns using VBA

excel vba

asked 2009-02-08T00:22:24.150

83

votes

8

answers

Is there a need to set Objects to Nothing

vba vbscript vb6

asked 2009-02-05T17:47:44.697

48

votes

10

answers

Is there an equivalent to Thread.Sleep() in VBA

vba ms-access sleep

asked 2009-01-22T14:32:46.830

10

votes

7

answers

Programmatically set DLL search path in VBA macro

vba dll ms-word

asked 2009-01-16T11:47:44.753

30

votes

4

answers

Can a VBA function in Excel return a range?

vba excel

asked 2009-01-13T15:56:24.633

11

votes

7

answers

Want VBA in excel to read very large CSV and create output file of a small subset of the CSV

vba csv excel

asked 2009-01-09T09:20:54.207

44

votes

10

answers

Find the directory part (minus the filename) of a full path in access 97

vba ms-access excel ms-access-97

asked 2009-01-06T23:31:36.847

Questions tagged vba