Hi all
Hope you can help, I need to import a single cell from an excell spreadsheet and place it into a textbox on an access form, i understand the easiest way to so this would simply be to cut and paste.
but here is the crux of my problem I need to do this for multiple cells and paste into multiple textbox's for data that changes on a daily basis, and essentially on the click of a command button.
I have attempted to use the TransferSpreadsheet method but I believe I can specify a range of cells but not a single cell,
In a nutshell I would like to replicate my spreadsheet in access by mapping each cell to a textbox
apologies if this is a little garbled but I have to admit I am a little new to Access and VBA coding.
thanks for reading and your anticipated help
Zippy483