Manipulating Excel data in VBA code
I need to perform a task that I'm having a little trouble with. I need to
write a VBA code module that will open an Excel Spreadsheet, fill in a couple
of known cells with information, and then email the spreadsheet to a (known)
email address from Access. I have some code that does something similar with
a Word document but I seem to be getting confused about which methods to use
in Excel. Does anyone have an example that might work here?
Thanks in advance,
--
Glenn
|