{"id":3265,"date":"2021-04-25T09:07:49","date_gmt":"2021-04-25T16:07:49","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3265"},"modified":"2021-04-25T09:07:51","modified_gmt":"2021-04-25T16:07:51","slug":"how-to-get-current-working-directory-using-vba","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3265","title":{"rendered":"How to Get Current Working Directory Using VBA"},"content":{"rendered":"\n

Use Application.ActiveWorkbook.Path<\/strong><\/code> for just the path itself (without the workbook name) or Application.ActiveWorkbook.FullName<\/strong><\/code> for the path with the workbook name.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

CurDir()<\/strong><\/code> is also very useful in some circumstands <\/p>\n\n\n\n

For example,<\/p>\n\n\n\n

When you open an Excel document D:\\db\\tmp\\test1.xlsm<\/code>:<\/p>\n\n\n\n

  • CurDir()<\/code> returns C:\\Users\\[username]\\Documents<\/code><\/li>
  • ActiveWorkbook.Path<\/code> returns D:\\db\\tmp<\/code><\/li><\/ul>\n\n\n\n

    So CurDir()<\/code> has a system default and can be changed.<\/p>\n\n\n\n

    ActiveWorkbook.Path<\/code> does not change for the same saved Workbook.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Use Application.ActiveWorkbook.Path for just the path itself (without the workbook name) or Application.ActiveWorkbook.FullName for the path with the workbook name. CurDir() is also very useful in some circumstands For example, When you open an Excel document D:\\db\\tmp\\test1.xlsm: CurDir() returns C:\\Users\\[username]\\Documents ActiveWorkbook.Path returns D:\\db\\tmp So CurDir() has a system default and can be changed. ActiveWorkbook.Path does not change for the same saved Workbook.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[697,699,696],"class_list":["post-3265","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-get-current-directory","tag-get-current-path","tag-get-current-working-directory"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t