Ms Access 2007 - VBA code to pick up a text in excel sheet and display the same in textbox

[neerajm575]

Hi Experts,

I am struggling to write a VBA code that picks content placed in Sheet1 of excel workbook and then display the same in text box on the MS access form. I am sure this is simple for you!:-) Please help

Many thanks for your help.

Regards,
Neeraj

[June7]

Can you set a link to the Excel workbook?

What code have you attempted?

Why is Excel involved?

[neerajm575]

Many Thanks for responding back to my query. To let you know I am still a learner. Tried various codes. Don't know what to share at this moment with you. However, I am attaching a access DB and excel.

The requirement is to have a table updated in excel and same to be displayed in message box(with image) for sending email to staff.
Refer to the form in attached MBD file.

You may also suggest me a different way to do this.

Many thanks for your help in advance.

Regards,
Neeraj
Expense letter.zipExpense letter.zip

[June7]

I cannot download nor review files until March 23. If you still need help then, make another post to get my attention.

If the structure of the Excel sheet is simple enough, should be able to set a link to it and then use the link like an Access table, except cannot edit the data.

[neerajm575]

No Problem, I can wait until March 23. Do suggest me the solution to the issue post March 23.

Many thanks once again for your help & Support.

Regards,
Neeraj

[ssanfu]

In the meantime, you might look at Ken Snell's site at:

Ken's ACCESS Examples and Information for Working With EXCEL Workbook Files
http://www.accessmvp.com/kdsnell/EXCEL_MainPage.htm

[June7]

Setting a link to Sheet1 is not practical. However, the Email_Database sheet can be linked. Why are there two sheets in the sample workbook?

I am not clear on what you want to do. Do you want to import from Excel into Access or export from Access to Excel? Or is Excel even needed? Do you just want to send an email from Access?

Sending emails from Access with data is common topic. Search forum. Here is one https://www.accessforums.net/program...ook-21903.html

[neerajm575]

Yes, The requirement is to update excel sheet with the data filtered from the query and then display the content in text box of the form and send email.

The second sheet on excel workbook can be ignored.

Thanks!

Regards,
Neeraj

[June7]

Code in Access to update the Excel sheet will be complicated. Did you review the Ken Snell site referenced by ssanfu in post 6?

If you want to email data from multiple records in the email body and not an attachment, that will also be complicated code.

Not writing it for you. You will have to provide attempts for analysis.

[neerajm575]

If codes are complicated, can a report in access be created that can be displayed in text box and email can be send out?

Regards,
Neeraj

[June7]

Certainly data from multiple fields can be concatenated into a single text string.

[neerajm575]

Can you guide me how can I do that.

Thanks!

Regards,
Neeraj

[June7]

Expression in a query or in textbox on form or report that is bound to table or query, like:

[fieldname1] & " " & [fieldname2] & " " & [fieldname3]

This is basic Access functionality.