active workbook

  1. K

    Open woorkbook -active sheet -next cell

    I have been using the following code to open a workbook to a specific sheet and going to the next available row for data entry. It had been working fine. Then in the course of testing, It stopped working and I would get a "ws = nothing" error... Private Sub Workbook_Open() Dim ws As...
  2. berty2000

    Excel 2016 Open another workbook and make Active

    Hi I have just upgraded to excel 2016 and Im having problems opening another workbook from a userform and making it the active one. It opens it ok, but you cant type anything unless you change to another sheet first then back again, it seems to still be active on the original workbook. Code...
  3. I

    help needed in modifying a macro to run in the other open workbook

    I am completely new to creating macros/editing vba in Excel 2010, so please be patient with my question. I have written a macro, edited it and it works in any workbook I open when I run the macro from the Developer toolbar. I have saved the macro in its own excel file and have created a button...
  4. J

    Activeworkbook faulty in 2013

    I have float over tools that used to open and work with a keystroke based on the active workbook, but in Excel 2013 it is unpredictable. In the backend activeworkbook may not be the last workbook you were looking at because of this multiple ap focus nonsense. Is there a workaround anyone knows...
  5. F

    Copy data from a folder of closed workbooks to a active workbook

    Hello all, Long story short, I have been looking for weeks on how to copy a range of cell's values from a folder full of closed workbooks into the active workbook, and then have it paste the values from each in order starting at "A2" on the active. Sadly, I have pulled up short on everything...
  6. F

    Copy/Paste data from one workbook to another

    I have a functioning macro in a synthesis workbook that prompts the user to open a data file workbook, copy specific cells and then paste the data into the synthesis workbook, into the next available row (the macro does the copy/paste, not the user). This part works well. Where I now have a...
  7. 0

    Confused Workbooks("str").Activate problems

    Hi all, I've been sourcing help from MrExcel for a while now but have never really felt the confidence to post any solutions or answers myself when there are so many people out there who seem to be gurus!!! Thanks to everyone who has ever helped me!! =) I'm currently trying to write a macro...
  8. T

    Append to the bottom of a master sheet from another active workbook?

    Hi All, I'd like some help appending data to the bottom of a master worksheet from another active sheet in a different open workbook. For example I receive an internal order, which could have between 1 and 200 lines on it. I need to add these lines to bottom of a master schedule of order...
  9. N

    VBA: Get Active Workbook Name

    Hi All, I need to return the name of an active workbook, but I cannot use ThisWorkbook because my code resides in an add-in. I have managed to make a function to accomplish this, but it seems messier than it ought to be. Does any one know of a slicker way to do this? I'm using Excel 2010 and...
  10. M

    Should be simple, but I'm stuck... Please help!

    I'm trying to create a HYPERLINK formula that references cell A1, on a different sheet, within the same workbook. If my workbook was always named "Book1.xls," I could simply use the following formula: =HYPERLINK("[Book1.xls]Sheet2!A1","Next Page"),"") Unfortunately, the workbook I am...
  11. A

    Active Workbook

    I use a workbook that processes real time stock prices with a VBA timer and sends out an alert when a price goes into a desired range. But this requires this workbook to be always the active workbook, and when I opened another workbook the alert failed. I tried adding something like...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top