vbs

  1. R

    Running a Macro

    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...
  2. P

    Disable Excel key-catcher

    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...
  3. Urner

    HELP: VBA to find first non-blank cell in the row?

    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?
  4. T

    Need VBS script to copy data and verify

    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...
  5. C

    Convert xl Macro to standalone VBS commands...

    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...
  6. S

    VBS open readonly recommended doc

    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...
  7. 6

    Unable to get the SpecialCells property

    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...
  8. D

    Data (text) to be copied and amended to another cell in a different worksheet

    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...
  9. R

    Drop Multiple Files on VBS to Pass to Excel

    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 =...
  10. R

    Drop Multiple Files/Folders to VBS File

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top