Hi All
I have been trying various codes to open a selection of one Page workbooks (Graphs) from Both Access and other Workbooks. Access is being used mainly as login and navigation to reports.
The below code is the best I have so far, but when opening form Access 2003 , I still get password...
Hello
Because Excel 2010 can't save DBF format files, I though I could work around that by opening from the working file's macro an instance of Excel 2003. I more-or-less seem to have done that using:
Dim xlApp As Excel.Application
Set xlApp = CreateObject("Excel.Application.11")
'''...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.