Hi,
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.
Right heres the code i am using to open my excel spreadsheet.
I have declared global variables in my module that are used to identify the wokbook and worksheet.
My main form has many different navigation buttons, when a button is pressed, the form opens the excel workbook and the work sheet, then hides the main form and shows the form that uses excel.
'Sets the filepath for the excel workbook and opens it. Set xlBook = xlapp.Workbooks.Open(App.Path & "\Job Sheet.xls")
'Sets the Sheet to output data to. Set xlSheet = xlBook.Sheets.Item(1)
frmMain.Hide
frmJobSheet.Show
This is killing me lol, please can you try and help. Thankyou
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Unsolved 
