Results 1 to 2 of 2

Thread: VB and Excel

  1. Jun 26th, 2000, 06:33 PM #1
    JP
    JP is offline

    Thread Starter
    Junior Member
    Join Date
    Jul 1999
    Posts
    16
    I have an Excel spreadsheet with 2 worksheets in it. What I want to do is add a VBA macro to delete the contents of worksheet 2 and automatically open a delimited text file into it (i.e. a refresh of the data). How do I do this? There is no Worksheets("Sheet2").Open command.

    I am using Excel 2000 but it also has to work on Excel 97.

    Any help appreciated.

    Many thanks
    JP
    Reply With Quote Reply With Quote
  2. Jun 27th, 2000, 01:06 AM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    Easiest way of makin' Excel macros is to record 'em. Turn on recording, do what you want the Macro to have, turn off recording and copy the resulting commands to where you need 'em. No muss, no fuss.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width