I have overcome my program with the DLL files, but now have a slight problem with my progress bar.
Part of my program loads an external spreasheet and exports data to it for printing. Whilst my VB program loads the spreadsheet, thewre is a pause of about 7 seconds which i would like to display in a progress bar.
I need a progress bar that can determine how much percentage of the file has loaded. I can load text files like this using FSO to read the amount of lines and determine how much has loaded, but how can i do this with my spreadsheet?
I would appreciate any help with this as it is urgent.