workbooks

I have two workbooks identically named- one is the master and one a working copy. If I open both, the second one opening kicks an 9- out of script error. What causes this? Function PrevSheet(RCell As Range) 'Begins Error Handling Code On Error GoTo Helper Dim xIndex As Long...

Hi all, I have a userform that opens automatically and hides the workbook when I open the file. It all works perfect - and I have it as vbModeless in order that I can use excel for other things. Problem is, when I close the other workbooks, it also closes the userform and workbook that I want...

Hi I am trying to use workbooks.close (the close function of the collection workbooks). So I wrote the code below. but that code will close the workbook i am working on. I wonder if I can close other workbooks but not the one I am on right now using workbooks (collection)? I know I can close...

Is it possible to use structured references between workbooks. I have a data work book which is pulling data from a table in a master sheet using row / column references and this is causing me an issue if a column gets added in the master sheet and I want to use structured references to get...

Hi there I have several workbooks in one folder that I need to open and copy a number of cells (G2:O2) from the same sheet name ('Output Create') for all of the workbooks into a 'Master' spreadsheet. Within this Master spreadsheet Column A contains a name of a place, which partially matches the...

I'm trying to write a VBA that will concatenate the same cell across a whole folder of workbooks. Each workbook in the file is the same, just a different topic. I have 15 different workbooks, for example I have Lion, Tiger, and Panther. In sheet 3 column D of each of these books I have some...

Hi, I have problem with my workbook, I solved first issue with user defined functions, but now I have very slow workbook, with small amount of data (comparing other workbooks I made), can somebody help me? reference to my last thread...

Hello, I have multiple files with varying working and backup sheets but I would like to create a macro that will print the main group of tabs which will always vary in actual names. My initial thought was to create marker workbooks named 'start' and 'end' for example that would mark the...

Hi I have over 500 workbooks, I want to add the workbook name in column AD for every row with text in it for all 500 spreadsheets. I plan to merge them into one master spreadsheet but I need to know which spreadsheet the data came from. Can someone please help me with the first part to add the...

Hi, I've got some code that is looping through multiple workbooks (with multiple worksheets) to copy data however it's pulling ALL the worksheets within these workbooks and i'd like to limit it the copying to specific ones. Is there a way to list the worksheets that i only want the code to...

Hello I have the below code, which should show an error msg box and close the two workbooks the macro has already opened when there is nothing to paste. This is working to well! as in it runs even when there is copied text. Sheets("Tab 2").Select Range("A1").Select...

Hi all - just wanted to some insight on running Excel over a VPN vs a virtual machine. We have a series of robust workbooks that use a lot of VBA several COM add-ins. Lately, we have been encountering a lot of workbook crashes for remote users(they happen at arbitrary times - can be while...

Hi I have very little experience in VBA but need to puttogether some code to save me a great deal of time. To set the scene: Each day I get a list of style numbers for products. I have to check each style number against acollection of other workbooks and copy the corresponding row(s) to a...

Hi please can you help me I have a command button in Book17 where once clicked I want to copy range A1:E2 and paste into 2 other workbooks which are Book16 and Book18, I have the code below but it doesn't seem to work and the lines come up in red, please can you help me? [CODE]Private Sub...

I have a workbook that has 14 worksheets. I'm looking for some code that will split these worksheets out into individual workbooks while retaining formatting. I did find some code that does essentially what I am looking for: Sub Splitbook() 'Updateby20140612 Dim xPath As String xPath =...

Hi The code below takes several sheets in a Workbook and saves each sheets as its own Workbook. It saves the workbooks in the same directory that the source wookbook is saved. But Id like to prompt the user once to select a folder where all the workbooks will be saved. How do I do this ...

Greetings! I am quite new to this forum and know very little about VBA. Seeking your expertise in a matter that I've been searching for a couple of days to no avail. I am looking for a vba code to copy a Range from a sheet named "Estimation" of multiple workbooks in a folder to a template and...

Hi, I have a macro that selects a different excel workbook and copies all the data from the opened workbook into the existing. See below: Set Wbk1 = ActiveWorkbook Fname = "L:\GCRE\Financial Modeling.xlsm" Set Wbk2 = Workbooks.Open(Fname) Wbk2.Sheets(1).Copy ...

Hi i hope you can help, i have 2 workbooks (Book13 and Book14) these both have the same data, for example in cell C12 is the number 13 in both workbooks, but if someone reduces this number to 11 in either of the workbooks i want the other workbook to automatically update the cell to 11, i dont...

Hi All, I have been lurking around for an answer but haven't been able to find one for my issue. I am making a macro in Excel that will compile files into a larger file. These files to be compiled also have images in specific boxes that I haven't been able to get to come over. I would select...