Microsoft Excel Programming

R

combining sumproduct and average

RobcPettit
Jul 10, 2003

Replies: 2

Views: 2K

Jul 10, 2003

Robert Pettit

R

R

Roger
Jul 10, 2003

Replies: 1

Views: 1K

Jul 10, 2003

Tom Ogilvy

T

D

Importing from SQL changes date format

David Vardy
Jul 10, 2003

Replies: 1

Views: 740

Jul 10, 2003

Chris Nicholas

C

O

Oliver Chiu
Jul 10, 2003

Replies: 4

Views: 8K

Jul 10, 2003

Oliver Chiu

O

B

recalc question

Bura Tino
Jul 10, 2003

Replies: 2

Views: 905

Jul 10, 2003

Bura Tino

B

R

UpdateLink Method

Ray
Jul 10, 2003

Replies: 0

Views: 1K

Jul 10, 2003

Ray

R

D

Procedure Too Large problems

Doug Snow
Jul 10, 2003

Replies: 0

Views: 3K

Jul 10, 2003

Doug Snow

D

A

help with sql in excel

aneurin
Jul 10, 2003

Replies: 1

Views: 815

Jul 10, 2003

Tom Ogilvy

T

P

to modify cells from a function

Pierre Laporte
Jul 10, 2003

Replies: 1

Views: 735

Jul 10, 2003

Tom Ogilvy

T

N

File Copy Routine

Neil
Jul 10, 2003

Replies: 1

Views: 905

Jul 10, 2003

Tom Ogilvy

T

G

Compile error ...

Gary
Jul 10, 2003

Replies: 3

Views: 5K

Jul 10, 2003

Gary

G

J

Programming links

Joe Bannister
Jul 10, 2003

Replies: 1

Views: 771

Jul 10, 2003

jaf

J

P

A peculiar problem

Patrick Molloy
Jul 10, 2003

Replies: 1

Views: 729

Jul 10, 2003

Ignatius

I

P

Need Before_Save code

Phil Hageman
Jul 9, 2003

Replies: 13

Views: 987

Jul 10, 2003

Phil Hageman

P

D

Change font to red and bold

Derek
Jul 10, 2003

Replies: 1

Views: 1K

Jul 10, 2003

papou

P

E

eric lecocq
Jul 10, 2003

Replies: 1

Views: 862

Jul 10, 2003

Charles Williams

C

A

Modifying the cell dependies

Aaron Queenan
Jul 10, 2003

Replies: 1

Views: 1K

Jul 10, 2003

Charles Williams

C

W

Unknown where is the problem on the Runtime error - Automation error

wellie
Jul 10, 2003

Replies: 1

Views: 3K

Jul 10, 2003

Patrick Molloy

P

J

Protecting a worksheet from veiwing but not from importing in data

Jimmy Ho
Jul 10, 2003

Replies: 2

Views: 786

Jul 10, 2003

Harlan Grove

H

E

Can these codes be summarized?

Edmund Seet
Jul 10, 2003

Replies: 1

Views: 999

Jul 10, 2003

Patrick Molloy

P

C

Writing multilines to a text file without closing

ccdubs
Jul 10, 2003

Replies: 1

Views: 943

Jul 10, 2003

Patrick Molloy

P

B

How to get data from Access Database in Intranet

Bill Li
Jul 10, 2003

Replies: 1

Views: 1K

Jul 10, 2003

Matthew Connor

M

N

Removing Lines Identified by Autofilter

Neil
Jul 9, 2003

Replies: 2

Views: 962

Jul 10, 2003

Dave Peterson

D

C

check if worksheet exists

Craig Wilks
Jul 9, 2003

Replies: 2

Views: 6K

Jul 10, 2003

Robin Hammond

R

J

adding uniform footers

Jamie Martin
Jul 9, 2003

Replies: 1

Views: 853

Jul 10, 2003

Robin Hammond

R

T

Re : MS Excel’s Offset Property

