1st question...Why does it have to be USB? 2nd...Can it be USB to Serial? If so then you should use a FT232R USB to serial converter IC then goto this link and figure out the rest http://www.lvr.com/serial_ports_dotnet.htm
This way you communicate to the Microcontroller through a serial Com port and dont have to dink with the USB mumbo jumbo.
This method works well for me and its fairly easy to understand.
What you are asking for it to do is not hard if you break it apart into parts:
1) Read data from EEPROM Byte by Byte and send it serially to VB and buffer it there in a variable
2) Take the Variable in your VB Prog and format it however you want and dump it to Excel
Bookmarks