view excel file inside access form with Microsoft Web Browser

[rinogattuso]

I'd want to see an excel file inside an access form.
This becouse excel files are not in a table format and i need to copy some values from excel to access manually.


And i need to do this for a lot of files
So would be fine if i could see at the same time excel file and access form where to insert data.
I've tried with Microsoft Web Browser but if i connect the excel file, when i load the form, access ask me to open the file in a separate excel window and not inside the form.
But if i connect pdf or jpg files . i can view the file correctly inside the form.
There is a way to see access that don't open excel file in a separate window ?
thanks

[ranman256]

just link the excel file as an external table then you can view it in a form.

[Gicu]

Have you tied using a bound object frame control? See attached sample that handles Excel, Word and PDFs.

Cheers,

[Micron]

Seems to me that the file isn't in a db table, so unbound object control? If it's web hosted, then browser control? I agree - would be better to link to it from Access, but that assumes it's a file system object. Can you link to a web server file?

[rinogattuso]

Have you tied using a bound object frame control? See attached sample that handles Excel, Word and PDFs.

Cheers,

thank for the example.
is ok but has some problems:
1) I can't copy cells value, becouse is only readable
2) ole control resize caracthers size of excel files, sometimes too big sometimes too small tried to change object property but results are not so good
3) can't see sheets, only selected sheet is visible.

thanks

[rinogattuso]

just link the excel file as an external table then you can view it in a form.

this is solutions that i see that work even if excel file is not in a table format.
The problem is that if i have a file with different sheets it' difficult to manage in a form

[Gicu]

@rinogattuso
I had some spare time so I created and Excel file previewer that dynamically links and displays each sheet in its own tab similar to how you would see it in Excel. Give it a try and see if that helps you. Note that it still needs some error handling\validations but should be functional to show you how to do it.

Cheers,

[rinogattuso]

very good example, i'll study it
thanks