Hello all
i want to open a Excel file in access just for viewing puropse.
Can anyone suggest some code/buttons like in switchboard manger?
Regards
Hello all
i want to open a Excel file in access just for viewing puropse.
Can anyone suggest some code/buttons like in switchboard manger?
Regards
More than one way to accomplish this.
You want to open the Excel application to a specific known workbook? Use the Hyperlink Address property of a Button.
You want to open an Excel worksheet within an Access form? I once tried this and didn't like the results. The spreadsheet was quite large and just did not view nicely.
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.