+ Reply to Thread
Results 1 to 6 of 6

Help with: Prefill cells with command line switches from a browser

  1. #1
    Registered User
    Join Date
    01-28-2014
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    4

    Exclamation Help with: Prefill cells with command line switches from a browser

    Hi everyone, I've been coming here a while now, and I can see my question has been partly answered.

    I'm looking to have an excell file shared on a windows network to a simple LAN (samba sharing), and then for a user to be able to click on a HTML link that will launch that excell pile, and to have it populate specific and predeterminined cells with information that will be handed to it by the HTML link from the website.

    Think of a CRM web app that href is a link like: "\\LAN1\Files\excellbook01.xls?Mrs%20Wendy%20Jones?4%20Skin%20Street"

    From something like that I would like to launch excell and have Mrs Jones' details populate into the predefined excell sheet. The HTML website can dynamically populate a HTML link depending on the customer being viewed.

    So I'd like to know how two things
    1) how to launch a network file in this way, while correctly handing it parameters or switched that it will be able to later:
    2) Collect that information and distribute it into the cells I choose in VBA.

    I'm familiar with Visual Basic .Net primarily, and have a small amount of VBA experience.

    We would like to continue to use Google chrome if possible...

    Thanks everyone

    C.C.
    http://www.mrexcel.com/forum/excel-q...s-browser.html

    http://www.ozgrid.com/forum/showthre...938#post699938

    http://www.vbaexpress.com/forum/show...027#post304027
    Last edited by Dailafing; 01-29-2014 at 05:22 AM. Reason: Adding crosslinks

  2. #2
    Registered User
    Join Date
    01-28-2014
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Help with: Prefill cells with command line switches from a browser

    Bump - was hoping this would be easy for a forum like this to answer?

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Help with: Prefill cells with command line switches from a browser

    Removed, OP added links
    Last edited by Kyle123; 01-29-2014 at 05:25 AM.

  4. #4
    Registered User
    Join Date
    01-28-2014
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Help with: Prefill cells with command line switches from a browser

    I appreciate and understand your concern there. To combat this, I've actually made notes and recorded where this has been posted and when solved I intend to share the solution across to the other post so all forums can benefit from this. I'm glad you took the time to check where else this question is posted, although I think time may have been better spent helping me with my issue since I put a load of effort into this, and I come humbly to the site to ask for your help

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Help with: Prefill cells with command line switches from a browser

    So share the links and I'll remove the post By the way, I've also answered your question on another site

  6. #6
    Registered User
    Join Date
    01-28-2014
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Help with: Prefill cells with command line switches from a browser

    Done5678910

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] is it possible to add data to cells from the command line?
    By Martin in forum Excel General
    Replies: 2
    Last Post: 08-11-2006, 08:30 AM
  2. Complete list of Excel Command line switches/parameters
    By NHRunner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2006, 01:35 PM
  3. Command Line Startup Switches
    By OldManEd in forum Excel General
    Replies: 1
    Last Post: 02-08-2006, 06:55 PM
  4. [SOLVED] Command line switches.
    By Jarryd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2005, 06:10 PM
  5. [SOLVED] Prefill cust info from drop list into other cells
    By carris76 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-28-2005, 03:05 PM

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