vbs

Hi All, I'm hoping to get some help in running a macro. My situation is this: I have a master spreadsheet with 13 different tabs. 3 of the tabs are "Today", "Yesterday", and "Statement." I run 2 reports each morning, "Today" and "Statement." First, I copy the info from "Today" from the...

Hi everyone ! I'm actually trying to make a game in Excel, coded in VBS (I know, this is crazy ), and I use the API "GetAsyncKeyState" in order to catch what keys are pressed : Public Const VK_UP = &H26 Public Const VK_DOWN = &H28 Public Const VK_LEFT = &H25 Public Const VK_RIGHT = &H27 Public...

How should I write a vba code that will find the first non-blank cell in a specified row range and then copy it to another sheet? Any suggestions?

My company recently switched vendors on thousands of parts and during the switch the database has not been able to copy the part numbers from one table to another. Now in Excel I have two spread sheets. One with the original vendor the other with the new vendor. The part number I need to...

I have written MANY xl macros using vba. They work well. I am trying to expand my horizons and create a vbs/vba file that will do everything a little more automated. My problem is that when I try to run the same vba code from within using my additional code listed here: Sub...

Hi, This code does what I want so far. It will open the Workbook I want, will make it visible, and will run the module that I've specified. The problem that I have, is that the WB is saved with Read Only Recommended on, so when I open the WB with the below VB script, it opens it as read...

wrote some code works fine in Excel, but from a .vbs file, it chokes. the offending line: lastRow = .Cells.SpecialCells(xlLastCell).Row the error: "Unable to get the SpecialCells property of the Range class" if i change that to: lastRow = 100 works fine, but obviously, loose the dynamism of...

Hello all: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I have a single excel 2007 workbook with eight worksheets and I wanted to find out if there was a way that I could automate that if data (text) were entered in a cell that this data (text) would...

I've got a VBScript file that I'm trying to get to populate an Excel spreadsheet with the file names dropped onto it. It works with a few files, but when I try to dump like 21 or more files on it I get an error saying it can't process that many arguments. Dim arg, cnt Set objExcel =...

I've got a VBS file that I'm using to populate an excel spreadsheet with file names. I select the files (.pdf's or .slddrw's of mechanical drawings) and drop them on the script, it iterates through the files and puts them into the spreadsheet with their folders. My problem is that I can only...