"Compile Error: Method or data member not found"

[TOPSie]

Perhaps it is just paranoia, but....



I have an Access routine (Windows 10, Office 2016) which I have been running every month for several years.
The routine examines the contents of an Outlook mailbox and reads the contents of the mail items and copies the contents to an Excel spread sheet.
The relevant bit of the code is

Set appXL = CreateObject("Excel.Application")
Set wb = appXL.Workbooks.Add
Set ws = wb.Sheets("sheet1")
ws.Select
'DoCmd.Hourglass (True)
i = 1

For Each OutlookMail In TOPSFolder
 '@ Omitted @ 
                    ws.Cells(j, i) = TOPSLine

    Next
   i = i + 1
Next OutlookMail

wb.SaveAs "C:\xxxxx & ".xlsx"
wb.Close

This code has been working for years and I have not changed it recently.
So I was surprised when today I got "Compile Error: Method or data member not found" and the line
wb.SaveAs was iderntified as in error

If I tried to rewrite the line then neither Save nor SaveAs was offered in the intellisense pane??

As I had not changed anything my suspicions led to recent Windows updates.

I uninstalled KB5059379 and the routine worked again

So posting this as, perhaps, a warning to others.

:-)

[jojowhite]

it has no Intellisense since you did not Declare All your variables.

Dim appXL As Excel.Application
Dim wb As Excel.Workbook
Dim ws As Excel.Worksheet
Dim i As Long

[TOPSie]

[QUOTE=jojowhite;533692]it has no Intellisense since you did not Declare All your variables.

Maybe I used the wrong word. But after I had uninstalled the update SaveAs was offered as a valid Method - before uninstall it wasn't

[Micron]

it has no Intellisense since you did not Declare All your variables.

How do you know that when he only posted part of the code?

[jojowhite]

How do you know that when he only posted part of the code?

I know and I know you know as well that if you don't Declare, early bound an object, you don't get any intellisense.

[Welshgasman]

I know and I know you know as well that if you don't Declare, early bound an object, you don't get any intellisense.

I think Micron meant that the O/P did not show all of the code?
That always bugs me. You say you have not Dimmed the variables and then they come back with extra code to show they did.

Why they can't do that in the first place is beyond me.

[jojowhite]

I think Micron meant that the O/P did not show all of the code?
That always bugs me. You say you have not Dimmed the variables and then they come back with extra code to show they did.

Why they can't do that in the first place is beyond me.

the OP only shows the code, right, a Late bound object (using CreateObject).
so it is obvious he will not get any intellisense if he declared all variables as Object.

[Micron]

You're both right. I missed the late binding line because I skimmed over the code since most of it is missing.