vba & macros

Hi there, I have a script which interacts with excel and does some "stuff" - I now want to create a macro which will use this script and do some other "stuff" after it is completed. Can I create a module which will call this script to run? The script name is - missingprice_check_v4.sh and is...

Good morning, I have a spreadsheet with 5 or more sheets and I am trying to create code that will loop through sheets and copy the same range from each sheet to the "Overall Summary" sheet. The range should be copied into the next blank row. Here is the code I have so far, please help. Thank...

I have never created a macro in excel, and last night I was trying to and I created an IfBold Macro by reading on this website, however it did not really do I really needed to do. I would really appreciate any help I can get. I am this General Ledger Activity report that I need to convert to a...

Hi, i want to merge data from all workbooks in a folder by using the VBA, i found the example on the https://www.rondebruin.nl/win/s3/win008.htm. It is very useful then i want to modify the code that suit my need but i do not know how to revise the code. Could anyone can tell me that how to...

Hi! So i am fairly new to Macro's but am also running into SO many errors so much that i basically need to scrap everything complex and start over.... can i get some help? I can adjust the actual rows and column numbers so i will keep it simple. Here is what i need to do: Press a Command...

Dear Experts, How we can set condition for text box of user form that accepts only numeric or alpha-bate values with character limitation like should accept only 10 characters. Let me know the coding. Thanks

When calling the following Sub I get an Invalid Qualifier Error near the bottom of the code "myEndRecordArray(i).Value = VLookupResult" Any thoughts? Sub PrintCountCounts() Dim myTableArray(1 To 6) As String Dim myEndRecordArray(1 To 6) As String Dim myPrintCountArray(1 To 6) As String Dim...

I have column A with 22 rows in sheet 1 but there are spaces between these accounts and 27 rows in column c in sheet 2 als with spaces between them. I need to copy and paste the range in column A to sheet 3 and when the copy paste ends it skips a cells and then pasted the data in column C under...

I am trying import data from 3 worksheets in a specified work book. My code works to delete the existing data in the destination wb. When I the code gets to the import commands it does not import. I have checked the file names and they match. When the resource actuals wb opens it is read only...

I am looking to construct a VBA that unhides specific rows across different sheets in a workbook. I can write separate VBA for each sheet/row combination, but was wondering if I can put them all together instead? 3 sheets need the same rows unhidden that I already have code for: Sub Test()...

Hello, I have a VBA problem that i need help with. Scenario: We constantly receive spreadsheets from third parties which we use to record various metrics. The problem is that these spreadsheets are supposed to have the same headings and format to fit our set template but do not. It takes time...

I would like to add a macro to my workbook that unhides columns across 3 worksheets when I click in A1 on any of those worksheets. Here is what I have thus far: Macro to Unhide columns across those sheets: Sub OpenColumnsSummary() Dim wsMySheet As Worksheet Application.ScreenUpdating =...

Hi, Currently I am into a project where I was stucked writing code for the below mentioned activity. I have created an userform with a multiselect Listbox and a Command Button ListBox populate the Items from a Table Source with 2 Columns. <tbody> Zone Region North N1 North N2 North...

Hello All, I am just beginning to explore Excel VBA, and have written minor macros but am in need of assistance. I have an Excel document with 6 worksheets, 3 which contain the word "Detail" as part of their names. I need to create a macro that will add the suffix "-Final" to the worksheets...

I need a script that will count all files ending in "_1" in all subfolder, then return that number to cell "H11" by pressing a key or by a certain time interval. It needs to select todays folder with this format 20190308-F3-kh, only paying attention to the 20190308 as the date. The "-F3-kh"...

The following cell provides a pop up message when NO is entered in cell H5. Private Sub Worksheet_Change(ByVal Target As Range) If Range("H5") = "No" Then MsgBox "If there is pink in a previously filled cell, after checking No." & vbCrLf & _ "There is Scheduling conflict." & vbCrLf & _ "Choose...

Hi Guys im after some code that can add a border to the end of the change in data but defined by a specific column. so in theory it would open a message box to determine the column to look down and at the end of each change in data insert a border. The border would be from A:N for example I've...

Hi, Wonder if someone can assist, a colleague of mine created a reporting suite where on a main tab we press a button to open a hidden tab and then when we click off it, it automatically closes it, its a great tool, but I need to add a new tab and a new button to open this. Unfortunately my...

Hi! I am currently stuck. I am attempting to create a loop that goes from the bottom of the range up in column F. If nothing is in the cell, move to the next row. If a cell in column F has content, moving the content from D, E, and F to the left. I was manually going into column C and delete...

Hi Community Members Is it possible to do a excel vba to automate the following? Initially, I was intending to record a mouse & keyboard movement macro, please advise :) Step1: Open a website URL and login using credentials (Username and Password) daily Step2: Navigate the website via a few...