Thank you Kenneth for your help.
sorry, I missed the pw, I attached file after removing the pw.
PDF file saved in the same folder in path, same can be seen on search after copy paste path address in the search.
when I run the macro line by line with F8, .Display not bringing opening outlook, I...
Dear Kenneth,
Thank you for your time.
I checked the PDF file in the path, it is existing.
As required, please find the sample file attached here with.
Request your help on the same.
Thanks
Abaad
Dear Narayanan,
Sorry, I was sick and off for two days.
Thank you for your response
No error message is popping, just end the procedure within 4 second without any action.
already commented on On error..., still no error message.
I tried to debug the code, each time variable value I checked...
Dear Sir,
Can you help me please... vba code not working after upgrading office to 2016
https://chandoo.org/forum/threads/send-pdf-file-not-working-in-office-2016.36476/
Dear Friends,
I have below code to send PDF files from the path address given, it was working perfectly.
after upgrading to office 2016, it is not working at all. any help please...
Sub Send_Row_Or_Rows_pdf_Attachment_1()
If MsgBox(" Please make sure, you want to send the email to all the...
Dear PCosta,
Thanks for your reply.
it is pasting value of row 9 in entire row.
I wanted to paste value of 9 in below 16 times, then there is value in 62, that also to be copied and pasted just below 16 times.. and so on.
Hope I conveyed correctly.
Thanks
Abd
Dear Friends,
I am trying to write a code to copy cell value in a range if not equal to blank and paste below16 rows from active cell,after pasting one value it should go to next value in the range and do the same.
below code is doing the first task and not going next value. sample file is...
Dear Jindon,
Really great, working elegant.
I know little code, but it is bouncing to my head, create object is new to me.
is it possible to help to learn this
If Evaluate("isref('" & e & "'!a1)") Then dic(e).Copy Sheets
Thanks
abd
Friends,
I have attached sample file with code, where the sheet name is mentioned in C, I wanted copy value1, value2, and value3 and paste in concerned sheet in 25th row. I tried with lot of change. not succeeded this case.
Appreciate your help
Dear Jindon,
thanks for your reply.
in your solution if there are five lines to copy to concerned sheet, it copy all five line in 25th row replacing the first value, so only last value remain cell
Dear Derek,
Thank you for your reply.
in your solution if there are five lines to copy to concerned sheet, it make the gap of 25 rows between each line.
Thanks
Abd
Dear Friends,
I have below code to copy the data and paste in concerned sheet, sheet name is mentioned Sheet98.Range("C12:C137"). this is perfectly working, currently it is pasting in the second row of concerned sheet, I wanted paste data 25th row of concerned sheet, I am trying to change the...
Dear Sir,
Amazing...Thank you so much for your help. much appreciated.
Yes, Data should break by column D.
currently it is copying 19 rows one by one and printing without break.. below change is required in the code
-it is to break by Column 'D'.
Total in "I34" and count in "G34" at each...
Dear Sir,
You have helped many time, can u please help on below too
http://forum.chandoo.org/threads/copy-the-20-line-item-and-paste-in-a-format-to-print.32884/
Dear Monty,
Thank you for your help..
it just copy 20 line one time, please find the below requirement already detailed in the last email.
- If field Entry Number of Sheet Data in total 19 rows or below, it should copy that rows and Print. total count should come in G34 and sum in I34. Page...
Thank you for your reply PCosta.
Please find the attachment, I have data listed in the Sheet named Data.
I wanted to bring the data in Sheet <Format> and print by field Entry Number.
In the Sheet Format can accommodate 19 rows, therefore If field Entry Number of Sheet Data in 19 rows or below...
Dear Experts,
I am stuck with something, would be really helpful if a solution.
I have data in A2:L5000 in sheet1. in column 'I' it is 'Amount' and in Column 'D' it is 'Entry number'
In sheet2 I have format set with letter head which can accommodate 19 row.
I wanted to copy each 19 rows from...
Hi friends,
I have number trillion and million in a column and make it to the chart. the follow code pasted in the format cell custom- working fine for million and billion. Please help me how do i get it work for trillion too.
[>999999999.999]#.0,,, _-"B";[>999999.999]#.0,, "M";#,##0...
HI,
I have below custom to display B instead of billion an M and instead of million. could you tell me how to add trillion also to this
[>999999999.999]#.0,,, _-"B";[>999999.999]#.0,, "M";#,##0 _M
Regards
Abdul
Dear Hui,
Thanks for this. Second link is half suitable for me. this is extracting to different workbook. i wanted to extract in different sheets in the same workbook which already available with name of filtering value. Please advice
Thanks
Abdul