ole excel files embedded

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » OLE Excel Files embedded in Access

OLE Excel Files embedded in Access

resolvedResolved · Low Priority · Version 2007

Richard has attended:
Access VBA course

OLE Excel Files embedded in Access

Is there a way to extract Excel files embedded into a field as a OLE binary as a stand alone file.

RE: OLE Excel Files embedded in Access

Hi Richard, thanks for your query. This tool may be of use:

http://www.lebans.com/oletodisk.htm

Hope this helps,

Anthony

RE: OLE Excel Files embedded in Access

I was hoping to be able to do this using VBA/VB, but I suspect this is not possible.

Thank you for finding another solution.

Regards

Richard

Wed 6 Jun 2012: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips


Server loaded in 0.08 secs.