TKT-Tang
Jul 9, 2003

Replies: 2

Views: 5K

Jul 10, 2003

Dave Peterson

D

J

m/d/yyyy h:mm date conversion to yyyymmdd ???

Jeff
Jul 9, 2003

Replies: 2

Views: 1K

Jul 10, 2003

Ron Rosenfeld

R

J

date conversion from m/d/yyyy to yyyymmdd

jeff
Jul 8, 2003

Replies: 3

Views: 3K

Jul 10, 2003

Dave Peterson

D

D

Simulating the Format Painter, Selection.Select, and taking focus

David McRitchie
Jul 8, 2003

Replies: 3

Views: 1K

Jul 10, 2003

Dave Peterson

D

C

help with *.xlw file please!

causemaker
Jul 9, 2003

Replies: 3

Views: 5K

Jul 10, 2003

Tom Ogilvy

T

K

Reading a named range

Karl Thompson
Jul 9, 2003

Replies: 1

Views: 802

Jul 10, 2003

Karl Thompson

K

J

Can this be done?

John Viall
Jul 10, 2003

Replies: 1

Views: 809

Jul 10, 2003

John Viall

J

M

output of associated arrays

Michael J. Malinsky
Jul 9, 2003

Replies: 3

Views: 927

Jul 10, 2003

Chong Moua

C

V

ADO connection not always enabled

Vaughan B
Jul 9, 2003

Replies: 1

Views: 1K

Jul 10, 2003

Bill

B

J

Calling the Solver via a subroutine

James
Jul 9, 2003

Replies: 1

Views: 4K

Jul 10, 2003

Rob Bovey

R

R

Chart automation problems!

Rob Pollard
Jul 9, 2003

Replies: 1

Views: 980

Jul 10, 2003

Tim Otero

T

M

variables for file names

mike
Jul 9, 2003

Replies: 1

Views: 781

Jul 9, 2003

Henry

H

P

moving macros to disc.

Postma
Jul 9, 2003

Replies: 1

Views: 768

Jul 9, 2003

Henry

H

P

Parsing Data From HTML Source into Excel using VBA

Peter Dickson
Jul 9, 2003

Replies: 1

Views: 20K

Jul 9, 2003

Lynn Schauer

L

R

Pausing code execution

Rohit Thomas
Jul 9, 2003

Replies: 1

Views: 895

Jul 9, 2003

John Wilson

J

A

Andrew Park
Jul 9, 2003

Replies: 2

Views: 948

Jul 9, 2003

John Wilson

J

P

scan for repeating values and then delete

peach255 C
Jul 9, 2003

Replies: 2

Views: 2K

Jul 9, 2003

Chong Moua

C

M

list of accounts

Mark Jeffcoat
Jul 9, 2003

Replies: 1

Views: 770

Jul 9, 2003

Trevor Shuttleworth

T

J

Joe
Jul 9, 2003

Replies: 4

Views: 1K

Jul 9, 2003

Chong Moua

C

G

Defining Ranges

Greg Ghavalas
Jul 9, 2003

Replies: 2

Views: 1K

Jul 9, 2003

Greg Ghavalas

G

A

Fill Color? Background Color?

andy
Jul 9, 2003

Replies: 1

Views: 1K

Jul 9, 2003

Mark Bigelow

M

J

ugh! Match/Index problem

Jeremy Gollehon
Jul 8, 2003

Replies: 5

Views: 1K

Jul 9, 2003

Jeremy Gollehon

J

K

JScript to move Excel Worksheet

Kenneth Chin
Jul 9, 2003

Replies: 1

Views: 1K

Jul 9, 2003

Chong Moua

C

P

Calling HTML Source code from within VBA for Excel

Peter Dickson
Jul 9, 2003

Replies: 0

Views: 1K

Jul 9, 2003

Peter Dickson

P

M

formula returns formula

Mark Jeffcoat
Jul 9, 2003

Replies: 1

Views: 859

Jul 9, 2003

Tim Otero

T