hello experts;
I know this might not be the right forum but i was just wondering if any of the experts here have encountered the following challenge below.
I am trying to create a simple vba script that calls a function in excel once the excel is opened. see code below.
Dim rs As Object, com As Object, cn As Object
Set cn = CreateObject("ADODB.Connection")
cn.Open "Provider=OraOLEDB.Oracle.1;Password=xxxx;Persist Security Info=True;User ID=xxxxx;Data Source=prdncms"
Set com = CreateObject("ADODB.Command")
Set com.ActiveConnection = cn
com.CommandText = "UserProfileMaintenance_pkg.prRemoveUser('koti')"
com.CommandType = adCmdStoredProcedure
Set rs = com.Execute
I am getting a error that says tns could not resolve the connect identifier specified.
Thank you