Stopping an Import program

  • Thread starter Thread starter BTU_needs_assistance_43
  • Start date Start date
B

BTU_needs_assistance_43

Anybody got any advice on how to write in some code such that when I import
cells from Excel to a table in Access, my program will add every cell
starting with a cell I specify until it comes to one with nothing but 0 in it
and then stops the cell before?
It doesn't matter if it takes the information out one cell at a time or if
it takes them out rows at a time or columns at a time just so long as when it
reads a 0 or #DIV/0! value it doesnt add those cells and stops.
 
Let me amend that. I need the program to take in values from the entire table
starting at the cell i specify, but exclude only the rows that are all 0's
and #DIV/0!'s. The format they send these reports in isn't going to change so
I have to adjust my program to beat this unfortunately.
 
Back
Top