VBA code missing in .xlsm workbook

Question

I built a workbook last year that on the first call of the day goes out and extracts data from several web sites and,processes the data before placing it in cells in various sheets in this workbook.  It has worked fine all this time. 

I need to add a log of the data updated and opened the Design menu but when I view the code the project, sheets and modules are listed but no code.  I do not use a common macro file for this project.

Anay suggestions on where to look next would be appreciated.

Answer 1

I've seen some code get removed by anti-virus programs with no warning, if the code appears to do something malicious like download files from the web. Maybe you have a backup or an earlier version?

Answer 2

Maybe: You are using Data Queries instead of macro code, and just forgot how you had set up the workbook.

Thanks but that's not it.  I had to parse out the web sites to find the correct data.

Answer 3

Maybe: You are using Data Queries instead of macro code, and just forgot how you had set up the workbook.