Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
Variable Declaration: LoadFilePath = "http://server//file path/filename.xls" Workbooks.Open (LoadFilePath) For arrayLnItem = 1 To lastRow With Workbooks(LoadFileName).Worksheets(1) .Cells(LoadFileRow, 1).Value = flatFileArray(arrayLnItem, 1) .Cells(LoadFileRow, 2).Value = flatFileArray(arrayLnItem, 2) .Cells(LoadFileRow, 3).Value = flatFileArray(arrayLnItem, 3) End With Next arrayLnItem
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Excel Macro update each line based on another worksheet||2||55|
|VBA error subscript out of range help||5||29|
|3,000 rows of comma separated values||14||31|
|WIthin VBA summing record count in 3 tabs||7||38|
Join the community of 500,000 technology professionals and ask your questions.