Forum Discussion
How to set path for files in SharePoint and OneDrive
Hi Excell community, I had some files that were local on my computer. I have migrated these files into my OneDrive and SharePoint. These files contain Macro code that I use to update the other fi...
If you open "PRUEBASTOC.xlsx" manually you can go to the VBA editor window (alt+F11) and in the immediate pane (control+g), you type this line:
?ActiveWorkbook.FullName
and hit Enter. The VBA editor will then display the full path and name of the file you just opened, which you can subsequently copy and paste on top of the current path in your macro. Repeat this process for the other file(s) in your code.
?ActiveWorkbook.FullName
and hit Enter. The VBA editor will then display the full path and name of the file you just opened, which you can subsequently copy and paste on top of the current path in your macro. Repeat this process for the other file(s) in your code.