- Joined
- Aug 13, 2013
- Messages
- 1
- Reaction score
- 0
Apologies if this is the wrong forum...
I would like to be able to access information on a number of spreadsheets (XL2003) from Access 2003 VBA. I have the code to do it all but I just cannot get around the problem of Excel's Security Warnings. I would be making almost 6000 individual cell data retrievals so it would be impractical to press <Return> that number of times!
I have tried using AutomationSecurity without success - it still pops up the Security Warning dialogue box. Does anyone have any suggestions/solutions?
I would like to be able to access information on a number of spreadsheets (XL2003) from Access 2003 VBA. I have the code to do it all but I just cannot get around the problem of Excel's Security Warnings. I would be making almost 6000 individual cell data retrievals so it would be impractical to press <Return> that number of times!
I have tried using AutomationSecurity without success - it still pops up the Security Warning dialogue box. Does anyone have any suggestions/solutions?