| mail3@sysmod.com 2006-04-25, 6:54 am |
| It might be easier to record a macro and then change it.
Tools > Macro > Record New Macro
Name PasteHTML
Shortcut Ctrl+Shift+V (or some other key you don't already use)
Store Macro in: Personal Macro Workbook
Click OK
Switch to a web page and copy some text
Switch back to Excel
Edit > Paste Special > Text
Click Stop Recording on the macro toolbar
Window > Unhide > Personal.xls
Tools > macros > macros
Select PasteHTML, click Edit
change the line to read
ActiveSheet.PasteSpecial NoHTMLFormatting:=True
File > Close and return to Excel
Window > Hide
File > Exit and save changes to Personal.xls
I'd also recommend a good book on learning VBA such as John
Walkenbach's, see
http://www.sysmod.com/spreads.htm#Books
Good luck,
Patrick
|