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.
Join the community of 500,000 technology professionals and ask your questions.