Files Imported from/to Access database not placed in specified vba_folder

[fabrizionastri]

Issue Description: When using the "XVBA - Live Server VBA" to edit VBA code for an Access database, the files aren't placed in the directory specified in the config.json file: "vba_folder": "vba-files".

• The files located in vba-files folder are sucessfully exported to Access, and I can find them in the Access VBA Editor.
• However, when I import the files from Access to VSCode using the "Import - VBA" button of the in the XVBA extension, the are instead located in the C:\Users\<USERNAME>\AppData\Local\Temp folder.

Steps to Reproduce:

1. Open VS Code and install "XVBA - Live Server VBA" in VSCode (v4.0.30)
2. Create a new project folder : C:\Users\<USERNAME>\Repos\\MSAccess-XVBA-Test
3. In the XVBA extension menu in the VSCode activity bar, click on "Boostrap XVBA Config" to create a new project, and select "Create Access Project"
   • This will created the following files and folders in the project root:
   • with the following config.jsonfile:

     {
     "app_name": "XVBA",
     "description": "",
     "author": "",
     "email": "",
     "create_ate": "Mon Aug 28 2023 11:45:21 GMT+0200 (Central European Summer Time)",
     "excel_file": "index.accdb",
     "vba_folder": "vba-files",
     "ribbon_file": "customUI14",
     "ribbon_folder": "ribbons",
     "logs": "on",
     "xvba_packages": {},
     "xvba_dev_packages": {}
     }

4. Ensure the vba-files directory exists in the root folder of the repo and is empty.

5. Open the "index.accdb" database, and create a new modul with a VBA subroutine, for example:

   Sub TestFromAccess1()
   
   MsgBox "TestFromAccess1"
   
   End Sub

6. In the XVBA extension menu in the VSCode activity bar, click on "Import - VBA" to import the code from Access
7. Observe that the imported files aren't placed in the vba-files directory.
8. Check the logs\excel_import.log file and find the following line: "28/08/2023 12:56:50 - DEBUG:Export VBA files from Access to C:\Users\\AppData\Local\Temp\xvba_files finished. ".
9. Go to that directory, and observe that the files are not there, but instead are located in "C:\Users\\AppData\Local\Temp"
10. Go back to VSCode, create a new file with new sub (eg. TestFromVSCode2") and save it:
11. In the XVBA extension menu in the VSCode activity bar, click on "Export VBA" to export this code to Access, and select "Build" (the other 2 options and give the same result)
12. Go back to Access and open the VBA Editor (Alt+F11), and note that the previous code with TestFromAccess has disappeared, and has been replaced by the new one from VSCode.

13. This code runs successfully when launched from within Access, but not when launched within VSCode

Expected Behavior: The VBA files should be imported from Access to the vba-files directory in VSCode as specified in config.json. Any changes made there should then be exported back to the Access database

---

Actual Behavior: The VBA files are imported in C:\Users\<USERNAME>\AppData\Local\Temp folder instead of vba-files directory.

---

Additional Information:

• VS Code Version: 1.81.1
• XVBA Extension Version: v4.0.30
• Operating System: Windows 11 Home
• I've verified that the path is correct and that the vba-files directory exists.
• There are no errors in the XVBA logs that indicate a path problem.

[word-x]

I got the same issue.

When I tried to import VBA code from Excel, the .bas file was not generated in vba-files folder. It was placed in: C:\Windows\Temp\xvba_files.

It should be generated in project_folder/vba-files.

Environment: 1.Win10, Office 2019 2.Latest VS code (I downloaded today)

[word-x]

@fabrizionastri Did you fix it? It seems a bug. I've tried various versions of this extension, it has the same issue. Very appreciated if someone could give me a hint.

[fabrizionastri]

No I did not fix it.

@Aeraphe : Hello, are you aware of this issue ? Are you still mainting this extension ? I would appreciate any help.

[Zimbaner]

@word-x @fabrizionastri Did you fix it? I've the same problem.