Retrieving external Data

[DMT Dave]

Hi Guy's first and foremost, hope everyone is staying safe

A bit of a long shot of a question, is it possible in Access vba to retrieve data based on and excel row but the excel file is shared on One Drive

We shouldn't need to check for null values as the data searched will be on the excel file

ie: StrPath = "onedrive.live.com/ etc etc"

Access data query 123456

Returns MsgBox(123456 is Found In Cell B373)

If MsgBox("Do You Want To Retrieve Cell H373" ?

MsgBox("Cell H373" = "Hello")


Please note, i have ignored correct quotes etc, i am only typing to hopefully make sense of the question

Possibly even retrieve the Excel page name that this found

MsgBox("Result Found On Page Name:" & _
PageName & " " & "Cell H373: " & Hello)
Thank you guys

[CJ_London]

to clarify - you want access to search all worksheets of a specified excel workbook for a specific value and you only want the first instance of that value to be returned? and that value is the 'whole value' i.e. if searching for 'hello' you would not want 'hello world' returned.

If the question is about searching a file on one drive, I don't see that would be a problem - try it and see

[DMT Dave]

Hi Ajax, thank you for your reply, would you have a sample code obviously apart from one drive address and our search input ?

The search would be the full content of the cell so in my example hello would be the only word in H373, my search would be of Column B, so if i search 123456 and it's found on Page Mar-Apr 2020 in cell B373, i am wanting to return what H373 says ie:

123456 found in cell B373 Worksheet Name Mar-Apr 2020
hello found in cell H373 Worksheet Name Mar-Apr 2020

13579 found in Cell B104
goodbye found in H104

So its the same row as the access query but a different column for the result return

Hope all of this makes sense

[CJ_London]

I don't have any code as such but found this link you could adapt

https://www.access-programmers.co.uk...number.201025/