script

  1. Z

    Font ? =+ not returning it in script

    I am pulling into cell A52 =+j12 from cell J12 thats arial font but in A52 i have the cell to script , but its now returning it in script.
  2. B

    Best Java Script Help Forum

    Does anyone know of a good Java Script forum thats as good as Mr.Excel? Ive got to start learning how to add some script to some pdfs and need help.
  3. R

    Unable to paste cell value in input box while triggering VBA script

    Hi All,:) I'm having a vba script wherein a pdf is being generated by providing account number through input box. I'm coping a cell value (account number), triggering the vba script through keyboard shortcut, a input box appear and now I'm supposed to paste that copied cell value into input...
  4. E

    Text manipulation in PowerShell

    Hello I am looking for a free and fast way to manipulate large amounts of data (GigaBytes). I think Powershell is the most appropriate as it comes with Windows and it is fast. Do you have any other alternatives? As for Powershell, can you help me please with a script that will read the lines...
  5. Z

    VBA - PowerShell stdOut and waitOnReturn Required

    I'm not the best at this, but it appears there are (at least) two ways to call a PowerShell script from vba one is to use .Run and the other is to use .Exec RUN let's you add a parameter called waitOnReturn EXEC let's you read the output of the script via .StdOut.ReadAll But I need to do both...
  6. V

    Detect if worksheet exist, and if it does ignore the rest of the script

    I need my script to detect if worksheet(s) exist based on some critera and if 1 or more does, ignore the entire script. I want to add this part at the start of a current script I'm using. If any sheets already exist, it is causing me trouble... Of course this might not be the ideal way to...
  7. V

    Rename part of multiple sheets if it meets my critera

    I already have a script that does most of the mumbo jumbo of what I need, however at the very end of that script, I want to add the part to rename part of some of my sheets to something else I have multiple template sheets and a master sheet within a workbook, those need to remain untouched...
  8. T

    Object Variable or With block variable not set error

    Hello, Using stream.WhiteLine in a VBA script is giving me the Object variable or With block variable not set error msgbox. Clicking on the Debug button brings me to the line that is written stream.WriteLine " " This is happening at the end of the script. But, I've used the stream.WriteLine...
  9. V

    Print specific sheets seperately to printer and PDF

    Is this doable and could someone suggest a script? (Script would need to be seperate) 1. Print sheets seperately without prompt to the default printer: only if the sheet contains the text: "PrixMax" "6po" "Quote" (Then print them, else ignore) 2. Create a PDF per sheet (If sheet contains the...
  10. R

    Office 365 Excel 1902 Version Error 1004

    Hi guys! long time no post! I was asked to do something at work that I havn't done in a while, but luckily I saved the VBA script, its a script that matched different workbook sheet store numbers and exports them to their corresponding network folders, luckily most of the script still works...
  11. V

    In need a VBA script to create sheets from 3 different template sheets and more...

    Hello all, first time here! I'm not proeficient much with VBA, hopefully someone can help me. I need a VBA script to create a dynamic amount of sheets at once based on 12 different cells value, from 3 different template sheets (I need to keep those 3 templates formula intact) and based on some...
  12. B

    cut/paste scripting - copy a range then paste to a destination range that matches to row/column address criteria - INDEX/MATCH but cut n paste

    I'm struggling with some simple copy/paste scripting in Excel/Sheets. I'm a complete scripting newbie. Advanced at Excel/Sheets. I have a "Today" data entry sheet. I have a "Program" sheet that stores data in a column under a Date header. I want a macro/script that will: cut data from an...
  13. M

    Convert EUR to GBP VBA Script

    Hi, Im trying to create a script to change all the values on the press of a button from GBP to EUR and back if the button is presed again, can anyone help. I search online and the forum but not joy. Many thanks
  14. F

    Google Sheets - Script Dates

    Hi All I am having a problem with making a script. I am making a script that will delete a row a week after something has been approved. As of right now i have this which when a dropdown is selected as "YES", another cell gets the current date entered: function onEdit() { var ss =...
  15. O

    VBA to create new tab on base on an identifier

    I am hoping one of you VBA gurus can help me with a script to separate rows of data into multiple sheets in a workbook. The data is in 5 columns over 1000s of rows for many customers. I cannot export the data any other way. Column A has: 0 (zero) - Header row to show the change from one...
  16. I

    How to print worksheets from a different work book?

    Private sub command button1_click() If Range("J15").value=4 then Workbooks("c:\ tournament\bad beat\ receipt file.xlsm").worksheets(array("1","2","3","4")).printout Else End if End sub Says script out of range
  17. M

    How to change vb script to use active row

    Hi I've got a macro that searches column A for a specific text then moves across to column D to copy the data in the cell. The vb script looks like this: Range("D22").Select However, the search might not always find the specific text in row 22 but will always copy the data from column D. Is...
  18. M

    Script for applying a macro for all tabs in a sheet

    Please can someone help me 'tweak' this script that I am using to apply a macro to all tabs within a sheet - I would like the process to exclude 'Sheet1' from the process (so that 'Sheet1' remains as is- thank you for your help. Marc Sub Dosomething() Dim xSh As Worksheet...
  19. R

    VBA to check for PR SAP attachment

    Sub teste() Set SapGuiAuto = GetObject("SAPGUI") Set SAPApplication = SapGuiAuto.GetScriptingEngine Set SAPConnection = SAPApplication.Children(0) Set session = SAPConnection.Children(0) session.findById("wnd[0]").maximize...
  20. R

    VBA code not running through Task Scheduler

    Hello All, Greetings for the day! I'm having a VBA script which works absolutely fine when run manually. However when I tried to run it through windows Task Scheduler, few codes of this script not executing and hence not giving desired result. Any idea for this paradox? If required, I can post...

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top