Forum Discussion
Importing Data into Outlook Calendar
- Given the fact that this is not your own code, and that particular reference appears to be unexplainable given what we can see, I might want to go to the source of the code and ask for clarification. I suspect that you are missing some important part of the full code. As I think I mentioned in a previous post, I would expect the WScript reference to pertain to a Windows scripting function anyway.
Hi George,
I do extra formatting and combining fields and preparing it for importing into Outlook. My data is initially in excel then I import into Access, manipulate it then re-export to excel then into Outlook. I use to be able to skip the re-export to excel by using the script.
I am not sure where that Wscript came from. It is only in the code I posted. I searched my access database and I do not see it anywhere else but in that function OutlookCalendarScript(). I thought maybe there is a reference or something that I need to update but I dont see any missing references either.
I think I will have to end up importing into Outlook manually. I have actually managed to do this and it works better than expected. its one more step but I can deal with it.
thank you for your assistance. Have a good weekend.
Actually, I wonder if this is new code to you? Did it ever work?
WScript.Arguments(0) strikes me as being something from a Windows Script, not in VBA. I made the mistake of thinking it was a variable you'd set yourself.
Hi George, hope you are enjoying the weekend.
Yes, it is a variable to set according to the Compile Error:
- It's also possible that Access "thinks" it is supposed to be a variable.
I should have asked about this earlier, too. Is this code you wrote yourself?- I did have Microsoft Script in the references already but it didnt change anything