Search results

  1. V

    Saving a new file using the same filepath

    Hi Those are the lines that I have tried to use to get the protected file to create a new workbook in the same folder as the original file – but they didn’t work. I left them there so you could see what I had tried. The code that is uncommented works in an unprotected workbook perfectly – so...
  2. V

    Saving a new file using the same filepath

    Hi Are you referring to any lines in particular or all of those that are commented – it is a bit hard to follow your post as the code seems to have been split up into sections and some parts are grey and other white? What I sent you in my Email works in a standard excel set-up. The parts...
  3. V

    Saving a new file using the same filepath

    Hi Below is the full code which is contained within a UserForm – I have highlighted where I’ve tried to update the code to still work with XLS Padlock: - Private Sub cmdExport_Click() Dim i As Integer, sht As String Application.ScreenUpdating = False Application.EnableEvents = False 'save...
  4. V

    Saving a new file using the same filepath

    I’ve been struggling with this for a long time and wondered if anyone else has come up with a solution? Basically I am trying to save a new file using VBA but want it to be saved in the same file as the original exe file. In a standard Excel file the following code works: - Dim Fnme As String...
  5. V

    Saving with a new filename using a UserForm

    Hi Have you got any updates on this addition to your programme? Thanks Vince
  6. V

    Saving with a new filename using a UserForm

    Hi Do you have any idea when you are likely to add this feature to your programme? Without it I cannot really use it to protect my spreadsheets so an idea of timing would be very helpful. I look forward to hearing from you. Regards Vince
  7. V

    Saving with a new filename using a UserForm

    Hi I am not trying to create a protected workbook using VBA - I just need to reference the .xlsc filename. Basically I have a macro which enables the user to select from the range of open worksheets - these worksheets are then exported to a new file but it is only the formats & values which are...
  8. V

    Saving with a new filename using a UserForm

    Hi - I have corrected my code as follows: - Dim PathtoFile As String Dim xlspadlock As Object Dim Fnme As String Set xlspadlock = Application.COMAddIns(“GXLSForm.GXLSFormula”).Object PathtoFile = xlspadlock.PLEvalVAR(“EXEPath”) With ThisWorkbook Fnme = PathtoFile & Left(ThisWorkbook.Name...
  9. V

    Saving with a new filename using a UserForm

    Hi I am trying to generate a new file which is created by the user using a UserForm where they select which sheets they want copied to the new file. The new file is saved in the same folder as the original file. The code that works in a normal version of Excel is as follow: - With ThisWorkbook _...
Back
Top