Questions tagged as 'vbscript'

Tagged questions
0
answers

Paste filtered data from multiple worksheets into a VBA

My goal is to get data from 4 spreadsheets and paste them into one another, and then update multiple spreadsheets with that data. The code I'm using is as follows: My goal is to get data from 4 spreadsheets and paste them into one another, an...
asked by 18.06.2018 / 18:24
0
answers

Get the selected value in the combobox with Classic ASP

I have two tables in SQL: A group that has two columns: id and group A product that has three columns: id, group, and product In the Products table, the "group" column is equivalent to the "id" column of the groups table. I'm try...
asked by 19.06.2018 / 18:34
1
answer

From x-www-form-urlencoded to json

Hello! I have been the "jr programmer." in maintaining a virtual store, making changes and improvements to the site through Classic ASP hosted on Windows server, with IIS. Context : The virtual store uses a "payment gateway" that bridges t...
asked by 23.04.2018 / 16:30
0
answers

The SaveAs method of the Workbook class failed

Const xlShiftDown = -4121 'Arquivo de entrada strInput = WScript.Arguments(0) 'Arquivo excel strOutput = WScript.Arguments(1) 'Arquivo excel strFormato = WScript.Arguments(2) Set objExcel = CreateObject("Excel.Application") objExcel.Disp...
asked by 16.02.2018 / 15:23
0
answers

Generate VBscript log

I have the following code. ' Ajuste o número de psts a serem feitos backup. *Obs.: comece por 0* ' ReDim pst(0) ' Defina o local referente a cada arquivo a ser feito backup ' pst(0) = "C:\Users\teste-pc-1\Documents\Arquivos do Outlook\backu...
asked by 28.11.2017 / 14:39
0
answers

Error trying to open an Excel file

I'm trying to open a document in excel via vbScript. I am not succeeding at execution, running is generated the following error, without description:    -2147417851 The problem occurs when you run the following command: Set objExcel = C...
asked by 11.10.2017 / 15:06
2
answers

SQL - query for True or False records

I'm putting together a simple page that shows records marked as blocked by admin. The field is user-block and the options are FALSE or TRUE. I imagined that Query would be: "Select * from Usuarios WHERE user-block = "&TRUE&" order b...
asked by 27.08.2017 / 02:11