xfilename

I have a code that converts documents to PDF format. They are from a mail merge from an excel sheet. When you open the word documents it gives a pop up box and I need it to automatically click ENTER so it will continue. My code is below if anybody has any suggestions Sub ConvertWordsToPdfs()...

Hello everyone, I'm newbie at VBA but still learning :) I need a macro that combines every row from a worksheet to another one. Sample Files: https://www.dropbox.com/sh/17ukkp4dgnudle7/AAAF7GUewNXekZdkVvHh2xVFa?dl=0 In this files, you see 4 sample files and 1 combined file.. every file...

Good day friends, I have a macro which selects a folder and then makes a Dir list and counts the number of pages in the pdf. I am needing to replace the folder picker portion of the code with the static path of a folder. (This would prevent me from having to select the same folder every time)...

I want users to save a workbook as a macro enabled file by using this code: Sub StartFunctional () Dim FileSaveName As Variant Dim xFileName As String If SaveAsUI <> False Then Cancel = True xFileName = Application.GetSaveAsFilename(, "Excel Macro-Enabled Workbook (*.xlsm), *.xlsm"...

Hi Guys, I need your help. I'm using mac. I try to figured out for this code for change the old names of picture to new name. Here the the code: Sub PictureNametoExcel() 'UpdatebyExtendoffice201709027 Dim I As Long Dim xRg As Range Dim xAddress As String Dim xFileName As String...