Question Link between access and excel

[Runes]

Hi
I want to link a button in my access database to a excel sheet. The excel seet will show me a lot of due dates. It is poosible to link the button in access so if one due date in linked excel sheet is less than 30 days to expire the button will change color to red?

 

[Rabbie]

Yes. See Conditional Formatting. You may need some VBA code to make it work properly

 

[Runes]

Thanks a lot, but my knowledge of VBA coding stop my project

 

[mari_hitz]

Hi guys.

I am sorry to use this thread, please let me know if I should open a new one.
I have a question: I have created a sort of tool in Excel that helps my team to send me the technological issues they have. This excel has userforms created in VBA that it is used to provide the information.
I have reviewed and it is possible to connect an excel document to access, however I saw the codes but I do not understand where to put them and also, is it possible to link the information of the userforms to the access data base?
I do not know if I make myself clear, but I would like that whenever the team send me information that automatically by clicking a button or something this information can be sent to my access data base without me typing the information all over again.

Thanks a lot for all your help!