G
Guest
I have 2 issues i would like to solve. First case... I have an excel file
emailed to me on a a daily basis. I then open the file in excel and run a
macro against it to format it and save it. The next thing i do is open an
access db and run a macro that imports the excel spreadsheet. I would like ot
automate this a little bit more. Can someone give me some guidance on how to
automate this? ideally i would like to save the file to a folder and do the
formating and importing all from within access. I can setup an email rule to
save the file when recieved.
2nd case, is there a way to make a watched folder in access without a lot of
programming on my part? ideally, when the access db is openned and a form
opens it would check for a file in a specific folder. if the file is new it
woudl import otherwise it would ignore and keep going. Any thoughts? Thanks.
emailed to me on a a daily basis. I then open the file in excel and run a
macro against it to format it and save it. The next thing i do is open an
access db and run a macro that imports the excel spreadsheet. I would like ot
automate this a little bit more. Can someone give me some guidance on how to
automate this? ideally i would like to save the file to a folder and do the
formating and importing all from within access. I can setup an email rule to
save the file when recieved.
2nd case, is there a way to make a watched folder in access without a lot of
programming on my part? ideally, when the access db is openned and a form
opens it would check for a file in a specific folder. if the file is new it
woudl import otherwise it would ignore and keep going. Any thoughts? Thanks.