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 ' .
|How to read BOM (Byte Order Mark) from csv file.||4||37|
|How do I crate a Pivot table in Excel||2||10|
|Input Data Using a unique ID from another sheet in Excel||3||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!