Macro question??
Posted by Andrew on November 01, 2001 3:44 PM
I have a worksheet that links to an excel database, so when you finished entering info and click the 'save' icon it asks you wether you would like to create a new entry in the database and I click 'yes' then 'ok'.
I tried to record a macro that clicked 'save' then checked the 'create new entry' box and clicked 'ok', but the macro only saves the worksheet , no entry appears in the database. Is there a way to get the macro to do what I am trying to do??
Posted by Qroozn on November 01, 2001 6:56 PM
I always had the same problem when i started using a db in excel. it works when you record the mcro. but when you rerun it then it misses a step. You need to use VBA for this. I'll search my past posts for the answer.
the prob is that a macro reecords the result not the process involved.
Posted by Qroozn on November 01, 2001 7:02 PM
ahuh
now i remember.
What i did was got the top row of the "form" to equal the values that were inputted. The macro then copied those cells, went to the DB, found the next line, and pasted the values, saved and closed and went back to the form.
can you work it with this info?
Posted by Andrew on November 01, 2001 11:10 PM
I think I know what you are saying but how do you handle multiple entries on different rows..
