[RESOLVED] Determine which computer is running Excel file

[Bezzie]

I have model in Excel that are run from two different computers (a desktop and a laptop). The model uses a file to import data that is located in a OneDrive folder. The path to that OneDrive folder differs on the two computers. I then have a Const that is set to the OneDrive folder so the model know where to find the file for the import.

Is there a way in VBA I can detect, at startup, which computer is running the model and then set the Const programmatically to the correct folder? Something like:

If 'Computer is Desktop' then
     Const FS_Intermediate_File as String = 'path to OneDrive folder on desktop'
ElseIf 'Computer is Laptop' then
     Const FS_Intermediate_File as String = 'path to OneDrive folder on laptop'
End If

Currently I change the Const declaration manually

[Arnoutdv]

Don't put in a Const but in a Public variable.

[jdelano]

You could use the Environ function to look at the computer name https://vbaf1.com/variables/environment/

If Environ("COMPUTERNAME") = "[your desktop computers name]" then
     FS_Intermediate_File as String = 'path to OneDrive folder on desktop'
ElseIf Environ("COMPUTERNAME") = "[your laptop computers name]" then
     FS_Intermediate_File as String = 'path to OneDrive folder on laptop'
End If

[Bezzie]

You could use the Environ function to look at the computer name https://vbaf1.com/variables/environment/

If Environ("COMPUTERNAME") = "[your desktop computers name]" then
     FS_Intermediate_File as String = 'path to OneDrive folder on desktop'
ElseIf Environ("COMPUTERNAME") = "[your laptop computers name]" then
     FS_Intermediate_File as String = 'path to OneDrive folder on laptop'
End If

Where would the best place be to put this code so that it executes on opening the workbook? Don't know what executes when

Not too worry. Found Workbook_Open

[jdelano]

There you go