Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
We are migrating from XCL 2003 to XCL 2010. The macro file resides on
a shared network drive. I am having difficulty getting the macro code to "recognize" (extracting email parameters from the INI file; to be used for the macro to send an email) the INI file. Each user has his customized INI file stored on his H:\ drive. These are my five unsuccessful attempts: 1) Public Const INI_PATH_TMPL = "H:\<USER_ID\My Documents\INI File\" 2) Public Const INI_PATH_TMPL = "\\ServerName\<USER_ID\My Documents \INI File\" whe 'sUserID = (Environ$("Username")) '<< THIS IS THE WIN 7 CODE FOR ANY GIVEN USER 'GetUserID = Replace(sUserID, "corp\", "") 'GetINIFilename = Replace(APP_INI_PATH, "<USER_ID", GetUserID) 3) Public Const INI_PATH_TMPL = "H:\My Documents\INI File\" 4) Public Const INI_PATH_TMPL = "H:\loginID\My Documents\INI File\" 5) Public Const APP_INI_PATH = INI_PATH_TMPL & "Email.ini" Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
double click excel file on the desktop excel opens but not file? | Excel Discussion (Misc queries) | |||
Connecting to a DB without using the local machines ODBC | Excel Programming | |||
Stoping users from saving tables to their local machines... | Excel Discussion (Misc queries) | |||
Local excel file to update website | Excel Programming | |||
Desktop shortcut to a named Excel file - every time I open it adds a "1" to the file name - how to disable? | Setting up and Configuration of Excel |