Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
241 views
in Technique[技术] by (71.8m points)

(VBA) Importing Data from Unique HTML File into Excel

I want to create a VBA code that pulls the relevant data I want to work with out of a webpage and posts it into HTML. I did a lot of searching, and I couldn't find a thread that was similar to my situation (I don't know much about HTML).

Here is the basic structure of the HTML file:

<html><head>
<meta http-equiv="content-type" content="text/html; charset=windows-1252">
<meta name="robots" content="index,follow">
<title>"title: abcdefg"</title>

</head>
<h1>"heading: 2345"</h1>
<p>
Last Updated: "Last date"
</p><p>

</p><p>
<next></next><table border="3" cellpadding="6" cellspacing="3">
<tbody><tr>
<td>
<pre>
*Want this data*

</pre>
</td>
</tr>
<tr>
<td>
<pre>
*Want this data*

</pre>
</td>
</tr>
<tr>
<td>
<pre>
*Want this data*
See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

1.4m articles

1.4m replys

5 comments

57.0k users

...