Hi,
I have written VBA code to read Excel data in cells into MS Access.
I have to read Objects also attached to Excel file (like MS Word, Text File, PDF files). I am not understanding how to do this.
Can anybody please help me!
Thanks.
Hi,
I have written VBA code to read Excel data in cells into MS Access.
I have to read Objects also attached to Excel file (like MS Word, Text File, PDF files). I am not understanding how to do this.
Can anybody please help me!
Thanks.
You mean you have cells in Excel set as hyperlink to documents? You want to save those documents in an Attachment field in Access table? Or you just want a hyperlink in Access?
Review:
http://office.microsoft.com/en-us/ac...001213852.aspx
http://blogs.office.com/b/microsoft-...cess-2007.aspx
http://www.allenbrowne.com/casu-09.html
http://allenbrowne.com/func-GoHyperlink.html
http://www.brighthub.com/computing/w...les/59992.aspx
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Hi June7,
Thanks for your reply.
I am NOT talking about hyperlink inside cell.
In the Excel Application:
Insert Tab | Text Group | Click on Object | Select Create From File tab => We can Insert external object, right!
I have to read Objects also attached to Excel file (like MS Word, Text File, PDF files). I am not understanding how to do this.
Could you please help me on this!
Oh, never done that with Excel.
I googled: extract embedded objects from excel
Maybe this one will get you started http://www.syntax-example.com/Forum/...-hd-25853.aspx
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.