In this post, we will see how to resolve Calling VBA Sheet Function (with arguments) from VBS and getting its return value Question: I am trying to call a VBA function from VBS script: VBA VBS The macro (VBA function) ...
In this post, we will see how to resolve The object does not support the property or method EOF Question: I have 3 pages: my DB-class And my “functions”: And in my page: I get Error: The object does not ...
In this post, we will see how to resolve Read RZ11 parameter sapgui/user_scripting Question: I am trying to use SAP GUI Scripting to read “current value” set for parameter “sapgui/user_scripting” via t-code RZ11. I can connect to SAP instance, login ...
Question: Error starts at line 14 Maybe because the last line is incorrect? Explain what I want VBScript to do: I want this VBScript to find itself and then change to a different directory Best Answer: Use Option Explicit, for ...
Question: My question involves reading ASP files, but instead of rendering them in ASP or HTML. I need them to be in Text format when it displays the results to the screen. What I mean is that all of the ...
Question: I am using the RegExp Object to parse a common text field and turn it into a number. I have the pattern: (^[^0-9+-]+)|((?<=[+-])[^0-9]+)|((?<=[0-9])[^0-9.]+) which should turn an input like "37,080 lbs" into 37080. For some reason, when I attempt ...
Question: I have a vbs script that I have been using to add a file from a folder as an attachment to an email, and then send it automatically through Outlook. Which works great. The problem that I cannot figure ...
Question: I have a piece of VBScript that queries an MS Access database. When the recordset query is on a table, I can go through my recordset and do a rs.MoveFirst to go back to the beginning. But when the ...
Question: I wanted to run a batch file invisibly, without cmd.exe showing. The solution I found online was to make a .vbs file: It works but I can’t find the process in Task Manager for the life of me. I’d ...
Question: So my problem is that I can’t get the VBScript to work. I want to automate this macro using the VBScript written in this post, which should execute the VBA code below. The error message I receive is in ...