+ Reply to Thread
Results 1 to 6 of 6

Automated processing

  1. #1
    Registered User
    Join Date
    11-03-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    28

    Automated processing

    I have used excel in it's basic form for many years but have rarely ventured into VBA programmng. I have been asked to automate the processing of a weekly excel report that arrives in a given format (which I can't change):

    1) the file comes in with two worksheets.
    2) I'm supposed to write something to take data from the second sheet (name should be fixed), produce a third sheet and then email that sheet to a specific person.

    My questions are: how are macros managed on excel? - what process should I use to associate an incoming spreadsheet with a prewritten macro?

    I hope someome out there knows what I am talking about!

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Automated processing

    Macros involve the automation of certain steps done manually in excel. You can have a separate macro file which will ask you to open the report and do the required steps and provide it to you.

    If you need further help, attach a sample workbook (ensure that all sensitive data is removed) and let me know what you need automated and maybe i can help you out.

  3. #3
    Registered User
    Join Date
    11-03-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    28

    Re: Automated processing

    Quote Originally Posted by arlu1201 View Post
    Macros involve the automation of certain steps done manually in excel. You can have a separate macro file which will ask you to open the report and do the required steps and provide it to you.

    If you need further help, attach a sample workbook (ensure that all sensitive data is removed) and let me know what you need automated and maybe i can help you out.
    OK - I thought macros were associated with a particular spreadsheet but if they can be written generically, then great! Could you show me a simple bit of code to prompt the user for a worksheet please?

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Automated processing

    Like this -
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    11-03-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    28

    Re: Automated processing

    Quote Originally Posted by arlu1201 View Post
    Like this -
    Please Login or Register  to view this content.
    Thank You - I don't understand a word of it, but thank you!

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Automated processing

    Its very simple. The code asks the user to provide the path to the file through the Open dialog box that comes up. The code checks if the user has not selected anything by comparing it to a blank. If the user has not selected, it asks to select again. If the user has selected, it opens the file.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1