1. B

    How to access value and change events of Userform dropdown in another workbook

    Is there a way to capture the userform object in another workbook in the same instance of excel or different instance of excel? Currently we have a drop down value for a userform save its value to the excel worksheet which we pull the value from in another workbook . However I am wondering if...
  2. A

    Auto Resize to fit different monitor sizes

    Hi - Could someone please give me bit of assistance, I am trying to get an excel document to auto resize to different monitor/screen sizes so bosses do not have to scroll around document. I have tried the code below but does not work (also not sure if putting in the right place, fairly new to...
  3. B

    Copy sheets from closed workbook

    Hi all, back again with another ask. I have tried the below code (with a slight mod to try and pull the whole sheet rather than the range) to try and call up a workbook (name changes so need to be able to select from file explorer), copy sheets 1-4 and paste in the original workbook that the...
  4. J

    Object unexpectedly changed in VBA project window - how to change back?

    Hi, Working on a spreadsheet containing VBA, last night, closed it and it contained 1 Workbook object (ThisWorkbook) and several Worksheet objects) Today, in the Project window, two worksheet objects have changed icons and showing as Workbook objects?! This is causing an issue with a save...
  5. D

    Creating dynamic reference from another workbook

    I want a drop down list in one workbook that references a dynamic list in another workbook ie it may have entries added to it so I can't hard code the reference? If I select data validation for a cell, I set it to allow a list but what do I put in the source for the list to be from another...
  6. B

    How to acces ADO disconnected recordset object from another workbook

    Is it possible to have a recordset object created in one workbook but access this recordset object from another workbook's vba code? I was thinking maybe getobject could be used to capture it from another workbook but I cannot find any resources on this.
  7. A

    VBA .xlam for multiple workbooks

    Good morning, I have several tools working with which include sometimes the same Subs . So everytime I found an effort on one Sub and change it in one workbook I repeat this in the other workbooks. Wasting time - isn’t it? I want to have one workbook with all Subs inside, soft coded. So they...
  8. A

    Save Workbook with name generated from excel data

    Hello brainiacks, (said with utmost respect). Please help with my problem: I have some code in a workbook named configureData.xlsm that creates a filename in Q2 . I want to open a new workbook.xlsx and save it with the fileName created. The path would always be the same: UsersName =...
  9. D

    Excel macro insert 10 blank rows at top of every tab in a workbook

    Hi, is it possible to use a macro to insert 10 empty rows in row 1 of a workbook and do this for every tab in the workbook? Then I would like to copy a table and I insert this into the 10 blank rows created? I have 100 tabs on the workbook so want to avoid doing things manually. Thanks.
  10. N

    Todays little conundrum copy worksheet.

    Morning all Using what I have learned, today I managed to copy a range of one sheet to a new sheet preserving formatting using the paste special method. This sheet is then copied to a new workbook that opens, saves and closes using the below code. This method although very simple does not seem...
  11. N

    Password Protecting Worksheet from Viewing or Alternatives

    Is it possible to have multiple people share the same workbook with different permissions? Let's say everyone has access to the workbook file, but they have to have a passcode to view a certain tab? OR If you create the spreadsheet tabs to be very hidden, is it possible that the person who...
  12. M

    Issue with TEXTJOIN, multiple criteria. IF/AND function

    Hi I am unsure how to attach an example workbook for my query. As you can see from the image above, I have Company, which has two data sets associated with it - Product and Category. I am looking to allow someone to input the product and category then be given a , separated 'list' of...
  13. C

    Get cell value from another sheet in same workbook

    I have multiple sheets in the same workbook and would like to get a cell value from a specific sheet and specific cell. How would this be accomplished
  14. A

    IF (cell text value) THEN copy & paste from another workbook

    Hi All, Virgin poster here, rookie VBA user...please be gentle... I have a Master workbook which automatically compiles various worksheets drawn from different Project workbooks (no code involved, just links) Besides the linked data, I also need to copy/paste tables and graphs depending on...
  15. M

    VBA code to open a file

    Hi, I m new to VBA coding - I am looking for some guidance to the following: I would like to use a workbook to search for a folder in explorer, open the desired workbook in that folder, then slect a range of data from the selected workbook and store it in a new work book. I need something that...
  16. W

    How to publish as web page with relative path

    Hello. I'm publishing some reports as .htm files, and I faced issue with relative/absolute path of output .htm files. Let's say, workbook is located in folder "Publish" at desktop. I want to publish .htm files in that same folder where workbook is located. Attached is layout of dialog for...
  17. A

    Vlookup to a sheet in a workbook that changes each month

    Hi everyone I have learnt so many tricks from this forum which has made my job much easier. I have another "challenge" now: I have inheriated a workbook with many cells lookup to a worksheet in another workbook, it is simply, however, the worksheet changes each month, for example, in Oct the...
  18. B

    Drop Down List Pulling From Range From Different Workbook

    Is there a simple way to have dropdown look to a range in a separate workbook?
  19. K

    Copy filtered data from workbook to new workbook

    I am trying to copy filtered data from a .xlsm workbook (an image, headings, filtered data) to a new .xlsx workbook. I found some code that I have modified which copies the data in the active worksheet to a new workbook allowing the user to enter their own title and save as. The issue is that...
  20. S

    VBA to Transfer data from one workbook to another

    Hi all, Still learning VBA and this may be a really basic question for all, but I am struggling to find the answer while surfing. Would really appreciate some simple explained help to learn. TASK I want to transfer data from one workbook to another. using a "transfer tool" which i can email...

Some videos you may like

This Week's Hot Topics