Exit macro on no permission

B

B. Meincke

I hope I can convey my needs in an intelligent way...here goes:

I have a macro that runs a series of queries that empty a database's tables
and repopulate them from text files our school board dumps into a folder on
our server. There are only certain domain user profiles that have permission
to the dump folder.

The Set Warnings action does not seem to halt the Transfer Text action even
if the user does not have access to the dump folder, but proceeds to empty
the tables but not repopulate them! Besides I do not want those with
permission to be bogged down with warning messages. And I would like to one
day be able to run a script to have the process happen automatically.

I know you can capture errors in VBS function sub routines, and I do so all
the time, but I would like to know if you can do the same in a macro. A
condition perhaps?

If I can provide any further details to facilitate help in this matter, I'd
be happy to.

Thanks in advance.
 
K

Ken Snell \(MVP\)

Put this action as the first step in the macro:

Condition: < you'll need an expression here that tests the user's name >
Action: StopMacro

How do you get or read the user's name? Let us know that, and we can assist
you with the macro's Condition statement.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top