• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Export ActiveSheet To A New WorkBook As Paste Values

A

Arun Raju

New Member
Hi all,

Can someone please help me with the code in the attached file for exporting an activesheet to a new workbook as paste values (excluding the code in the new workbook), then save the new workbook to a folder/location with the store name & go back to the master file to run the same process for 300 something stores.

At the moment, the code in the attached file does all the above but creates only pdfs (see below).

Sheets("Store Trading Report").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
Sheets("Macro").Range("J10") & ".pdf", Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
False

Appreciate your help with this code.

Many Thanks,
Arun
 

Attachments

Hello Arun Raju.

Can you give me more information..you want to export to pdf or new workbook paste special values version.

and you are referring to active sheet...which sheet?
 
You must log in or register to reply here.
Back
Top