exporting sheets

I have hunted around and am losing my mind trying to figure this out. So I have the following code: Private Sub CommandButton3_Click() 'exporting to pdf Dim NamingPDF As String Dim MyFile As Variant Dim projectnum As String Dim Address As String Dim doneby As String Dim...

Hi, I'm using the following code to export and save a number of sheets from a master workbook (rngTM contains the names of worksheets i wish to 'export'.) One problem is that each sheet has a button with the task of refreshing the sheet..this works fine in the master but once i save in new...

Hi All, I have a macro to export worksheets from the workbook to the specified path( The location path is to be set in the macros). Problem - when I moved the macro enabled workbook to another location, i usally want to change the location path in the vba editor manually. Is there a function...