Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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 ' .