multiple workbooks

Hi All, I have created a macro for Consolidating the data from multiple workbooks to one master workbook. I am actually beginner for VBA. But I have referred many books and gone through websites for learning and successfully coded the below. The below VBA code which I have created is by my...

Hi everyone, Here is my problem: Lets say I have 600+ separate excel files containing 3 tabs. The primary sheet is formatted as a form that has 100 questions on it. All the sheets follow identical formatting. The idea is to have some kind of tool/function/query/macro that allows me to answer...

I created a new workbook from an existing one that adds an extra 2 sheets which both reference some of the original sheets. all of the original macros are still used for the same operation and I've added a new module with a few new macros for my two new sheets. upon opening this workbook it...

Hello. I have only been working with macros/VBA for a week, so I know there are simple issues with my code, but I've turned it into spaghetti code trying to debug. I am trying to load data from multiple workbooks into a master and really need help please!! Dir for source files: C:\Test Dir\ Dir...

Being new to the VBA band wagon, i'm having some issues troubleshooting the code below. It is supposed to be able to choose multiple excel files in a folder and protect all of the worksheets within them as well as each workbook. The protect of the workbook does not have a password, it is simply...

Hi, I was hoping to create a pivot table from multiple worksheets that consist of multiple tabs. I am finding that I have too many elements within my data source to do this. Is there a solution other than making the world's largest master worksheet? Please advise. My elements are: Year...

Hi everyone! Hope you can help me with this as I found a code to create new workbooks but I cant's seem to bring it together. I have a workbook to create folders based on some data I paste into a group of rows. For each row it creates a folder. I got this to work quite well but now I also want...

The following Sub asks the user to select a generic template to open, then asks the user to select a source file (to populate the template). The source file is contains a number of worksheets and pivot tables. The sub then selects data from a pivot table and copies it into the template. I need...

I am looking to automate some updating that I do. I will try my best to explain. Book1: <tbody> Serial# Cycle Count Date Complete A4646366 525200 06/06/13 Done D2352352 235500 07/06/13 GC1223 667200 08/06/13 </tbody> Book2: <tbody> Serial # Life Cycle Count Last Updated...

Hi All! My problem is I cannot copy from a Form Control drop down box, and I need to do this for ~10 drop down boxes in about 200 xls files. The files follow a template so the drop down button Inputs are uniform. Here is some more detail: I’m building an Access Database so that our data...

Hi, I have 42 excel files with 2 tabs of multiple columns each. All layouts and column titles are the same. Every workbook was sent to me "shared", which has created several limitations. I can unshare a file when it is opened and get back full capabilities, but I don't know how to do this...

Hi, I have 42 excel files with 2 tabs of multiple columns each. All layouts and column tabs are the same. Every workbook arrived "shared", which has created limitations. I can unshare a file when it is opened and get back full capabilities, but I don't know how to do this when it is not...

Good Morning All! I have a good one that I am attempting to figure and then solve using VBA in Excel 2010. 11 WB's - 1 Master and 10 others which need to be updated. Master WB has 1 Sheet. Each of the other WB's contains multiple sheets. Each sheet in the WB's is laid out the same way...

I get requests from businesses around North America to have training on our products. Based on state, these training inquiries need to go to different sales reps. I was thinking, if I maintain these requests in one big workbook... is there a way to automatically link any requests for e.g...

First timer on the forums, so bare with me please :). I have several .txt files in one directory. I want to import each .txt file into an Excel template. Then save each as its own workbook. This template formats and has formulas to convert the .txt data to data I need. I also want to save the...

Hi there, I have a macro that generates multiple Excel sheets by looking at data on one sheet and then setting the values in a template accordingly (not copy/paste, but Worksheet1.Range(ABC123).value = Datasheet1.Range(XYZ789).value). The macro runs without issue across multiple PCs and...

Hi, I am new to this forum! I am trying to understand whether the following scenario is possible.. I use SharePoint at work to allow multiple users to view spreadsheets. Is it possible to have a workbook uploaded to SharePoint pull information from other workbooks uploaded to SharePoint? My...

I have a daily workbook that consists of three sheets. One of the sheets is a productivity log for that day. The workbook is saved via an existing script to create the names using a consistant format which is dd-mmmm-yyyy filename.xlms. At the end of every month, the data from these workbooks...

Hi Everyone Please can someone help me? I'm a complete novice with VBA but I really need a macro for work. I have a master spreadsheet eg: <table frame="VOID" rules="NONE" border="0" cellspacing="0" cols="3"> <colgroup><col width="86"><col width="86"><col...

Hello & thanks for help in advance. I have a program (say in wkb1) that uses vba to open another workbook (wkb2). When wkb2 opens it uses it's own vba to autofill some cells using data from wkb1. It all works wonderfully on the computer I made it on (Windows 7 office/excel 2010). However, it...