| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.access.formscoding,microsoft.public.access.externaldata
|
|||
|
|||
Bypassing the Security Warning when opening Excel file
I've got an Access application that has to read some data (and perform some
manipulation of it) from several Excel files. Unfortunately, when I either import or link the Excel spreadsheets, Access is misinterpreting a field type and I am losing data. Because of this, I am using automation to open Excel and read the records one row at a time, doing the appropriate data type conversions. Unfortunately, I keep getting the annoying macro security warning whenever I open the Excel files. Is there a way to bypass this warning and disable the Excel macros programmatically? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent bypassing security by copy/pasting to new workbook | Excel Discussion (Misc queries) | |||
| Re : Security warning when saving downloaded file from Excel Options | Excel Discussion (Misc queries) | |||
| Security warning when saving downloaded file from Excel | Excel Discussion (Misc queries) | |||
| How to stop warning message when opening excel file in IE | Excel Programming | |||
| Email from excel VBA without Security Warning | Excel Programming | |||
Threaded Mode
