Posted 8 September 2017, 2:09 pm EST
Hi Farpoint - Back in the Com days, we saved our spreadsheet files as .ss? files. It appears that in .net, xml is the format of choice. We use a model file to populate the Spread control. When I open it from the Designer, it takes 5 seconds. From vb.net it takes 35 seconds. I looked around and implemented what I could find in the way of suggestions (see sample code below), but it doesn't make much difference. How can I bring my code up to the speed of the designer open? Thanks!
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click