Search results

I think I may of found a soultion to your problem. I decided to create an example myself to help guide you. Hopefully you can fill in the gaps of your own spreadsheet from my example. Example: Worksheet names: Master, Sales and Summary. Relevant columns: Master- ABCDEF. Sales- ABCD. Summary-...

I don't think you need to use VBL coding in Access to refresh data in Excel. You say it only refreshes when opening and closing it. Your soultion may be as simple as this: What you can do is first open your Excel document and in the toolbar click on Data>Connections. Then choose what...

Hi everyone, This is my first post on this site so I apologise in advance if I am not making any sense. I've embedded 2 VBL codes into 2 buttons. One of the code's work, however the other one doesn't. Private Sub Command31_Click() Dim oApp As Object Set oApp =...