Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

About handle...vb 6

I will be opening some excel files and close one or few off and on from a vb 6 form.  Could handl HWND be utilized to do this?

- Store file names and its HWND value in a temp table (There might be number of file open at the same time).
- Later on, select file you whish to close it, the code is expected to use HWND value for the selected file to close, from a temp table, to close the file.

I don't have a good grasp of HWND.  Is it something that could be used this way?

Thanks,
0
Mike Eghtebas
Asked:
Mike Eghtebas
1 Solution
 
David LeeCommented:
Why would you want to?  You can open all workbooks in a single Excel application object.  That means you already know the name of the object containing the workbooks.  Workbook objects don't have an HWND property only the Excel application does and you already know its name.  I don't see that there's any value in this.  Even if you were going to have multiple Excel application objects, which I also don't see any real value in, it'd be far easier to use a collection object to hold them all.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now