Search results

Hi Friends, how to extract the specific data from pdf files to excel through vba code i have try to many ways still i could not the way. please assist me. Regards, Saran.K

Hi Friends, how to copy text from pdf to excel using vba. if you have any idea please let me know. Regards, Saran.K

] Hi Vletm, Thanks for your response.No, i don't want data validation concept.i just need 'B' Column we enter the information something the same row 'A' Column is empty that time we need error message. like this Please fill the 'A' Column Regards, Saran.K

Hi Friends, I need your help.Actually we have one excel sheets. Column 'A' and Column 'B' is mandatory column. but Column 'B' user enter the information automatically showing the error message box. we should not use the button or shortcut key. Regards, Saran.K

hi thank you for your response .Now i instal the winscp. how to download the file from winscp(SFTP) through Excel VBA

hi thank you for your response .ok i will try Winscp. But Now i have SFTP (Filezilla) Application only. i was explore in google but still i did't get the answer. if you have any idea please let me know.

Hi All, how to download the file from Filezilla (SFTP) through vba code. Regards, Saran.K

Hi Friends, I need small help.Already i have created one macro file auto email from excel to mail but i don't know how to create particular date and time ?could you tell me. PFA for you referce

Dear Friends, How to resolve the the below condition Each row in the excel file with have multiple columns that will populate various points of the word pdf file. Each row represents a new file that needs to be generated Regards, Saran.K

Thank you so much

This was i expected thank you but table header will not come.how to resolve this?

Hi friends, i have used Please find below mention query.but that code some issue. i am using SQL server management studio.how to resolve this? Sub aa() Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Dim sConnString As String ' Create the connection string...

Hi Friends, I am try to this way but i did not get the answer. i need progress indicator. Kindly help me Regards, SaranK

Hi Narayan, Really thank you Ragards, Saran.K

Hi Friends, I was run the Vlookup vba code if any error throw the same lookup (First) value that value highlighted any one color. but error appeared Please find below mention code. highlighted error bold letter Code: sub aa() Range("a:a") =...

Hi Friends, i have write a word one column one by one.in string between one special character ex: sa?ran, arun/kumar. i will be highligted that word .what kind of VBA code used. FYI Please find attached to the file

Hi friends, how to highlighted special character in one column using vba code Regards, Saran.K DUPLICATED!

Thank for your response. Lot of thanks Regards, Saran.K

Hi, how to change in color special characters in excel one column using vba Regards Saran.K

Hi friend, Thanks for your response.i have tried to that way but no output. Please find attached the file. first you will click the button.then file automatically will be go to the busy mode.that time i need status bar progress level. Thanks. Saran.K

Thanks but i want status bar ex: 10% then 50%

Hi Friends, i was run the macro file but excel sheets going to the busy mode. so i want progressing bar.what type code can be use kindly Explain. Regards, Saran.K

Thanks

Hi Friends, More than same records in single column but that related row various details.i want single line PFA example file.kindly help me (formula wise or vba wise) regards, Saran.K

Hi Chirayu, This is sample file. in first page you can generate the error report.