How to automatically stop a macro

M

Mogiwitt

I have a macro that I designed with Access 2003 to open a table, copy one
cell and paste the value to the appropriate blank cell in the next record.
The problem is, the data is derived from a .xls file that is always of
different lengths. One day it will be 140 records, the next 35. As such, I
want to come up with a conditional expression that will tell the macro to
only run if the value of a cell does not equal the word 'End'. Is this
possible? If not, how can I tell the macro to stop once it reaches the last
record (End of File?). Thanks!
 
S

Steve Schapel

Mogiwitt,

There is no such thing aqs a "cell" in Access. This may seem like
unimportant semantics, but I think it will help you.

This sounds like a most irregular thing to be doing in a database. Do I
understand you correctly, that the same value is being put into a
particular field for all records in the imported data?
 

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

Similar Threads

Pasting cell contents into a macro 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Macro to add a number to a list 2
Expression in Conditional macro 6
Repeat a macro using an expression 9
Stop macro after selecting 'no' 0
Excel Macro to automatically go to the right of the last colored cell 0
Conditional Operation of Toggle Button Macro 2

Top