Tag Archives: Workbook

Subscript Out of Range: How Do You Fix It?

When running a VBA procedure, you might receive this error message “Run-time error ‘9’, Subscript out of range”. In this article, we will talk about the possible reasons for the occurrence of this error and the ways to fix it.  According to our recent review,

No Thumbnail

Excel VBA, Open a Closed Workbook

I recommend readers to read the article below to further familiarize themselves with the process of automation: Excel VBA, Get Data From Another Workbook Through Automation – Basics: The code below will open the workbook located in the path D:StuffBusinessTempTempFile.xlsx”: Sub Example1() Dim objWorkbook As Workbook Set objWorkbook = Workbooks.Open(“D:StuffBusinessTempTempFile.xlsx”)