You will notice we had to specify the workbook, worksheet and range of cells. The following example shows you how to write to a cell on a worksheet. xlsm “ ). Simply replace Example.xlsm with the name of the workbook you wish to use. We can access any open workbook using the code Workbooks( “Example. ( Note: Website members have access to the full webinar archive.) If you are a member of the website, click on the image below to access the webinar. See File Dialog section below function below Set wk = Workbooks.Open ( "C:\Docs\Example.xlsx", ReadOnly:=True) Set wk =Workbooks.Open ( "C:\Docs\Example.xlsx") The following table provides a quick how-to guide on the main VBA workbook tasksĪccess open workbook (the one opened first)Īccess open workbook (the one opened last)
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |