application.run

  1. N

    Application.Run error

    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...
  2. M

    Running macro for another workbook - dosen't wrok

    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 &...
  3. S

    Application.Run with cell reference

    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...
  4. Q

    How to run macros on a different sheet.

    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...
  5. G

    calling macro from other file: the macro may not be available in this workbook or all macros may be disabled

    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...
  6. J

    Run XLAM from macro

    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...
  7. nuked

    Run macro in another workbook

    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...
  8. J

    Application.Run and variable number of arguments

    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...
  9. E

    Call a function in another Excel 2010 AddIn (.xlam)

    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...
  10. S

    Call function from another worksheet

    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...
  11. S

    Mystery Application.Run call; Macro Unknown

    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...
  12. A

    objExcel.Application.Run Parameter Syntax

    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...
  13. J

    Application.run problems... need help please

    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...
  14. B

    Pass variables between workbooks

    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...
  15. P

    Calling Private Sub from UserForm code

    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...

Some videos you may like

This Week's Hot Topics

Top