Search results

I added the excel applications to access's library and prompt the excel userform that way and just set the application screen to false so the workbook itself wasn't visible. Then I have TransferSpreadsheet pulling the data that I have the macro pulling into my table. All at the push of a button...

thanks a lot... I may give it a shot if i get bored later today :P

Anyone know of any code that I could add to my macro that will prompt a msgbox the contains a countdown? After the countdown, I would like the msgbox to automatically close and the macro continue. Anything would be great. Thanks in advance! Jason

Got it, thank you very much for getting back to me. I had my macro divided into two individual subs and what I did was just deleted the time function, altered a couple of things and badabing! Currently looking for some code that will populate a msgbox with a 5 or 10 second countdown that will...

Hello everyone, I'm plugging away here but I ran into another problem. Long story short I am using the excel ontime function in my access query but I need it to active a access macro. Can excel functions do that? Does anyone know how? There has got to be a way:p

I am new to programming and have a question. I have a userform with 3 comboboxes running a macro in excel and spitting out the data into a worksheet. What I would like to happen is the data that gets inputted into the worksheet after running the macro to be exported to a table in access...