Workbook path when using Add-In

[jomili]

Okay, I have 3 macros below for saving things. In each I originally had "ThisWorkbook.Path", in the macros, but each one instead of saving to Active workbook path saved to where the Add-In lives. So I went looking for help, and ran across this:http://www.techrepublic.com/blog/mic...-excel-macros/
So, I changed to "ActiveWorkbook.Path". Guess what? All 3 macros STILL save to where the Add-In lives. HELP!

Please Login or Register  to view this content.

[MrShorty]

May need a sample file. I have a similar macro in my macros collection, and I have not experienced the same problem. Relevant code

Please Login or Register  to view this content.

The only trouble I have ever had is in the case of brand new workbooks before they have been saved where the workbook doesn't have a path, yet.

I would probably put a "stop" statement after your "filename = ActiveWorkbook.Path & "\textfile-" & Format(Now, "ddmmyy-hhmmss") & ".txt"" statement (maybe earlier). Then, when VBA enters debug mode, I would check to see what is going on. What value has been stored in filename? What workbook is active?

[jomili]

Sometimes my level of stupidity astounds me. The workbook I was testing on sits in the same folder as my add-in. D-Uh! Sorry.