Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form output naming
I would like to build a form in Excel and code VB to write
the data to an output file. (which I feel confident that I can do), but I would like to tie the output file name to the computer name. By computer name I am referring to the network computer ID, not the USER name from the office application. Is it possible to pull a computer's network name into VB? This might be possible with HTML forms using CGI scripts, but I don't know who to code CGI-BIN scripts. TIA, Collings |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form output naming
Collings,
You can get the computer name with the GetComputerName API function. E.g., Declare Function GetComputerName Lib "kernel32" _ Alias "GetComputerNameA" _ (ByVal lpBuffer As String, nSize As Long) As Long Function ComputerName() As String Dim CN As String Dim L As Long: L = 255 Dim Res As Long CN = String$(L, " ") Res = GetComputerName(CN, L) ComputerName = Left(CN, L) End Function -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Collings" wrote in message ... I would like to build a form in Excel and code VB to write the data to an output file. (which I feel confident that I can do), but I would like to tie the output file name to the computer name. By computer name I am referring to the network computer ID, not the USER name from the office application. Is it possible to pull a computer's network name into VB? This might be possible with HTML forms using CGI scripts, but I don't know who to code CGI-BIN scripts. TIA, Collings |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
format cell from data input to output form | Excel Worksheet Functions |