Hi Experts,
Im trying to send mail using Mail MailEnvelope but the content is getting wrap after sending the mail like below image.
with my code im able to send mails using MailEnvelope. but excel content and table is getting wropped likw shwon in below picture... please help me to recitfy...
Hi Experts,
Iam working on a project ''Automation IE'', need your help on the same to copy element from ID and paste it in excel. Any help greatly appreciated.
Below is the VBA code so far.
Sub KBOSS_ARN_Profile()
Set browser = New SHDocVw.InternetExplorer
browser.Visible = True...
Iam working on a project ''Automation IE'' need help on the same.
I am trying to spool one excel report from website by giving From date and To Date are as inputs iam able to give enter dates with my code but after clicking on export button dates are disappearing..
Below is the HTML source...
Hi Experts,
Im looking for a code that can open excel files in a folder and add passwords to them
i have a excel sheet with files names with path in column A and passwords column B against each file name as mentioned in below image.. i want to open file1 and add password which is mentioned in...
Hi p45cal
Thanks for the code.. will check the same...i missed one point to mentioned in my earlier post.. ie.. i want to sort the data in descending order based on column-E.. i have tried for the same bate other columns not changing accordingly as per the the column-E..
Any help greatly...
Hi p45cal,
with below code im able to map column-F but after "F" im unable to map for dynamic range...
getting error ''' Method 'Range' of object '_Worksheet' failed''' on this lines
DestnSht.Range("MyHeaders" & j).Value = SourceSht.Range("rngSourceColumnHeaders" & i).Value...
Hi p45cal,
Thanks for the reply...i was out station without internet access thats why i didn't responded to your reply immediately...
in my latest sample column-A and column-D together are unique.. and these are always match with destination sheet column-A and column-D.. with these unique...
Hi p45cal,
your code is working perfectly but later i came to know that index formal is not mapping correctly.
iam using this in my actual file.. have attached my actual file for your reference... pls help on the same..
thanks in advance.
I am able to map column D with my code but i need to map rest of the non-blank columns also.
This is my code so far.
Sub FMEA_Consolidate()
Application.ScreenUpdating =FalseDim SheetName AsString
SheetName = Format(Date,"dd-mmm-yy")
''''''''''''''''''''''''''''''''''''''''Rename Last...
Hi Experts,
I am working on consolidation of all sheets and map previously consolidated status,
I have one code which is working perfectly till consolidation, now i need a code to vlookup a status from previous consolidated sheet to current consolidated sheet.
This is previous...
Hi Belleke,
Thanks for the response, your file is working perfectly.. i have modified gif path in your file and its working perfectly.. in the same way i have placed my code between waitfrm.show and unload waitfrm.. but when i run my code just white userform is coming gif animation is not...
Hi Experts,
I have macro which consolidate all sheets in one single sheet and i want to display animated gif while my macro is running. Please help with the code.. thanks in advance.
Hi Chihiro,
Hope your doing well...Thank for your response.. Please help me with the code for my same project...
Im working based on your idea and its under process.. while doing this im facing difficulty in next page where im trying to automation to spool one excel report from website and...
Hi Chihiro,
Hope your doing well...Thank for your response for my post.. Have tried with Shahins code with small changes and its working fine when user will enter value but still im not reached to my exact solution.. as i mentioned in my earlier post i need a code to get all the HTML dropdown...
Hi Chihiro,
yes but as i mentioned option list is dynamic, list is keeps increas, im gooing to thiis with my team they cant add list every time its increase..
Hi Chihiro,
Thanks for the reply.. I have gone through your links and found very usefull.
As mentioned in my earlier post is there any way to get all the options list from HTML source code into combo box so that user will select from the list and based selection next code should run.
Im...