Search results for query: *

Thanks for the help guys. Got it figured out now. It wasn't DisplayAlerts = False that I needed. It was xlapp.AutomationSecurity = msoAutomationSecurityLow Thanks again for the help. I think things are just about up and running now.

Thanks for the help Skip and Hugh. I'm beginning to get a workaround going here. The shelling and GetObject seems to be the way to go. One little hitch that I'm hung up on though. Previously, my program would include: xlApp.DisplayAlerts = False Set wkbk=...

There aren't any errors. My company has installed 2007 and restricted the ability to Programatically access VBA project. This option is/was available in 2003. The programs I have written in VBA require programatic access, and it is still available in 2003 which happens to still be on the...

Thank you for your advice. However, I do not need to save a workbook in 2003 format. I actually need to open Excel 2003 and run some macros that are in the workbook. These macros will not run in 2007 and I need to use 2003. Any further advice would be appreciated.

I have Office 2003 and 2007 on my work computer. I use 2007 for just about everything, but I need to open Excel 2003 from Access 2007. When I put the following code: Dim xlapp As Excel.Application Set xlapp = New Excel.Application xlapp.visible = True I naturally get Excel 2007. For reasons I...