Search results
25 maj 2017 · If you have a copy of the workbook open (in a different folder) with the same name as the one your VBA is trying to open, it fails silently. The ActiveWorkbook solution appears to work - as you have at least one workbook open already - and that is active - but its not the one you think it is.
14 gru 2015 · I'm having an issue with a VBA macro in MS Excel 2016 on Mac. When I open a file on a network share for Input, it opens and reads the file no problem. When I try to open the same file for Output, I get error 52: Bad file name or number.
29 mar 2022 · If the file specified by pathname doesn't exist, it is created when a file is opened for Append, Binary, Output, or Random modes. If the file is already opened by another process, and the specified type of access is not allowed, the Open operation fails and an error occurs.
23 wrz 2012 · Code: Application.GetOpenFilename (FileFilter:="Microsoft Excel Workbooks (*.xls;*.xlsx;*.xlsm)*.xls;*.xlsx;*.xlsm", Title:="Open Database File", MultiSelect:=False) Gives me Method GetOpenFileName of object Application failed (error 1004). I'm sure it is not far from working.
Excel is closed - I open a file by double clicking on it - my macro is executed successfully and displays my results. But if minimize this Excel-instance and open up another file my macro is not being executed again.
5 lip 2020 · Here two methods. Method 1. To have the code directly on the workbook VBA event panel as shown in the picture below. Method 2. To have the code on a regular module, or create a module if necessary with the Subroutine code to be run when the workbook is open as shown in the picture below i.e. Sub SayHello ()
29 mar 2022 · If the file cannot be opened in read/write mode, this argument is True to add the file to the file notification list. Microsoft Excel will open the file as read-only, poll the file notification list, and then notify the user when the file becomes available.
