workbook

Hello I'm trying to figure out a way to open the workbooks using the array values stored. The only bug I encounter is at "Workbooks.Open(StoreList(0))" where I encounter "run-time error 0 subscript out of range" but the address is correct so I don't know why it can't find it? Sub uniquestores()...

Hi all, am a beginner at VBA and would like to seek help regarding working this out. Have tried looking at certain threads but I am unable to find something similar to what I want to perform. Currently, I have two separate workbooks as below: 'Customer Info' Workbook, 'Customer' sheet...

Hi guyz, Please excuse me if this question has already been asked multiple times. I am very bad with the VBA Scripting and would appreciate any and all help with my query here. So, what do I need help with? I have a folder in my C:\ Drive with the name "Acc". In this folder I have Multiple...

Lambdas are held in individual workbooks. How can we copy them between workbooks, and keep them up to date if they change? Based on the current Excel beta version 2111 * copying any sheet (even blank) from workbook A containing lambdas to another workbook B, will also copy those lambdas to B...

Hello There, I need some help to done my working. I have done some part of the coding. Can someone help me about it please.? I cant make continue. like I'm stucked. I have explained in the Main workbook what I want to do. Basically transfer datas from "data book" to "Main book". The problem is...

Hi - I've recently joined a company. We won't be able to implement any robust budgeting and planning tool so we are in excel. There is an extremely tight deadline and I'm just beginning to learn my predecessors excel financial models. from the existing files, I see 5 or 6 workbooks with about...

How to create folder in desktop with vba whenever the excel book is opened, if exist, ignore. Message if create new folder, silent if the folder exist. I have the code to create folder on desktop

Hi, I try to copy column from a workbook to another one(The first one is not open, but can be opened if needed, and the second one is where my macro would be). I get the path to my file from a function(Which return a String) bc the file is often updated(That part work with no problem). The...

I'm trying to take a master tab, 1. read column A, 2. create a tab in that workbook with the name found in column a, 3. then copy that one line from the master into the newly created tab. I have the code (below) that cycles thru column A and creates the tabs but having issue with copying the...

Hello I thought I would ask you good people a question on a workbook I'm developing for my place of employment. We have many SDS sheets for the many chemicals we have at the workplace. The company didn't have very good organization with the sheets which can be a safety and fire hazard because...

Need help if anyone can provide it. I'm trying to write a Macro where i can hide columns based on a cell value. The issue I'm having is trying to figure out how to construct it in a manner where I can have the macro work based on multiple cell values as well as work throughout the entire...

Hi Can someone help with below requirement with VBA code. I have got two sheets sheet1 and sheet2. sheet1 got data in A-X and sheet2 got a list in column B as below. Manager Max Harry Murat Vamsi Adam what i am looking for is code that loop through the above list and for each...

Hi folks, I was wondering if there's a way to get values (with a filter or find function) to show up in a workbook, by looking the values up from another workbook. the left photo (workbook 1) contains all the values and workbook 2 needs to show the values with offsets to the name and article...

I'm trying to create a button that, when clicked, saves the whole file to a defined location under a name that is a concatenation of 3 cells. Here's my code so far but i'm clearly doing something wrong Private Sub CommandButton1_Click() Dim strPath As String Dim strFolderPath As String...

Hi, I want to send someone a file, upon opening, an agreement check box appears that says, "Click Here to Start Your Preview". After say, 7 days, the workbook will lock and will not open again without a password entry. Once the password is entered, the file may be freely used, but, if the user...

Hi all, whit this code I would like to open another Excel Worbook (which is locked and shared) if not already opened and apply the filter on Worksheet named "1" to the cell A1 (cell A1 is a header, but it is not a table just a range). So basically after filter is done I want to see only numbers...

Hi everyone :), Is it possible to save my workbook on to the organizations network so that anyone may access it for viewing purposes only? But i want to be the only one who can go in and make changes. All help is greatly appreciated, I am going into excel right now with very little to no...

I need to vlookup with two workbooks and find the match values with highlight. Workbook A (Located in the folder path C:/Desktop/price match MFR date beg date end price XXX-ltd 8/1/20 8/1/20 100 YYY-ltd 9/1/20 9/1/20 200 GGG-ltd 10/1/20 10/1/20 300 MMM-ltd 11/1/20 11/1/20 400...

Hi, I have a workbook containing multiple sheets with same formatting in each tab. I am trying to take all the sheets and create a pivot table containing the data from each sheet. Is this possible to do? I am trying to avoid using a master tab because the information changes daily and the same...

Hi there I have an excel workbook and I can't insert any column in any worksheet. I will appreciate helping me on this. Here is the excel file .Excel file