vbscript

  1. D

    Excel vbs code for dynamic range referencing

    :) Greetings everyone! The following VBS script has fixed defined ranges. I need the ranges to dynamically change as new rows are added to the worksheets. Sub SATFILTER() ' SATFILTER Macro ' Filters Master Daily Schedule Worksheet for Employees Assigned to Work Saturday. Dim SATFILTER$ Dim...
  2. U

    Help with scheduling

    I have an excel macro named HAHAHA.xlsm and it has a sub named random_info() I want to schedule this macro / sub so that it runs daily at 00:00:00 hours GMT It should run even if Excel is not open at all. I don't know how to do this. I guess I need to use VBScript but am not aware of the...
  3. P

    Compare two xls file and copy matched data in to new row in second sheet

    Hi all, I have a requirement where I have to read two different xls files and compare the data in case found any match I have to populate the matched data on the next column in the second sheet. sheet 1 (xls1) ------------------------ |Text | Replacement | ------------------------ | field1|...
  4. B

    SpecialCells VBscript to get all Formulas fails w/Unable to get the specialCells property of the Range Class

    Trying to put a vbScript together that will go through an Excel Sheet and return all the Forumlas Found in the activeSheet. I am attempting to use SpecialCells to return the data. However, I get an error "Unable to get the SpecialCells property of the Range Class". Am I missing something to...
  5. C

    Starting a Bloomberg excelsheet via VBScript

    Hello, first of all I'm a rookie in programming with Visual Basic. My purpose is to programme the following tool: It should open a particular Excel-workbook (WB1) at 12 o'clock, copy values of a few cells and write them into a further workbook (WB2) with current time and date. Then it should...
  6. R

    VBScript to open a password protected file in order to edit links.

    I have a working program but want to add a password to the external file I'm using to update my active spreadsheet file. I do not want to be prompted for the password when I initiate the "update" command from within code. I would like to automatically pass the password through scripting. Here is...
  7. Technowolf

    VBS to run macro on already open .xlsm (if it's open)

    Trying to figure out how to do this via VBS. First, check if the workbook is open, and if so, run the macro in it. I found this, but this opens a readonly version in the background and runs it, which is no good for my purposes Option Explicit Dim xlApp, xlBook Set xlApp =...
  8. D

    Macro for Essbase data retrieval

    Hi, I am ultimately trying to automate/schedule a data retrieval from Essbase. I started with a macro that works perfectly. Sample code: Sheets("Sheet1").Select range("B1:b1").Select ActiveCell = j application.Run macro:="EssMenuVRetrieve" This macro will run in about 0.5 seconds and...
  9. M

    Exporttofile now prompting for Printer setup

    To all, a search did not turn up an answer for this, so I am hoping someone can shed some light on the problem. I am using the code below to export a workbook to a PDF file: ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=PDFFile, Quality:=xlQualityStandard, _...
  10. A

    VB script does not work when run from windows task scheduler.

    I have a vbscript. The vbscript works perfectly when i use microsoft windows based script host to run it. I used windows task scheduler to run the vbscript, but the script does not run. The following screenshot appears.
  11. D

    Create a input macro in the next available cell

    Hi there, I want to create a macro, that inputs a string into the next available cell, in a defined row. So when the next available cell is found, a inputbox appears, the user types in the data, and then the data goes into the active cell. I currently have this: Sub Find_Blank_Row() Dim...
  12. N

    VBScript For Loop folder variable not working, Trying to move, rename, and delete based on file/folder names

    Hi all, I am new to vbscript, but I have some experience with vba. I am trying to move, rename, and delete files based on their names and where they are stored in the folder structure. But when I run the script I get an error "Invalid 'for' loop control variable" that takes place at the start...
  13. S

    VB Script help needed

    Need help with vb script to do the following Copy & Paste special (values) from Sheet “A3”.Range(B6:E8) AND Copy & Paste special (values) from Sheet “Timeline”.Cell(F6) TO Sheet “Change Log” WHEN Sheet “A3”.Cell(M3=”YES”)
  14. K

    vbscript to move data to new worksheet

    Hi I want to transform some data into a table on a new sheet but to me it seems complicated so I am not sure if it is possible. Below is the source data format <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody> 01/01/2014...
  15. S

    How can I download attachment from lotus notes?

    I have a program which download lotus attachment to a path in computer. It does not download the file when the file is already downloaded. But if we delete the file from path, it downloads it again. I have a workaround, that we can mark the file as read when downloaded, but don't know how to...
  16. S

    vb script to go back to last sheet viewed

    I am looking for a script that will take users back to the last sheet viewed/edited after a "delete macro runs" (not the last sheet in the workbook - previous sheet viewed/edited) Below is script that I have that deletes the records on the "Returns" sheet Sub Macro2()...
  17. R

    Trouble automating a macro

    Hey everybody....first of all, even though this is my first post here, I have been using these forums as a tremendous resource to help develop some pretty awesome macros that have saved myself and my company an incredible amount of time, so thank you to those who contribute here. On to my...
  18. J

    Generate .VBS script with a .VBA code

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

    Need help to append data in existing cells(rows) of single column and suffix numbers in increasing order

    Hi All, Please help me to create a VB script(in excel 2010) for the below scenario: Consider column A and there are 100 rows in that column with some existing data in each cell. e.g. A1, A2, A3,... = apple, bat, cat,.. Now what I need is a script that would do this: TC1_apple, TC2_bat...
  20. L

    VBScipt ExecuteExcel4Macro PAGE.SETUP Font, Style not working

    Hello All, I am currently using Excel 2007 on Windows 7. It should be noted that I am developing this script to run on multiple versions of Excel (2003,2007,2010) as well as multiple versions of Windows (XP,7 and possibly 8) I really need someone's help with a "Working" example of an...

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