vbs

Hi, I've done quite a bit of research, and I haven't found anything. Is there anyway to write to a workbook that the current user already has open from a VB Script?

Hello! I have searched far and wide for the perfect Code. I am very new to the use of VBA and Macros but I dream big when designing spreadsheets. I have a sheet that has names going down the rows (A7:A257) with dates (month - year) going across the columns (E5:AN5). I would like to run a...

I have a spreadsheet that I'm trying to work out something I've never done before. I've researched and found that formulas won't cut it, I'll need to use VB (which I've never done) to make this work. In examples I've found the reference columns to move rows seems to be the first or last, and...

Hello All, I've been lurking through these forums in search of a result for my problem and could not find a complete solution. So I made an account to see if someone out there can help me out. I have a word document that I get regularly that contains hundreds of IP address along with text in...

Hi all, I'm trying to track changes from a shared document on a Sharepoint Repository. I am not the author, but could do it from the author's perspective if necessary. When I download it, is there a way to highlight the recently changed cells or indicate that they were the most recently updated...

HI there fellow Excel hackers. I have an interesting issue that i have run across while trying to write a script that do a replace and find of text in excel spreadsheets. I am writing my script in VBS because of the complexity of this script. This script is to do the following - search a...

So. We have a file and in that file is a list. and in that list are numbers that are conditionally formatted based on what the number is. And some of those numbers are underlined as the numbers that need to be pulled for counting. I need to total up how many are underlined based on what colour...

below is the macro i have but it is coming back with "Else without If" error I'm trying to create a macro that when a cell = USHMTrig then it takes the user to a certain cell on a particular sheet within the worksheet. Sub USHMTrigMac() If L8.Value = USHMTrig Then Do: Sheets("Example -...

I have a very strange problem with Excel. In Excel VBA I use ThisWorkBook to run some initial commands at start up for example: Private Sub Workbook_Open() With Application .ScreenUpdating = False .DisplayFormulaBar = False .DisplayStatusBar = False .ScreenUpdating =...

Hello, I keep getting this windows script host error. Script: C\top 5 macro.vbs Line: 5 Char: 1 Error: Unknown runtime error Code: 800A9C68 Source: Microsoft VBScript runtime error Dim xlApp Dim xlBook Set xlApp = CreateObject("Excel.Application") Set xlBook =...

I believe I have exhausted all the searches I could do on this subject and since I have not solved my first problem I hope I can post and get an answer for both of my issues... Background: I recieve a report from an old database in email as a message, I copy that message to word and save it as...

Hello at all I'm new in this Forum because I can not find a solution for my Excel problem in the Internet. I have a sheet with some Buttons assignt with Macros. The Button has the following function: copy a Special part of the Row, in which the Button is, to the next sheet. The problem is that I...

Good afternoon, My first post on the famous Mr.Excel.com. Hope I would post a question that has been answered thousands times. I need to create a .VBS document/script from an excel sheet. Is there any easy way to do a "save-as" and choose the .VBS extension ? Once the .VBS is created, I...

I want to copy data from detailed sheet to summary sheet. The C column data of detailed sheet (10.23 instead of 10:23.12 in first row by truncating) needs to be copied to B3 in summary sheet. We used to fetch the data for summary sheet from oracle database and paste the complete data in...

I want to gather a static range from excel sheet to go into the body of my email. But, This particular script works by walking down each cell of column 1 till it finds an empty cell which it assumes is the end of the list of entries. Function GetData() Dim x, strTemp, objExcel, objWB Set...

Hi, I was wondering if anyone can help me with a problem Im trying to solve. But not entirely sure if this is even possible So we use a bunch of equipment at work that spits out a pdf file that is going to consist the results of a particular test. Those files are named in a unique format. It...

dim aOutlook dim aEmail dim strRecipients dim automail_sub dim psg_level2 dim names_copy dim add_body_txt dim signature dim i dim rowcount dim path Set xlApp = CreateObject("Excel.Application") xlApp.Visible = False path = WScript.ScriptFullName path = Left(path, InstrRev(path, "\")) 'Open...

I have created a spreadsheet with different sheets, I was wanting to be able to click the button I have added and for it to search all pages in column E, then if the number in a cell in column E is above 0, I want it to copy the corresponding row into a section on the first sheet. If you click...

I need to copy from anohter workbook on my I:/ drive and paste into "Sheet 1". I have the cde below but get an "Object Required Error. Please help?? Thanks in advance :) Sub Macro2() 'Assign variable name to Target workbook Var1 = "ActiveWorkbook.Name" 'Assign variable name...

I am using Excel 2007 and with a .vbs file and I am trying to delete the first 11 rows of data in a CSV, then delete the very last row after the first 11 are deleted. After this the file should be saved in XLXS format which currently does work. Set objExcel =...