Code: Save file in excel & Pdf at 2 different locations

Hi Folks,


I am not good in coding and need your help in writing a code to solve my problem below.
I have a form in excel for assessing community projects for approval. I am thinking that whenever someone wants to start a new project must submit this assessment form.
When someone fill the form and click on save button it should save file name, picking from Cell C1, at 2 different locations in PDF & in excel. it should also clear the form and generating a new file# in C1 at the same time for next person to fill.

Please find attached file.

Once again thanks for help.


Ray

I found the code below for saving in pdf and it saves as PDF with same file name....see attached updated file
but I want to save in pdf and in excel both at 2 different locations (pdf at one location & excel at other location) with file name picking from Cell C1 and after saving it auto generate another file # in Cell C1 and clear the form for next person to fill.

I really appreciate if you help me out.....

Regards

Ray

Thanks Blokeman!

I really appreciate your help and sparing your valuable time to write this code for me. It saves file in my document in both pdf and excel format. It solve my half problem. It will be great if you help me and write a code that save pdf file in my pdf folder and excel file in my excel folder at desktop.

Regards

Ray

Still waiting for some excel expert help........

Thanks Blokeman! I tried the above mentioned code but didn't work.
Can you please double check for me?

Thanks

As explained, you will need to insert the name of your folder. If it is a shortcut to a folder, it is another matter.

If you know the foldername, just concatenate that name to this to get the full path to the folder on your desktop.

Please Login or Register  to view this content.

Hi Blokeman,

It's nice to see you online. I tried to use your code but didn't work. I think i am making some mistake. Please find attached file and fix it for me.

Thanks

Ray

You are right. Thanks
I really appreciate your help.

Now when I save it saves in 2 different location (One in PDF and other in excel having name pick up from File # 25001) gr8

Is it possible when I save it, it also clears the form and close it? But when I open again this(Book1) file, it open with new file # .

Once again thanx for all your help. I hope you spare sometime and solve my next step.

Regards

Ray

Wow Thanks Bolkeman! It's amazing how little codes work in an effecient way.
It really work great but I think I forgot to tell you that saved file shouldn't lose data in it.


Problem: When I open saved excel file in excel folder, it clears data and it also increament number in C1.

It's great for my original project form to act like that.

When I filled PROJECT FORM and saved -> It saved file in excel & pdf formats in 2 different location(gr8)
When I opened Saved Excel PROJECT FORM with unique file # (C1) -> it acts same as my original form (clear and increament) I lost my project data


What I want: when I open my saved excel file in excel folder, it should have same File # (C1) AND all data filled in it.

My purpose is that whenever I filled the for new Project Form it should have unique file # (C1). And when I saved it, I should have to copies of it one in PDF and one in Excel (having unique file #) saved in 2 different location.
And whenever I want to see my previous saved file in excel for any modification I should have that Excel filled form saved in excel folder.
but now when I fill the excel form and save, it saved in excel & pdf in 2 different locations and when I open my excel saved file it cleared my data.
I hope you understand and help me out.

Thanks for all your time and care

Ray

Great, Thanks Bolkeman

It saves well in both format and keep the data in saved excel file!
But it doesn't clear the original form for next time to fill.

Once again thanks

Ray

Gr8!

Thanks Bolkeman, you are really good in coding.

Sorry Blokeman,

I misspelled your name!

Thnx Once Again