Questions opening a spreadsheet

This is actually 2 questions.

I currently open a workbook using the following syntax

Please Login or Register  to view this content.

Question 1: Can I specify a path to start looking? Currently the File Open window starts in home directory for personal.xlb.
Question 2: How do I determine if the file I am trying to open is already open?

thank you
Galdalf2524

Hi,

1. To specify the path to start looking, insert this line before you call Application.GetOpenFilename:

Please Login or Register  to view this content.

Just change the string to match the path that you want to use.

2. Insert these lines after the file has been chosen (or move the declaration to the top of your subroutine if you wish):

Please Login or Register  to view this content.

And then copy this function into your VBA module:

Please Login or Register  to view this content.

Hope this helps

ajryan88
thank you for your help

You're very welcome