application.run

Hi Everyone, I'm quite certain this is a bug and there's probably no fix however I thought it would be worth asking. My issue is that even though I have the "Make Unconstrained Variables Non-Negative" box ticked, it's still using negative variables and crashing the equation! The solver works by...

Hi all, I am writing a macro that has to open another workbook (wb2), run a macro in wb2, copy some data and paste it to the first workbook. However, given it takes some time for Application.Run to actually populate the excel cells in wb2, it seems like the macro i am writing selects the range...

Hi all, As you know, when passing an argument ByRef the Callee procedure code can change the value underlying the argument in the calling code as shown in the following example : Sub Caller1() Dim X As Long X = 1 Call Callee(X) MsgBox X ' returns 2 End Sub Sub...

Hi everyone, I am trying to run the same macro several times, but keep getting the error: The macro may not be available in this workbook or all macros may be disabled. I have enabled everything, so not sure what I am missing. The "Enter" button is in a userform. Private Sub...

Hi I have a macro that is to run three macros in another file Two of them run fine but the third I get an error on This is the code for running the macros Workbooks.Open Filename:=FileNameFolder & xlsmFile Application.Run "'" & xlsmFile &...

Hi, Help!! I am trying to call a Macro from another workbook names "My_Data by xxx_19 Nov 16.xlsm". I have refrenced the name of this file in Cell F3 and Name of the Macro in Cell H3. Application.Run (Range("F3").Value & "!" & Range("H3").Value) gives me the following error: Run-time error...

I have three sheets with the following titles "Total", "Inpt", and "Outpt". I've got three individual macros that reformat each sheet. However, they only work when I'm on the sheet I'm reformatting. I would like to create one macro to run all of them from the "Total" tab. I've tried...

I am running a macro that is calling a macro from another file. however, everytime i receive this error message: can not run the macro '' the macro may not be available in this workbook or all macros may be disabled I tried many codes but it still does not work, any suggestion? here you can find...

Hello, I'm trying to run an XLAM file from a macro. Using the run method I get the following error Run-time error '1004': Cannot run the macro (filepath) The macro may not be available in this macro or all macros may be disabled. I'm quite familiar with VBA, but am just starting with .xlam...

Hi All, I currently have a routine (Excel 2007) that opens another workbook (Excel 2003) and runs a routine within it: Application.Run "MyWorkbook.xls!MyRoutine" Is it possible to pass parameters to MyRoutine, and, be able to get a return value using application.run method? I'm struggling...

Hello again guys, So I have an error handler that formats cells displays a variety of different error messages depending on where the user is in the process: sSubs is either a string or array of strings containing macro names that will be run. iPhase and iSteps are for identifying what stage...

Hello all! I try to call a function/procedur in an Excel2010-AddIn (.xlam file) from another Excel2010-AddIn (.xlam file): Application.Run (filename.xlam!functionname) Both AddIn-files are in the same directory (the default AddIn directory). This call causes the error message "runtime error...

Hi, having a problem calling a function with multiple arguments in a macro. The function is contained within another worksheet. The function is this Public Function PoleCam(UpType, DType, PLength). It is stored within MacroWorkbook.xlsm and the first few lines of the macro I am using to call...

Hi everyone, I'm looking after some huge Excel apps made by someone who has left the organisation, which no-one else knows anything about.. This one simply falls down on an app.run call, custom error message is: "Macro 'sxlReadItems' does not exist." The thing is, i've logged on to the...

Calling Excel from Word.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have a sub in Excel called ChooseRegion, Excel syntax:<o:p></o:p> ChooseRegion 2<o:p></o:p> Or <o:p></o:p> Call ChooseRegion(2)<o:p></o:p> <o:p></o:p> I have a Sub called Reset which...

Hello all you expert experienced and helpful users! I am trying to use the Application.run statement to call a macro (MaterialReportWE) within the same workbook and it is not running. I can't see any spelling errors but when I open the Macro dialog box it shows the macro with the workbook name...

Hi! Please help me on this issue. I have 2 workbooks ' B1 workbook Public Sub UniqueName(params) MsgBox params(1) MsgBox params(2) params(3) = "OK" End Sub ' B2 workbook Sub CallAnotherSubroutine() ' Array required to pass parameters Dim params(1 To 3) As...

I have a macro in a workbook with code in the Open event that opens a workbook: daily.xls In the daily.xls file there is a UserForm with code. In the UserForm code there are private subs. (private sub name: Update) How do I have my initial workbook open the daily.xls file and run the private...