{"action":"created","issue":{"url":"https://api.github.com/repos/jpimbert/VBAToolKit/issues/38","labels_url":"https://api.github.com/repos/jpimbert/VBAToolKit/issues/38/labels{/name}","comments_url":"https://api.github.com/repos/jpimbert/VBAToolKit/issues/38/comments","events_url":"https://api.github.com/repos/jpimbert/VBAToolKit/issues/38/events","html_url":"https://github.com/jpimbert/VBAToolKit/issues/38","id":57982556,"number":38,"title":"Create Project Isn't Working for Me","user":{"login":"DarylMcCullough","id":8592134,"avatar_url":"https://avatars.githubusercontent.com/u/8592134?v=3","gravatar_id":"","url":"https://api.github.com/users/DarylMcCullough","html_url":"https://github.com/DarylMcCullough","followers_url":"https://api.github.com/users/DarylMcCullough/followers","following_url":"https://api.github.com/users/DarylMcCullough/following{/other_user}","gists_url":"https://api.github.com/users/DarylMcCullough/gists{/gist_id}","starred_url":"https://api.github.com/users/DarylMcCullough/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DarylMcCullough/subscriptions","organizations_url":"https://api.github.com/users/DarylMcCullough/orgs","repos_url":"https://api.github.com/users/DarylMcCullough/repos","events_url":"https://api.github.com/users/DarylMcCullough/events{/privacy}","received_events_url":"https://api.github.com/users/DarylMcCullough/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jpimbert/VBAToolKit/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-02-17T21:11:02Z","updated_at":"2015-02-18T00:09:43Z","closed_at":null,"body":"I am trying to use VBAToolKit, and it is failing at the very first step. When I try to create a new project, it seems to work (I see the created files) but I get an error message:\r\n\r\nError 1004 (application-defined or object-defined error) in procedure vtkCreateProject of Module Mainfunctions.\r\n\r\nI'm not sure if it's relevant, but I'm using Excel 2013."},"comment":{"url":"https://api.github.com/repos/jpimbert/VBAToolKit/issues/comments/74784017","html_url":"https://github.com/jpimbert/VBAToolKit/issues/38#issuecomment-74784017","issue_url":"https://api.github.com/repos/jpimbert/VBAToolKit/issues/38","id":74784017,"user":{"login":"DarylMcCullough","id":8592134,"avatar_url":"https://avatars.githubusercontent.com/u/8592134?v=3","gravatar_id":"","url":"https://api.github.com/users/DarylMcCullough","html_url":"https://github.com/DarylMcCullough","followers_url":"https://api.github.com/users/DarylMcCullough/followers","following_url":"https://api.github.com/users/DarylMcCullough/following{/other_user}","gists_url":"https://api.github.com/users/DarylMcCullough/gists{/gist_id}","starred_url":"https://api.github.com/users/DarylMcCullough/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DarylMcCullough/subscriptions","organizations_url":"https://api.github.com/users/DarylMcCullough/orgs","repos_url":"https://api.github.com/users/DarylMcCullough/repos","events_url":"https://api.github.com/users/DarylMcCullough/events{/privacy}","received_events_url":"https://api.github.com/users/DarylMcCullough/received_events","type":"User","site_admin":false},"created_at":"2015-02-18T00:09:43Z","updated_at":"2015-02-18T00:09:43Z","body":"Okay, I managed to get past this problem, but it required another change: the semicolons needed to be replaced by commas. I'm not sure whether that's a difference between the French and English versions of VBA, or whether they mean something different, but I got it to work by replacing the line by:\r\n\r\n> m_referenceSheet.Cells(1, newColumn).FormulaLocal = \"=INDIRECT(ADDRESS(1,\" & newColumn - nbTitleColumns + m_nbTitleColumnsInConfSheet & \",4,1,\"\"vtkConfigurations\"\"))\""}}