Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi can anyone help me with this problem?
I have this dos script to pass down a parameter upon opening the excel @echo off start excel "\\136.121.2.1\its helpdesk\ConRisk\RSP Concentration Risk Calculation.xls" /e/8212305557 Is there any code to capture the parameter "8212305557" on the excel macro upon opening? I have tried this method but it gave me a kernel32 dll error on some pc. here is my code Option Base 1 Private Declare Function GetCommandLineA Lib "Kernel32" () As String Dim CmdLine As String 'command-line string Dim Args As Variant Dim ArgCount As Integer 'number of parameters Dim Pos1 As Integer, Pos2 As Integer Dim sMsg As String Dim Customercode As String CmdLine = GetCommandLineA 'get the cmd-line string CmdLine = Mid(CmdLine, 1, 255) On Error Resume Next 'for the wksht-function "Search" Pos1 = InStr(1, CmdLine, "/") + 1 Pos1 = InStr(Pos1, CmdLine, "/") + 1 Args = Split(Mid(CmdLine, Pos1, 255), "/") For ArgCount = LBound(Args) To UBound(Args) sMsg = sMsg & Args(ArgCount) & vbNewLine Next ArgCount Customercode = CStr(Trim(sMsg)) Can anyone help me with this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing parameter to a query | Excel Programming | |||
Using Find method in Excel passing more than 1 parameter | Excel Programming | |||
?Passing argument/parameter | Excel Programming | |||
Passing a parameter to Excel | Excel Programming | |||
Passing parameter from Excel to stored procedure? | Excel Programming |