Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
I want other users to download the file.xlsx and have it in whatever folder they want. Using VBA I can get a current folder and put it in another cell like this:
Then I wanted to do something like this:
Private Sub Workbook_Open() Dim path As String path = Application.ActiveWorkbook.path Worksheets("AnotherSheet").Range("A1") = path & "\" End Sub
It doesn't work no matter where I put or omit those ' .
Join the community of 500,000 technology professionals and ask your questions.