Change Macro to save File with Pay Period Number & Pay Date

[Robert1960]

Here is my question: Is it possible to change a Macro save a file with Pay Period Number and pay Date? Here is the Macro I'm using Thanks for the help in advance.

Please Login or Register  to view this content.

[/CODE]

[mikeTRON]

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


Where is the Pay Date in the file if A1 is the PayPeriod.

Can you attach a sample workbook?

[Robert1960]

http://www.excelforum.com/attachment...1&d=1470685145 I don't have the Pay Date listed as yet...that is why I was asking how to change the Macro but here is a copy of my workbook

[Robert1960]

Can someone Please tell me how to rewrite my macro to save as pay period Number and Pay Date. Pay Date is in Cell A10 I would like to have it when saved show pay period number the word pay period with date after. Thanks in advance for any help.

Please Login or Register  to view this content.

[mikeTRON]

Please Login or Register  to view this content.

Assuming you want a dash between them.

[Robert1960]

This is the Run-Time error I'm getting when I run the macro you give me : Run-Time error '1004': This extension can not be used with the selected file type. Change the file extension in the File name text box or select a different file type by changing the Save as type. When I run the mouse over SaveAs NewFN it shows Pay Period 1-1/11/2016 Excel does not like the date format how can I change it to look like 1-11-2016?

Please Login or Register  to view this content.

[Robert1960]

I figured it out here are the changes I made from the above macro. Thanks for all the help

Please Login or Register  to view this content.