G
Ginger
I had a procedure in ACCESS that I coded to put certain
fields into an EXCEL spreadsheet on Friday. It was working.
I went into it today, and it will not recognize the
spreadsheet. I checked the references and they were fine.
What I have is basically this:
wb = Excel.workbook
ws = wb.worksheet
recordset = sql
sql
for each record I do the following
ws.(n,1) = name
ws.(n,2) = address
email it out in EXCEL format
next
Loop
The problem is that it is not recognizing the ws.(n,1). It
says worksheet = nothing.
Any suggestions are welcome!
Also, how would I do the same with an EXCEL template?
Thank you in advance!
Ginger
fields into an EXCEL spreadsheet on Friday. It was working.
I went into it today, and it will not recognize the
spreadsheet. I checked the references and they were fine.
What I have is basically this:
wb = Excel.workbook
ws = wb.worksheet
recordset = sql
sql
for each record I do the following
ws.(n,1) = name
ws.(n,2) = address
email it out in EXCEL format
next
Loop
The problem is that it is not recognizing the ws.(n,1). It
says worksheet = nothing.
Any suggestions are welcome!
Also, how would I do the same with an EXCEL template?
Thank you in advance!
Ginger