D Dan Sep 18, 2003 #1 Is there a way that when i open an excel spreadsheet that it will delete the first row automatically
D Dan Sep 18, 2003 #3 im very good with access but dont know excel that well where do i put this code in how do i get to the code?
im very good with access but dont know excel that well where do i put this code in how do i get to the code?
T Tom Ogilvy Sep 18, 2003 #4 Alt+F11 gets you to the visual basic editor. With your workbook as the activeproject (should be highlighted in the project explorer), Insert=>Module from the menu (in the vBE). Put the code in the module.
Alt+F11 gets you to the visual basic editor. With your workbook as the activeproject (should be highlighted in the project explorer), Insert=>Module from the menu (in the vBE). Put the code in the module.
