I am trying to use API call via Visual Basic 6.0 to access Excel 2000 file properties. I have a program that opens an excel template we have built and up until now it has not been a problem. Now our customer(s) are requesting custom templates so I need a method of identifying a template before the program opens. Is there an API call that will access excel file properties. I'd like to use either the Summary, or Custom file properties you see when you right click on an excel file and goto properties menu item. I'd really like to use the Custom properties so I can more customize the properties, but if I can access the Summary properties this will work just fine.
Thanks for help anybody can provide.
Darrel
Thanks for help anybody can provide.
Darrel