I know how to open an Excel file with VB but I need help with writing an argument to see if the file is already opened, because if the file is already opened the Excel file opens as read only. If it's already open I want to skip to the next "goto" label.

How do I write an arguement to check if any given file is already open.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.