Hi everybody!
I have a question. I am trying to send e-mail using VBA. What I do is; open VBA go to tools-> references and check Microsoft outlook 15.0 Object Library, click ok.
I run the code, the code finalize the process(send a message). But when I redo again, excel uncheck Microsoft outlook 15.0 Object Library from vba.
Is any way to save the changes so I can avoid go to tools and check again and again Microsoft outlook 15.0 Object Library?
Reference is saved with workbook. If you save after adding the reference it should not become unchecked.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
in that workbook is checked but when I open a new workbook, it needs to check again.Originally Posted by Izandol
so this change is only in macro level. when I open a new workbook i have to redo
Yes, you must. Reference list is specific to each workbook.
You could always use late-binding, which wouldn't require a reference and should work across all versions that are being used.
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks