Excel VBA to Open Workbook and Close Workbook

[@ratnadevi3030]

Hi.. if I would like to use variable mypath as the folder path and open 2 different workbook.. how can I do that

[@SuperHanme]

Thank you

[@drewpetty8293]

I want to open a file read only status, run a query, print, then close without saving. How do I do this?

[@ExcelDestination]

not sure........let me check.

[@drewpetty8293]

@@ExcelDestination I figured it out. activeworkbook.saved = true this line makes the saved property true without actually saving.

[@likithscreation3526]

Super

[@ExcelDestination]

Thanks!