Export sheets and save in PDF & Excel Individual

[Nabeel]

Dear All

Required Two VBA (For excel and pdf)
i want to export the sheet base on Column F and save in said folder
path: C:\Users\nabeelak\Desktop\final\

and sheet save with name of company name which is in column F, special character auto replace with (-) and pick frist two words of whole name.
Nabeel

 

[Derek McGill]

What code have you used to try to achieve what you want ?

 

[Nabeel]

What code have you used to try to achieve what you want ?

i want individual sheets base of column F in pdf and excel.?

 

[vletm]

Something like this?
Run that Macro!
You would name Your path Yourself!

 

[Nabeel]

Something like this?
Run that Macro!
You would name Your path Yourself!

yes Vletm, i want like this but sheet are saving like XXX_AA i want to save with company name with first two word which is in column F and its not exporting all sheet, its exporting only 50 files than showing run time error actually has total 78 companies..
can it possible that like saving path, ask in which i want to export in pdf or excel or both..??
Nabeel

 

[vletm]

1) XXX_ was my test 'pre' that I can easy delete those files!
2) All Files ... if You wrote that 'first two words' ... ooo ... not 2 first letters ;(
> now two first words (including letters A..Z only)
3) path? I asks path and as written in code, You could change default path!
... and You wanted to use ONLY ONE PATH ... I add paths questions for both.
4) I don't get any run time errors ...
5) I didn't test all variations!

 

[Nabeel]

superb vletm, you are great sir..
i wrote two word because of that file name letters cannot be more than 31 letter and in file most of names are exceeding butt this is great, some of saving file word like only B T and E P.? and second VBA (Macro2) i run but didn't see any change (is it need to be run) and where i can put for autofit column Code

Application.ActiveSheet.Columns.AutoFit

Nabeel

 

[Nabeel]

Dear vletm,
just for learning and understanding, i am trying to change the column From F to D, i made some changes but don't work kindly can you resend this sheet with essential changing & also make auto fit column..thanks

Nabeel

 

[vletm]

... hmmm ... my yesterday version didn't send from here ...
this is yesterday's updated
... I'll check next today's version

 

[vletm]

You could have both filename-versions with this sample...

 

[Nabeel]

Dear sir vletm, lot of thanks
this is awesome, perfectly working, superb work

Nabeel

 

[ferocious12]

Hi All,

I have multiple PDF files (invoices) saved in a folder and I want to print each PDF file in separate excel worksheet within one workbook. Any help ?

The aim is ease of access to PDF invoices as these are scanned and I have to summarize information from each invoice in an excel sheet.

Thanks