activeworkbook.name

Hi All, I have been trying to search in the existing threads for a solution to my question and cannot seem to find one. I am trying to create this generic SaveCopyAs macro to save a copy of my current file with the current date in a "Superseded" folder in the current directory where my file is...

Dear all, Hopefully someone here to help me out. I am using below code to store an excel sheet with ADO in an access database on a server. Is is possible to do such an ADO load to an Access database to a sharepoint location? If so what string do I need to use if the web address is like this...

Hi and thanks in advance! I have the following code: Sub AAA() On Error Resume Next: Application.ScreenUpdating = True 'ActiveWindow.Visible = True Dim wActWkb As String: wActWkb = ActiveWorkbook.Name Dim...

Evening Looking to remove the .xlsx from the export to PDF in the below script. Thanks guys Sub PDF()Dim wb As String Dim filepath As String wb = ActiveWorkbook.Name filepath = CreateObject("WScript.Shell").SpecialFolders("Desktop") & "\" & wb & ".pdf" ActiveSheet.ExportAsFixedFormat _...

I am running Windows 10 with Excel and I have a macro which manipuates an excel file, then ask the user to save as a different workbook name. The macro takes a copy of the ActiveWorkbook.Name of the main workbook and opens a reference excel file. When trying to switch windows back to the main...

Hi. I've been looking for a solution for at least an hour. I have this code: Private Sub EXPORTER_Click() If ActiveSheet.Name = "MODULES" Then Application.Run ActiveWorkbook.Name & "!QUESTION_EXPORTER_VERS_TECHNIQUE_MODULE" ElseIf ActiveSheet.Name = "ACCESSOIRES" Then...

Hello all - I'm receiving a "missing object" error in the below code. This is only a smidgen of much a much larger code which copies 100 text files into 100 worksheets. The range in File2 may vary, but will never be larger than A1:R55. Any assistance in having this copy/paste without...

Thanks for looking. I have some code for emailing that works very good but I have one change i would to make. I would like the subject to be Subject: Req activeworkbook.name This is a section of the code im needing to edit .CC = "" .BCC = "" .Subject =...

Hello to all, I am using ActiveWorkbook.Name in my macro, but it is returning the "dot" and file extension (e.g. ".xls"). I thought the .Name would give me just the filename with no extension. How can I get just the filename? Example: this_is_my_filename.xls would be this_is_my_filename Thanks!