xfilename

  1. F

    VBA line to automatically click ENTER in script

    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()...
  2. G

    Combining rows from multiple workbooks to one workbook

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

    Replace File Dialog Picker with Path

    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)...
  4. D

    Variable not defined error

    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"...
  5. J

    Rename the pictures using excel

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top