john_w

  1. H

    invoice number based on date and with caracters

    Hello Guys , i have this VBA code that generates auto invoice number , i could not change the code so that it increment the left 3 numbers by 1 , and check if month and year are correct my invoice number is : 001/mm/yyyy , 001 is the reference of the invoice Sub NextInvoice()...
  2. R

    Automatic mail sending from lotus mail on the basis of data received in the email

    Dear All, How are you? Currently , I am working on this following project and was able to achieve the target about 50 percent on click of buttons by assigning particular codes, but not as desired to do it automatically. Below is the requirement. If a particular mail from a particular mail id...
  3. R

    Fetching data from website and feed it in the desired cells

    Dear, Please help me out to retrieve data from this website and feed those data into the excel Any help will be appreciated . I am trying on this below codes, but not getting the success Sub Scrape_Stats() 'Create Internet Explorer Browser Dim appIE As Object Set appIE =...
  4. G

    Generate Word Documents (in Excel VBA) from a series of Document Templates

    Hey all. I'll try to make this brief and simple. :) I have 40 or so boilerplate word documents with a series of fields (Name, address, etc) that need to be filled in. This is historically done manually, but it's repetitive and cumbersome. A workbook where a user has filled a huge set of...
  5. S

    excel vba to extract html info from websites

    Hi I'm trying to figure out how to get html data from websites into excel sheet using vba. I've been looking around for hours specifically trying to figure out how to get pagename and pageid values (to start, I want to get a lot more than that after like website images etc...). There seems to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top