vba html 正则,VBA编写求助：用正则表达式提取不规律字符串的网址

# -*- coding: utf-8 -*-

# version: Python 3.7.0

import re

html = r'''

{"[{"PeriodName":"\u77ed\u7ebf\u72d9\u51fb","Pic":"http://images.shichai.cnfol.com/Gambit/201702/20170221125713871.jpg","StartTime":"2017-02-21 11:57:18","EndTime":"2017-02-21 1:59:18","ReplayUrl":"http://123456.vod.com/211edff69f311d19ff0758fa.f20.mp4","PeriodID":"309","PeriodDesc":"\u725b\u80a1\u4e7e\u5764\u662f\u6309\u7167\u80a1\u5e02\u6295\u8d44\u4e3a\u6838\u5fc3\u8bbe\u8ba1\u7684\u4ea4\u6613\u6307\u6807\uff0c\u914d\u5408\u4e00\u7ebf\u7275\u725b\u8ba9\u5e02\u573a\u65b9\u5411\u53ef\u4ee5\u63d0\u524d\u77e5\u9053\uff0c\u5316\u7e41\u4e3a\u7b80\uff0c\u4e00\u7ebf\u5b9a\u4e7e\u5764\u3002","Status":"3","VideoType":"3","Duration":"796","Preview":"0","CountDown":"","SalePrice":0,"Price":"98.00","IsFree":"3","Subscription":0,"LearnCollegeTime":"","ProductID":"318479"},{"PeriodName":"\u987a\u52bf\u800c\u4e3a","Pic"21 11:57:49","EndTime":"11:59:49","ReplayUrl":"http://5345435.vod./cef7e311e68df40b0575abff9c.f20.mp4

","PeriodID":"310","PeriodDesc":"\u725b\u80a1\u4e7e\u5764\u6e5\u9053\uff0c\u5316\u7e41\u4e3a\u7b80\uff0c\u4e00\u7ebf\u5b9a\u4e7e\u5764\u3002","Status":"3","VideoType":"3","Duration":"796","Preview":"0","CountDown":"","SalePrice":0,"Price":"198.00","IsFree":"3","Subscription":0,"LearnCollegeTime":"","ProductID":"318480"},{"PeriodName":"\u6ce2\u6d6a\u770b\u8d8b\u52bf","Pic": 12:00:21","ReplayUrl":"http://7878989.vod.com/1e69f3dfff11d19ff0758fa.f20.mp4","PeriodID":"311","PeriodDesc":"\u725b\u80a1\u4e7e\u5764\u662f\u6309\u7167\u80a1\u5e02\u6295\u8d44\u4e3a\u6838\u5fc3\u8bbe\u8ba1\u7684\u4ea4\u6613\u6307\u6807\uff0c\u914d\u5408\u4e00\u7ebf\u7275\u725b\u8ba9\u5e02\u573a\u65b9\u5411\u53ef\u4ee5\7b80\uff0c\u4e00\u7ebf\u5b9a\u4e7e\u5764\u3002","Status":"3","VideoType":"3","Duration":"796","Preview":"0","CountDown":"","SalePrice":0,"Price":"98.00","IsFree":"3","Subscription":0,"LearnCo,"ProductID":"318481"},{"PeriodName":"\u4e00\u7ebf\u4e70\u5356\u70b9","Pic":"http://images.shichai.cnfol.com/Gambit/201702/20170221125847926.jpg","StartTime":"2017-02-21 11:58:50","EndTime":" Duration":"796","Preview":"0","CountDown":"","SalePrice":0,"Price":"198.00","IsFree":"3","Subscription":0,"LearnCollegeTime":"","ProductID":"318482"}]}

'''

res = re.findall(r'"(https?://[^"]+.mp4)"',html)

print(res)