Hi
Just curious if anyone has had success linking the Bet Angel spreadsheet to MS Access and building an Access interface on top of it?
Many thanks
MS Access and Bet Angel spreadsheet integration
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
All the MS office components are built to be linked so I'd imagine they're be plenty of code around the net to transfer data between the two and a worksheet event could easily your excel macros off to start the routines.
Made some progress. The spreadsheet is read only so made a copy and linked to Access.
It sort of works! Refresh happens but is slow - about 80% slower and some of the header/row data appears and disappears randomly.
Maybe I will try to link programmatically
It sort of works! Refresh happens but is slow - about 80% slower and some of the header/row data appears and disappears randomly.
Maybe I will try to link programmatically
Nigel
Many thanks for the link - good info. I have managed to get this far but simply linking the spreadsheet to Access only sort of works. The dynamic updates are slow and the information that is brought over each time is inconsistent. I will source some VBA code which will hopefully sort the issues
Ken
Many thanks for the link - good info. I have managed to get this far but simply linking the spreadsheet to Access only sort of works. The dynamic updates are slow and the information that is brought over each time is inconsistent. I will source some VBA code which will hopefully sort the issues
Ken
Good video here:
https://www.youtube.com/watch?v=MWLBM2t7azc
and the source code:
http://www.exceltrainingvideos.com/get- ... excel-vba/
https://www.youtube.com/watch?v=MWLBM2t7azc
and the source code:
http://www.exceltrainingvideos.com/get- ... excel-vba/