workbooks

  1. F

    Adding a column with workbook name in multiple workbooks

    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...
  2. L

    Copying from only select worksheets within multiple workbooks

    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...
  3. D

    Adding Error with Copy & Paste

    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...
  4. N

    Running Excel remotely - VPN vs Virtual Machine

    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...
  5. R

    VBA: Find matches in other workbooks for a list of values

    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...
  6. P

    Copy/Paste from one workbook to another 2 workbooks with range

    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...
  7. R

    VBA: Split out Worksheets to individual Workbooks

    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 =...
  8. M

    Prompt User for Save Location

    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 ...
  9. J

    Copy Range from specific sheet of all workbooks in a folder to a template and create new template in the Master sheet

    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...
  10. A

    VBA Help

    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 ...
  11. P

    code to work out from 2 workbooks

    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...
  12. V

    Copying and Pasting Images/Objects to another workbook.

    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...
  13. A

    Update Files from SharePoint

    Hi, I just started using the Power Query add-on for Excel. I have a workbook that is connected to 3 different excel workbooks. The 3 workbooks were extracted from the SharePoint site and put into a folder. I have the main workbook which appended those 3 workbooks into 1 sheet. My problem is that...
  14. Mel Smith

    Sharing linked workbooks

    I have a number of linked workbooks that I need to share with one, or possibly two, other team members. We work in different locations. I have trialled sharing these workbooks with one colleague via OneDrive, which wasn’t without some problems but I wonder if there is a better/smarter solution...
  15. Jambi46n2

    Renaming Workbooks based on Cell Value with VBA

    The code below works with renaming workbooks, however it also moves them as well. Is there a way to modify the code to make a copy of the workbook instead of moving it? Thanks much in advance! Sub RenameTesting() Dim OldName1, NewName1 'Work books based on cell values below OldName1 =...
  16. TinaP

    Communication methods

    Greetings Excellers! I'm currently working on a workbook with lots of UDFs and other volatile functions. Trust me, I've done my research and the UDF/volatile function mode is the preferred method in this instance. (The key phrase is "in this instance.") I also have other workbooks where...
  17. S

    Help Needed for unique task

    Good evening Ladies & Gentlemen I have been asked by a friend if I could help with an issue she faces on a weekly basis with excel workbooks Basically on the Monday morning of each week, she has to open a folder and view excel workbooks contained within that has around 80 - 150 workbooks at...
  18. D

    Automate the Comparison of 2 excel workbooks

    Hello!! New user and beginner to VBA. I'm trying to automate the comparison of 2 excel workbooks and have a message box in the masterfile pop out, telling me if theres a math between the total sum of items in "Books-Raw Listing" & "Raw Listing" workbooks. Here's the tricky part, the...
  19. davewatson86

    ActiveWorkbook.UpdateLink issue

    Hi all having an issue where i run the below code: Sub UpdateLinks() Dim Location As Variant Dim File_Name As String Application.ScreenUpdating = False Application.EnableEvents = False Call unprotect For i = 5 To WS_Admin.Range("C4").End(xlDown).Row File_Name =...
  20. W

    UserForm visibility and positioning

    Hello, I have a workbook that opens a userform as (vbModeless) on open and hides the window. Private Sub Workbook_open() Windows("Test").Visible = False Welcome.Show (vbModeless) End Sub The problem i am encountering is that this works only when there are other workbooks opened. If i open it...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top