+ Reply to Thread
Results 1 to 3 of 3

Looking for VBA users intuition

Hybrid View

MDLovitt Looking for VBA users... 03-10-2025, 07:06 PM
6StringJazzer Re: Looking for VBA users... 03-10-2025, 10:37 PM
ByteMarks Re: Looking for VBA users... 03-11-2025, 05:52 AM
  1. #1
    Registered User
    Join Date
    07-18-2024
    Location
    United States
    MS-Off Ver
    MS 365
    Posts
    33

    Looking for VBA users intuition

    My gf has a job that requires her to log in to multiple different websites, enter in patient information, pull information from a patient profile and enter that information into two different websites. Not looking for anyone to do the coding for me as I think the challenge would be fun, however I have seen some conflicting information regarding the likelihood of VBA being useful for something like this. In your experience is VBA a good conduit to enter websites, gather information and enter it into other websites or is this more of a Python type of task? If VBA can do a task like this, does anyone have a good resource to learn about making VBA interact with websites?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: Looking for VBA users intuition

    I don't know Python, but if Python can do it, it's probably better at it. There is nothing in your description that mentions Excel. VBA is a language that is designed to automate Excel. It is capable of doing other things too, in the same sense that if you fill your car with water it's capable of being a hot tub.

    VBA can retrieve data from web sites using a built-in library for sending HTTP page requests and parsing the returned HTML. I am not as sure about how you would populate a web page using VBA but I believe it's possible.

    But if you have programming experience you may have better luck with something that is intended to do what you want to do.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert ByteMarks's Avatar
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    3,079

    Re: Looking for VBA users intuition

    You can install Selenium webdriver to automate chrome but it operates in real time and limits use of the machine performing the task while its occurring.

    An example of Python can be found here

    Things become more complicated when logins are required because a lot of sites will check for and block repeated logins.

+ 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. Is it possible to allow access to some users to some Excel sheet's, other users not?
    By AgustinaGP in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2023, 10:04 AM
  2. Lifetime MS Office Offer for MAC Users and now PC Users too
    By alansidman in forum The Water Cooler
    Replies: 6
    Last Post: 01-03-2023, 12:00 PM
  3. Replies: 2
    Last Post: 10-13-2021, 01:03 AM
  4. Replies: 0
    Last Post: 01-11-2016, 11:58 AM
  5. Allow Users to Edit Ranges Using Users from a Network Location
    By Tayque_J_Holmes in forum Excel General
    Replies: 0
    Last Post: 10-24-2013, 06:34 AM
  6. prevent users from overwriting other users data
    By tino.toendra@gmail.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-17-2005, 04:06 PM
  7. [SOLVED] Help - Automating a file.. Adding Users , Deleting users, Changing
    By Tim Harding in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-16-2005, 10:06 AM

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