+ Reply to Thread
Results 1 to 10 of 10

Macro on Excel Online

  1. #1
    Registered User
    Join Date
    02-19-2013
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2010
    Posts
    3

    Macro on Excel Online

    Is there a way to use macros on excel online? I have a spreadsheet that I want to have a search button on the summary sheet that searches all other sheets in the workbook for a specific invoice #. I have a macro that does this on excel 2010 on my computer, but as soon as I save it to the online folder in OneDrive the macro no longer works. Please Help!!!

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Win 2010-2016
    Posts
    11,109

    Re: Macro on Excel Online

    Hello,

    Excel online does not support VBA. Macros and custom functions will not run, and there is no way to make them run. VBA only runs in the desktop client, not online and not on Excel mobile.

    Don't shoot the messenger.

    Cheers, teylyn

  3. #3
    Registered User
    Join Date
    02-19-2013
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Macro on Excel Online

    I just discovered a simpler way to search the entire workbook in the desktop version, but is also not supported in the online version. CTRL+F, then change from "Sheet" to "Workbook". Excel online does not have the "Workbook" search option. Any ideas if the Excel Online version will get more advanced features?

  4. #4
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Win 2010-2016
    Posts
    11,109

    Re: Macro on Excel Online

    Excel online is getting new features all the time. If and when which feature is added is anyone's guess, though.

  5. #5
    Registered User
    Join Date
    02-19-2013
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Macro on Excel Online

    Thank you for your help on this! Have a great day.

  6. #6
    Registered User
    Join Date
    01-03-2016
    Location
    india
    MS-Off Ver
    2007
    Posts
    40

    Re: Macro on Excel Online

    Hi Friends,

    Iím working in stock broking company, I am into commission processing, Every month I need to configure commission structure for multiple Agents (code)
    So I want to simplify the process as I am working on weekends also for the same.

    Scheme: MR

    Plan: w

    Agent: ARN-3077

    Agent Category ID: 1003

    Brok Type ID: 1

    From Date: 01/01/2017

    To Date: 31/03/2017

    From Amount: 0

    To Amount: 9999999999999.99

    Rate: 1.5

    Remarks: Ltr.21789.Dtd.01.02.2017

    City Category: B-15

    frommonth: 366

    tomonth: 1095






    This is the format for the for configuring commission rate. After creating excel file will upload the same in one application.

    Please any one help on the same and create a macro(User form to enter the data) to automate the same.. my requirements is as below

    Suppose If I want to configure commission structure to 100 agents.. 1st I will upload all agent idís and then I will enter remaining parameters shown in above table after entering all parameters I want an option in user form to choose to select Agent code. After choosing agent code I will hit enter and all fields should get clear so that I will update all fields again with different scheme code.. after finishing I want finish button to hit and all the data get export one excel fileÖ

    Please create one user form as per my requirements....Thank you
    please ignore grammar mistakes.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    41,191

    Re: Macro on Excel Online

    Devendra.dvm welcome to the forum

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think some-1 helped you

    Regards
    Ford

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    41,191

    Re: Macro on Excel Online

    Devendra.dvm welcome to the forum

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

  9. #9
    Registered User
    Join Date
    01-03-2016
    Location
    india
    MS-Off Ver
    2007
    Posts
    40

    Re: Macro on Excel Online

    m unable find new thread button

  10. #10
    Registered User
    Join Date
    03-26-2016
    Location
    Minsk, Belarus
    MS-Off Ver
    Excel 2013
    Posts
    1

    Re: Macro on Excel Online

    Hello, guys. Zoho sheets have something similar to VBA editor.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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