18,620 questions
0
votes
0
answers
52
views
VBS OpenText keeps returning an error message [duplicate]
I have this VBS code:
Dim txtFilePath
txtFilePath = WScript.Arguments(0)
Dim excelApp
Set excelApp = CreateObject("Excel.Application")
Dim workbook
Set workbook = excelApp.Workbooks....
0
votes
1
answer
26
views
Is there a character limit to encoded commands for VBS? [duplicate]
First of all I am a noob in terms of VBS. So of this question does not make sense, please bear with me.
I have created a PowerShell script that I wanted to be launched via .vbs file.
I have ...
-1
votes
1
answer
87
views
If Statement for VBScript is not Working. No Errors when executing script [closed]
I am trying to create a script that reads the contents of a file and reacts to certain error messages. So far everything is working as intended; however, I cannot get the 'If' statement to perform any ...
-1
votes
1
answer
115
views
How to Vbs ignore error and run next excel row [duplicate]
I work with SAP and use VBScript to manage repetitive work.
(to change a warehouse code in a delivery order/position)
This script now has to pick a value from excel col1 and put it into the ...
0
votes
0
answers
82
views
Calling a MySQL parameterised stored procedure using VBS and ADODB returns unexpected random values in the OUT parameters [duplicate]
MySQL (v5.7.44). Classic ASP using VBS, ADODB.
Not a newbie, and hoping this is not because of developing bad habits over the years, but after 3 weeks of trying this and that, I'm hoping someone can ...
0
votes
0
answers
74
views
objFile.DateLastModified doesn't return the correct last write time
I have this VBS code:
Set objFile = objFSO.GetFile( strPandaAVDefinitionPath & "\NanoRepository.bin")
output.writeline "- The NanoRepository.bin file was last written to on: " ...
0
votes
1
answer
139
views
Is it possible programmatically add folders to the Windows 10/11 Quick Access panel in Explorer? [duplicate]
I want to use VBScript to programmatically add folders to the Windows 10/11 Quick Access toolbar in Explorer.
This works well in PowerShell:
$QuickAccess = New-Object -ComObject shell.application;
$...
0
votes
1
answer
89
views
How do I get aspPdf to write special characters like æ, ø and å?
I am using aspPdf to convert a html page into a pdf file. And it is working fine, except from the special characters æ, ø and å.
I have this:
<!--#include file="include/connectOpen.asp"--&...
0
votes
1
answer
39
views
How do I find the Task Manager Session Name using WMI
I am using the following VBScript code to run a TaskList to query Task Manager information
Set WshShell = CreateObject("WScript.Shell")
WshShell.Run "CMD /C TaskList /FI ""...
-2
votes
1
answer
75
views
Find the DLL of an object created in VBScript [duplicate]
I have been asked to rewrite a website that was written in VBScript
I am now writing it in C#
On the old VBScript code they are creating a graphing object from this line of code
Set Chart = Server....
0
votes
0
answers
46
views
WMI queries to the CIM_DataFile class and the case of file name?
The problem:
My test VBScript (Windows Platform) to obtain filenames return the name of file, all in lowercases!
I would like keep the real cases of the filenames.
Anyone cant help me?
The WMI script:
...
0
votes
1
answer
42
views
Unable to create a linked document via VBScript
I have this script to create a requirement and a linked document attached to that requirement. For the life of me, I cannot get the linked doc created on the requirement.
The code creates a single ...
1
vote
2
answers
175
views
Parameters in CATIA Script Export
I want to export parameters from Par to text file.
See the Tree here.
I wrote a script that should export all the values.
Sub CATMain()
' Declare variables
Dim CATIA
Dim partDocument
...
-3
votes
1
answer
42
views
800a0401 The file cannot be launched [duplicate]
I can't run the file cmd.exe /k "...", I get the error 800a0401!
I used the method set a = WScript.Createobject("WScript.Shell")
Error on line 3, character 14.
dim a
set a = ...
-2
votes
1
answer
72
views
Get path using FSO.GetAbsolutePathName displaying the result with a forward slash "/" [duplicate]
I have the following code in visual basic script that detects the path and replaces a word with the path
When the code is executed, the word will be replaced by the path. The result will be as follows:...