How to record a sheet change showing row column sheet name and date?

[Simon Lloyd]

Still struggling with this one, i keep getting variable not defined o
oWBAudit. If i do get this to run at all i get the error 424 an
oWBAudit = empty and Nothing=Nothing.

I have put the code in the this workbook module with the initia
statement If oWBaudit Is Nothing Then
Set oWBaudit = Workbooks.Open(FileName:="C:\Audit\Tracking.xls")
End If

at the top and the rest at the bottom of the code, any ideas?

Simo

 

[keepITcool]

if you

dim oWBAudit
(will set it as a variant)

to test if a variant is initialized you check
if myVariant = Empty or if IsEmpty(MyVariant)

dim oWBAudit as object
dim oWBAudit as workbook
(will dim it as a "general" object resp a workbook object

to test is an object is initialized you check
if myObject IS nothing

also note the distinction between "=" and "IS"
IS is used to compare objects.






keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >