Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
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 ' .
|One Drive Login/Configuration Issue||12||36|
|hi all how do i achive this formula in condtional formatting excel||6||16|
|Change date stored as "short text" YYYYMMDD to MM/DD/YYYY?||27||20|
|macro modification Column C||14||19|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!