activate

  1. K

    Activate QuickBooks from Excel VBA

    I have a VBA code that I run on a spreadsheet at the end of which, I'd like it to activate the already-open QuickBooks program. I'm trying to shave off as much time as possible in my tasks. How can I do this? UNNECESSARY EXPLANATION: While the code is running, I activate QB and create a new...
  2. A

    Problem with .References.AddFromFile

    Hi members I have a trouble when I add references from file path using vbProj.References.AddFromFile "C:\Windows\SysWOW64\ieframe.dll" and vbProj.References.AddFromFile "C:\Windows\SysWOW64\mshtml.tlb" I receive a message "No se puede entrar en tiempo de interrupción en este momento" Also...
  3. albertc30

    activate sheet not always calling for form...

    Hi all. The code bellow seems to be working randomly. Private Sub Worksheet_Activate() Sheets("customers").Unprotect Password:="******" 'UnProtects the customers sheet. Columns("A:R").Select ActiveWindow.Zoom = True Range("F14").Select...
  4. M

    Activate a sheet without using "Activate"

    I have read that it is best not to use .Activate whenever possible. But I can't figure out how to do something without it. In my workbook, one thing it will do is copy sheets into a new workbook. Once it copies the sheets, I want the code to select the first workbook in the sheet, so that...
  5. B

    Connect SQL Database to Forn Activation

    Hi, I'm new Userform and when the form activate a dropdown list must be populate. I can't get my project to connect to the SQL database. With all my searches I found these code but I have no idea where to place these code. I have tried to place them in Userform activate but I get an error...
  6. S

    How to avoid using SELECT and ACTIVATE?

    i have written this piece of code below, but a friend suggested i avoid using activate and select. i tried re-writing by using WITH but it is not working. what can you guys suggest? thanks. wb2.Activate ws1.Activate rngA.Select Range(rngA, ActiveCell.End(xlDown)).Select...
  7. K

    Activate New worksheet based on cell text

    Hey Guys, I've figured out how to create a bunch of sheets based on some source cells. Now I'm trying to copy the data in the column from each source cell to the page that was created. This is what I've got so far. Sub AddWorksheetsFromSelection() Dim CurSheet As Worksheet Dim Source...
  8. O

    Activate A Sheet Based on a Cell in a Current Worksheet

    Thanks in advance for your help and I will let you know what it took to make it work. I would like to activate a sheet based on the contents of a cell. For example within Sheet "Simulation". Cell C3 contains "Evaluate1", I would like to activate that sheet. I tried the following, but I get a...
  9. D

    Find active workbooks name containing strings and activate

    Hi all, I found I have no other way of doing this than to have a code in third workbook manipulating 2 other workbooks. This is where I'm stuck, little help would be appriciated I need the code to find active workbook containing "name1" as part of its name, then activate it, run some code, then...
  10. H

    Activate 1st Excel file

    Hi, I can see 2nd line below is for another Excel file. How to activate 1st Excel file below (by 1st line)? Workbooks.Open Filename:=fl fn = ThisWorkbook.Name
  11. M

    VBScript - Activating an Excel Window Already Opened?

    I am trying to write a VBScript (.vbs file) that will allow me to activate the current Excel window opened which is just the default "Book1" window after clicking "Blank Workbook" after opening Excel 2016 running on my Windows 10 PC, and activate that Window by bringing it on top (like as if I...
  12. R

    Create and Activate New Worksheet

    Hello, I have a userform that creates and names a new worksheet when I click the Save button. Once the save button is entered I need another userform to activate (UserForm2) AND make the newly created worksheet activate so that the info on UserForm2 is transcribed to the new worksheet...
  13. P

    Activate a file which using input box

    Hi all, i would like to "Activate" a file which is open but using an input box by VBA. An example of command is below but therefore that the file (e.g. "PAYROLL.xlsx") should activate by input box. Windows("PAYROLL.xlsx").Activate Thanking you in advance
  14. F

    Access a shortcut (or program) and then send date range to it

    Is it possible to activate a shortcut on a desktop/start menu/folder and activate it? Then would it be possible to input data into this? Finally extracting the data (.csv save as) to a set location? It's in relation to COGNOS Impromptu so I can auto run reports using excel to open, pass the...
  15. P

    Activate a file using "Input Box"

    Hi all, I would like to write a VBA code so that to open and activate a file, which I will choose using an input box: e.g. Salaries 1-2018.xlsx The path of this is: ‘C:\Users\User\Payroll\Salaries 1-2018.xlsx” In input box I have to enter the file name, e.g. Salaries 1-2018 or...
  16. L

    alt+= to activate subtotal function

    Hi I was reading the article below and the author said using Alt+= to activate the subtotal function? Why subtotal function has short key? do other functions have short cut keys? thank you. https://yodalearning.com/tutorials/subtotal-excel-formula-excel-advanced-filter-trick/
  17. P

    Check Mark

    Hi Again. This post is still about the check mark problem that I started. That post has now been solved. What I want to know now is the following: The Event Procedure check mark will also activate if you move through the cell with the check mark. Apparently moving the mouse through the cell...
  18. A

    Macro to activate macros on other sheets

    I have an excel model that is used for real estate acquisitions. 8 of the 13 sheets contain a simple macro (activated by two separate buttons) to hide or reveal blank cells. I would like to create a macro on the Summary sheet to activate the "Hide" button on each of the 8 sheets. Is there a...
  19. L

    VBA Code to Macro issues - Activate method of range class failed

    I have this code that I cut and paste into a workbook, run and then save and close in a macro free workbook. I am trying to set this up as a macro in my personal file to share but keep getting the error above after the activate line. Any ideas as to why I cannot simply just put this as a...
  20. P

    activate hyperlink from vlookup value

    Hi guys, while I've been using the site for many years as a guest I've only just joined. I must say thanks for all that you guys do in helping complete strangers. Right, down to business. I have a set of hyperlinks on a masterdata sheet and a "cover sheet" with several vlookups. how can I...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top