Opening large Workbooks in excel

0 votes
Every time one of those workbooks needs to be opened, a macro I use that opens numerous huge files at various times gets stuck in the opening file dialogue box. I can fix this by clicking cancel each time; nothing will break and they'll open as intended, but I don't want to have to. Can I do anything to resolve this?

Please let me know if I need to screenshot anything. When I execute the code to open the workbook alone, it functions as intended, but when I run the complete macro, the workbook won't open (at least not in a reasonable time).
Jan 7, 2023 in Others by Kithuzzz
• 38,020 points
488 views

1 answer to this question.

0 votes

Here is a code I tried to open a workbook and got the data:

Sub Open_Large_WB_ReadOnly()
    
    Dim WB As Workbook
    Dim WBdir As String
    Dim Start As Long
    
    Start = Timer
    
    WBdir = "C:... some very large workbook ... .xlsx"
    
    Set WB = Workbooks.Open(WBdir)
    Debug.Print WB.Sheets(1).Range("A1").Value
    WB.Close (False)
    
    Debug.Print " Regular " & Format(Timer - Start, "0.000")
    
End Sub

Timer total = Regular 38.066 -> 38 seconds is a long time.

answered Jan 7, 2023 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

Writing large Excel in Java causing high CPU usage using apache-poi

Giving SXSSFWorkbook a window size appears to ...READ MORE

answered Jan 29, 2023 in Others by narikkadan
• 63,720 points
1,528 views
0 votes
1 answer

Searching Multiple Criteria In Large Data Set to make new Data Set Excel VBA

Copy the data to an array, filter ...READ MORE

answered Jan 31, 2023 in Others by narikkadan
• 63,720 points
986 views
0 votes
1 answer

Read excel file without opening it in vb.net

Instead of utilising the variable strFileName, you ...READ MORE

answered Apr 9, 2023 in Others by narikkadan
• 63,720 points
2,117 views
0 votes
0 answers

How to handle large http response data from observer in Angular application to avoid browser crash?

Suppose we have a angular application which ...READ MORE

Apr 19, 2019 in Others by Hemant Gajbe
2,547 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,092 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
3,510 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
813 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
979 views
0 votes
1 answer

Opening Selected Hyperlink DISPLAYING TEXT in Default Browser in MS Excel

Try this code: Sub Open_SelectedTextlinks() If Not ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 63,720 points
681 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP