vbscript/macro

Hi, I am trying to have all information in a given row (from columns A:F) automatically copied over to a separate worksheet if the checkbox is clicked. I have tried scouring the internet for about 3 hours with no luck, so now I’m here. Can anyone help out with this? I have attached a...

I've written a small VBS script to GET or POST an URL to a WinHTTP object and put its plain-text output to stdout -- any body text it needs should be send via stdin. Please note that it's a stand-alone VBS file, so there's no web involved whatsoever -- it's simply invoked with CSCRIPT...

Hi All, I am trying to write a script to create a pivot table for the entire data set on a tab. When I record it and run the macro on a table with a larger number of rows, the macro set the range to only include the number of rows that existed in the dataset when the pivot was recorded. Can...

Hi All, I have a table in excel where I am trying to write a script that inputs a column name into a cell, enters the formula for that column below, then drags the formula down to the last row of the tableau. This is the script I am using but, once it gets down to row 5, it starts to use the...

Hi, Could anyone please help me figure out what is wrong with below VBScripting and how do I correct it? It meant to 1) Open excel -- works 2) Refresh all data -- works 3) Remove external connection -- Dont work 4) Save as new file without any external connection -- Dont work due to 3rd step...

Is it possible to create a vbs file similar to the same one but that is automatically executed when a new file is inserted in the folder?

Hi all, i am currently trying to save my workbook at the end of my script into a one drive location. i have created a file so when it saves it also replaces. Currently it doesn't attempt to save. Please see my below code. (p.s i am very new to all of this)

I have a need to adjust a master excel file to accommodate a new process. I have a csv file that has data in A thru N with D thru K showing times in format h:mm:ss. This csv file is auto generated daily and will need to be imported into a master spreadsheet into a “data” tab keeping previously...

Hi, Can someone please provide me a VBScript code for my below requirement. I have a master tracking document that I use to record project information. My client sends me an updated schedule each week which may (or may not) have additional stores on it and some of the details of the stores may...