Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-28-2019, 07:11 AM   #16
StuartG
Newly Registered User
 
Join Date: Sep 2018
Location: United Kingdom
Posts: 80
Thanks: 7
Thanked 0 Times in 0 Posts
StuartG is on a distinguished road
Re: Macro Errors

Quote:
Originally Posted by arnelgp View Post
open your VBA.
well, use the Search utility (Ctrl-F).
on the Option box, select Current Project.
then type this to search: Set xlApp = Nothing
then insert it above it.
Which area in the code though?
Attached is the area where the current project was.
Attached Images
File Type: jpg 1.1.JPG (18.0 KB, 8 views)
File Type: jpg 1.2.JPG (35.8 KB, 7 views)

StuartG is offline   Reply With Quote
Old 08-28-2019, 07:18 AM   #17
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Macro Errors

the second one has already xlApp.Quit, so you insert it on your first image.
insert a line before "Set xlApp = Nothing".

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Macro's giving errors after settings change dedjloco Macros 6 03-09-2017 09:17 AM
Scheduled Macro Errors twilbour Macros 1 06-29-2013 09:36 AM
Import Errors- only with Macro.... makewise Macros 0 08-30-2007 08:06 AM
Check for errors in a Macro? AaronC General 1 08-18-2005 01:47 PM
Receiving errors macro errors for reports that don't exist anymore! nishantd Macros 5 03-25-2004 06:56 AM




All times are GMT -8. The time now is 03:36 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World