Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
and here is the beginning of the Stored Procedure:
Dim strConn As String Dim conn As New Connection Dim cmd As New ADODB.Command Dim rs As New Recordset strConn = "DRIVER=SQL Server;SERVER=AV-W12-ROMS-1;DATABASE=RESUMES" conn.ConnectionString = strConn conn.Open cmd.ActiveConnection = conn cmd.CommandTimeout = 0 cmd.CommandType = adCmdStoredProc cmd.CommandText = "sp_list_updated_documents_within_x_days" cmd.Parameters("@number_of_days") = PromptNoDays.TextBoxDays.Text Set rs = cmd.Execute rs.MoveFirst ...
I can run this without a problem on my computer but it we get the "Item cannot be found in the collection corresponding to the requested name or ordinal" error when it runs on another user's computer when it hits this line in the VBA Code:
USE [RESUMES] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_list_updated_documents_within_x_days] -- Add the parameters for the stored procedure here @number_of_days nvarchar(1024) AS BEGIN ...
I'm using Excel 2013, the other user 2010. Any ideas on why it works for me but not on another computer?
cmd.Parameters("@number_of_days") = PromptNoDays.TextBoxDays.Text
|How to batch remove spreadsheet password||19||80|
|Concatenating multiple comments into one row||16||37|
|In Excel 2007 in data validation list, why does Excel perform a calculation when entering 2: 1 in the data validation list and how should I change this so no calculation is performed?||2||18|
|File size limit in SharePoint 2010||3||14|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!