X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Excel Vba Not Running, Office 2007    
Frank Situmorang
post Apr 23 2019, 06:51 PM

Posts: 1,203
Joined: 10-June 10

[attachment=90117:Runerrormessage_1.png]Hello anyone can tell me why my Macro VBA not running?

It stops in
Windows ("Book2.xlsx") .Active

While the Book2 is already opening.

Thank you

This post has been edited by Frank Situmorang: Apr 23 2019, 06:52 PM
Attached File(s)
Attached File  Runerrormessage_1.png ( 103.24K )Number of downloads: 10

Frank S
Highland, CA
Go to the top of the page
Doug Steele
post Apr 23 2019, 07:23 PM

UtterAccess VIP
Posts: 22,246
Joined: 8-January 07
From: St. Catharines, ON (Canada)

Just to make sure, you've posted this to the Microsoft Word forum. Did you mean to post it to the Microsoft Excel forum?

AFAIK, activating a worksheet doesn't automatically run code in it unless it's a routine that's meant to be run upon activation (such as Workbook_WindowActivate or Workbook_SheetActivate in the ThisWorkbook module.

Doug Steele, Microsoft Access MVP (2000-2018)
Personal webpage
Microsoft profile
Co-author: Access Solutions: Tips, Tricks, and Secrets from Microsoft Access MVPs, published by Wiley
Co-author: Effective SQL: 61 Specific Ways to Write Better SQL, published by Addison-Wesley Professional
Technical Editor: Access 2010 Bible, Access 2013 Bible, Access 2016 Bible, all published by Wiley
Technical Editor: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition, published by Addison-Wesley Professional
Go to the top of the page
post Apr 25 2019, 05:09 PM

Posts: 5
Joined: 22-April 19

You can use Thisworkbook.Activate method to activate the workbook.
So your book2 is opening for running it further you need to add further macros.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    23rd February 2020 - 06:45 PM