script

Please can someone help me 'tweak' this script that I am using to apply a macro to all tabs within a sheet - I would like the process to exclude 'Sheet1' from the process (so that 'Sheet1' remains as is- thank you for your help. Marc Sub Dosomething() Dim xSh As Worksheet...

Sub teste() Set SapGuiAuto = GetObject("SAPGUI") Set SAPApplication = SapGuiAuto.GetScriptingEngine Set SAPConnection = SAPApplication.Children(0) Set session = SAPConnection.Children(0) session.findById("wnd[0]").maximize...

Hello All, Greetings for the day! I'm having a VBA script which works absolutely fine when run manually. However when I tried to run it through windows Task Scheduler, few codes of this script not executing and hence not giving desired result. Any idea for this paradox? If required, I can post...

Hello all, I'm used to Macro program writing but I'm new to VBScript Script Files and I cant seem to find what can be wrong no matter where I look. I have a problem with running this vbs file, getting this error: Line: 7 Char: 1 Error: "Object required: 'application' Code: 800A01A8 Dim...

Hello everyone. Is is possible to make macro that can go down list of websites on excel file in Column A and determine if website has a blog and then in Column B script will write Yes or No ?

Good Morning All, As always, I must start out my posts with a big thank you to everyone who contributes to this forum. So I have a bunch of data in various columns with only one column I need to convert to categorical data. Column H is what I will need the script to focus on. I have a...

Good Afternoon, Absolutely impressed with the feedback on this forum - hoping I have the same luck again. I have a bit of an issue. I have a worksheet with columns A through AG. All of the data is similar but the column that needs the script to be focused on is column AE. Column AE has random...

How can I underline or highlight spelling errors as I am entering text data ? Can I do this without a script? If so please tell me how. If I need a script THANK YOU IN ADVANCE if you would kindly share it with me. Thanks

I have a script for my a combobox that is in a userform (GUI). The combo box uses a formula called "DropDownList" that I made to enable a particular type of autocomplete feature to my combo box. My program works as follows: After I start typing in the combo box and it narrows down my search, I...

WHAT I AM WANTING TO DO: I have a userform that I use for entry purposes. I have a second form that I use for editing the previous entries. The second form (editing form) largely mirrors the entry form, save for a few additional fields that are not present on the entry form. I recently...

So I have an issue in my excel file where I have a cell that is bound with a combo box. Every time the combo box selection is chosen, the linked cell will, of course, automatically contain the contents of the combo box. I then want my VBA script to automatically open an excel file on my desktop...

So I have an issue in my excel file where I have a cell that is bound with a combo box. Every time the combo box selection is chosen, the linked cell will, of course, automatically contain the contents of the combo box. I then want my VBA script to automatically open an excel file on my desktop...

Good Saturday to everyone! I have been trying to tweak this script for days, but I am no expert. This script automatically kicks in every time the main Excel file is closed. It should: 1 - Export a sheet called "Master" from the closing Excel file by creating a new one called Master(Progressive...

We have a spreadsheet on a common computer that many users input data on throughout the day. Occassionally, the spreadsheet will be left open (but not saved) at the end of the day. We have a script that moves todays file every evening into a completed folder and copies a blank file for use the...

Hello, I have been fiddling with this script for hours: Sub MakeInvoice_PDF() ' Make_PDF Macro from Invoice data in specific folder "\Invoicing\PDF Files\" With ActiveSheet.PageSetup .Orientation = xlPortrait .PrintArea = "$A$1:$G$56" End With ActiveSheet.ExportAsFixedFormat, _...

Hi folks, I'm looking for a VBA script that will copy & paste values & formatting to first empty row, The range I want to copy will contain values generated by formulas but I want to copy and paste them as values & not formulae, Also I would like to paste the data with formatting into the first...

I have a workbook that processes data and puts it into a usable format for people in my department. The workbook pulls data from about 12 other workbooks. Currently, my script points to a location on my hard drive. I'd like the file location to be a variable so...I can hand this workbook off...

This is a modified script from this forum and it serves it purpose well. But I the issue I am having now is that currently the script copies a bunch of values from a DIR and paste it in the main worksheet. But in this the DIR the tab names of the sheet varies so the code breaks when it...

Hello Friends, So this might be an easy solution and I usually have great success with this forum so thank you in advance! I have a data set in columns A-T. I need to sort on column F, same unique identifier through rows 2-128. Each row has different data after column I and I need to bring up...

Hi there, I have a script which interacts with excel and does some "stuff" - I now want to create a macro which will use this script and do some other "stuff" after it is completed. Can I create a module which will call this script to run? The script name is - missingprice_check_v4.sh and is...