vbs

Guys im having trouble getting the value from an SAP field into my excel Column. I need to get the following value to copy into cell C5. I cant get SAP To copy the value or insert it into cell c5. all help appreciated. Set sapguiauto = GetObject("SAPGUI") Set app =...

We are trying to write a script that opens Internet Explorer into a webpage that acts like a DOS screen. We then need to begin typing into said webpage. Below is the beginning code we have managed to make but it does not make the IE screen the current active screen to begin typing into and we...

How do I ensure macro only can be executed upon the Book2 is open? The VBS code below will help to auto open the file upon data extraction but it will be delay a bit to open hence resulted error at 100. On Error function seems doesnt work. Im thinking is there any loop function to wait until the...

Gentlemen, I am running this code via task scheduler, and the workbook is closed when it runs. At the end of the process, it gives me the following error; however, all the expected processes are perfect. I have also run the macro manually, and it works as expected. I suspect the VBS code has...

Hey guys, I've worked hard to build a spreadsheet for ordering print job. It calculates cost, allows a file to be attached, and emails to our shop however, once it sends the email it reboots excel. Not sure why it does it but it always does. This is my VBS code that is attached to a button. It...

A simple explanation of what I am trying to accomplish is this: We have a .csv file that has a bit of post processing done on it. We take these 2 files and put them in 2 separate sheets within the same workbook in excel (done through VBScript). I then create a 3rd sheet and my goal is to...

Hey Everyone! I'm new to the group and looking for some help on coming up with a VBS script that can check a users Excel version and perform an action depending on the version. We have 100s of users and it's either going to be Excel 2010 (14) or Excel 2013 (15). I've got the action part of...

Hey gang, So I've noticed that I am evidently doing something incorrectly when I am invoking a particular bit of VBA code within a source.XLSM file. Here's my program file flow. script.BAT calls script.VBS which calls "ProcessCVS" subroutine within script.XLSM. Here are the pertinent...

HELLO, Looking for some help! I am attempting to set up an excell spread sheet to calculate my team members work loads. I am runniing into some issues. what i need to do is if a cell is given a value of an interger to return the full load value and if it is a "S" (shared value, 50% of the full...

:) Hello everyone! I need another dose of Mr. Excel brilliance. I am trying to develop a subroutine that will autofilter, copy, and paste columns of data from one worksheet to another. Below is an example of a table (sht: "Master Daily Sched") I want to autofilter with the string...

I am having a bit of trouble with a search function that I'm trying to implement in a Excel spreadsheet. I followed a tutorial online and adapted it to work for my uses. Unfortunately, it only can search and filter columns A - E. I updated the data range to include my whole sheet (A6:S100), but...

Hello everyone! I seeking guidance on how to create a keyboard activated macro for a userform navigation worksheet listbox. I want to be able to access the userform anywhere in the workbook with the Control + M keyboard command. I have created the Userform listbox and dynamic range name...

Hello everyone! I am trying to learn something new and need guidance. Please offer suggestions on how I can improve the VBS script listed: Sub SATFILTER() ' SATFILTER Macro ' Filters Master Daily Schedule Worksheet for Employees Assigned to Work Saturday by the AutoFilter Field:=1 "NS"...

Hi there, I am trying to use VBA to clear the contents of column B of the same row(s) as the cells selected. I just can't quite figure out how to get it right. If D5 was selected then B5 would be cleared. If F7:G8 was selected then B7:B8 would be cleared. Thanks, Andrew

I am trying to make a sub that when run (a button is clicked) it adds one to the value of a particular row based on what time it is. for example, my sheet has an hour in 8 rows column B (based on what shift is using the program the times will differ) When the button is hit It needs to add 1 to...

Hello all, I feel like this is a really dumb thing to ask, but I am having some trouble putting a cell reference in my menu caption in VBA: With ContextMenu.Controls.Add(Type:=msoControlButton, before:=7) .OnAction = "'" & ThisWorkbook.Name & "'!" & "RTO_MATERNITY"...

Hi all, So this is something I've never seen before. I have a number of macros in a workbook that automate the refreshing of ODBC connections and Pivot Tables. There are multiple ThisWorkbook.Save events throughout to track and save the process of the macros. This works great when I run it...

Trying to figure out how to do this via VBS. First, check if the workbook is open, and if so, run the macro in it. I found this, but this opens a readonly version in the background and runs it, which is no good for my purposes Option Explicit Dim xlApp, xlBook Set xlApp =...

Oh Great & Powerful Mr Excel Gurus, please bestow your knowledge upon me, a humble desk jockey! :laugh: I have been tasked with creating a macro that will autopopulate a column in excel based on the values of two other columns (a store number (first column in example) and a date (second column...

Hi all, I know my way around Excels FORMULAS tab well enough but I am just starting to practice my VBS (it's like a foreign language that I can kind of tell what it says if it's written out, but no clue how to start from scratch!). Below is a macro I've used to update the date on a worksheet and...