Search results for query: *

I have an Excel spreadsheet application that uses VBA to link to various spreadsheets on several servers. It has a customized menu bar written in VBA as well. What I would like to do is browse to an ASP page on my website that will open this spreadsheet application within Internet Explorer...

## Creates a global temp table. We need a global temp table in this example because if it is not declared global, it will be in scope only while the EXEC statement runs. This means we won't be able to reference it later to do our update. Hope that helps.

I think tlbroadbent would probably know best as to what the correct way to do this one would be, but I would re-write it as: SET NOCOUNT ON DECLARE @y int DECLARE @x int DECLARE @temp varchar(50) DECLARE @strSQL varchar(8000) Set @y = 1 Set @x = 1 SET @strSQL = 'SELECT * INTO ##UPDATE ' SET...

2147217833 Err.Des: Arithmetic overflow error converting numeric to data type numeric. I receive the above error message when sending a data string to a stored procedure that is referenced from a COM object in my ASP page. If I test the same data by running it in VB with COM only it works...