Sponsored 320 Gave Reputation to in Broken link
Article by tinstaafl in DaniWeb Community Feedback
The link was pasted from the address bar using the link button in the post. Are you saying I need to format the link differently? That we're all supposed to be experts on the Daniweb API to know these thing?
Sponsored 320 Replied To a Post in Broken link
Article by tinstaafl in DaniWeb Community Feedback
And now it's broken here too. I appears that it was fine when I posted it and just to test I accessed it from a second browser.

Seems like a cron job ran and automessed it up. It does report as broken but is not if you continue. And I …
Sponsored 839 Replied To a Post in Broken link
Article by tinstaafl in DaniWeb Community Feedback
The link was pasted from the address bar using the link button in the post. Are you saying I need to format the link differently? That we're all supposed to be experts on the Daniweb API to know these thing?
I'm working in Excel to extract content of a table from a web page and populate Excel sheet cells with it. I'm trying to extract data from a table that gets loaded to a web page after show results method gets called. I have an error that says "Run-time error … Article by Start4me in Web Development
Article by Start4me in Web Development
Thank you very much diafol! Now that you've helped me get this figured out and it works, I can proceed with my next task of implementation.
Sponsored 320 Replied To a Post in Broken link
Article by tinstaafl in DaniWeb Community Feedback
OK with parentheses.
(http://www.databasejournal.com/features/mssql/article.php/3112381/SQL-Server-Calculating-Running-Totals-Subtotals-and-Grand-Total-Without-a-Cursor.htm)

Seems fine too. How to break this?

PS. In your example the link is to this which is not working.
https://www.daniweb.com/posts/bad_link/2212833?url=http%3A%2F%2Fwww.databasejournal.com%2Ffeatures%2Fmssql%2Farticle.php%2F3112381%2FSQL-Server-Calculating-Running-Totals-Subtotals-and-Grand-Total-Without-a-Cursor.htm (yep, dead.)
Sponsored 320 Began Watching
Why does this perfectly valid link(`http://www.databasejournal.com/features/mssql/article.php/3112381/SQL-Server-Calculating-Running-Totals-Subtotals-and-Grand-Total-Without-a-Cursor.htm`) show up as a broken link in a [post](https://www.daniweb.com/programming/software-development/threads/506824/how-to-get-the-value-from-cells-of-a-datagridview-table#post2212833)? Article by tinstaafl in DaniWeb Community Feedback
Sponsored 320 Replied To a Post in Broken link
Article by tinstaafl in DaniWeb Community Feedback
Let's test it.

-> [That link](http://www.databasejournal.com/features/mssql/article.php/3112381/SQL-Server-Calculating-Running-Totals-Subtotals-and-Grand-Total-Without-a-Cursor.htm).

On some forums the forum software doesn't figure it out automatically. The minus signs?

http://www.databasejournal.com/features/mssql/article.php/3112381/SQL-Server-Calculating-Running-Totals-Subtotals-and-Grand-Total-Without-a-Cursor.htm

Hmm seems fine or is it?
Sponsored 839 Created
Why does this perfectly valid link(`http://www.databasejournal.com/features/mssql/article.php/3112381/SQL-Server-Calculating-Running-Totals-Subtotals-and-Grand-Total-Without-a-Cursor.htm`) show up as a broken link in a [post](https://www.daniweb.com/programming/software-development/threads/506824/how-to-get-the-value-from-cells-of-a-datagridview-table#post2212833)? Article by tinstaafl in DaniWeb Community Feedback
Sponsored 839 Began Watching
Why does this perfectly valid link(`http://www.databasejournal.com/features/mssql/article.php/3112381/SQL-Server-Calculating-Running-Totals-Subtotals-and-Grand-Total-Without-a-Cursor.htm`) show up as a broken link in a [post](https://www.daniweb.com/programming/software-development/threads/506824/how-to-get-the-value-from-cells-of-a-datagridview-table#post2212833)? Article by tinstaafl in DaniWeb Community Feedback
Sponsored 839 Replied To a Post in Broken link
Why does this perfectly valid link(`http://www.databasejournal.com/features/mssql/article.php/3112381/SQL-Server-Calculating-Running-Totals-Subtotals-and-Grand-Total-Without-a-Cursor.htm`) show up as a broken link in a [post](https://www.daniweb.com/programming/software-development/threads/506824/how-to-get-the-value-from-cells-of-a-datagridview-table#post2212833)? First Post in Article by tinstaafl in DaniWeb Community Feedback
I'm working in Excel to extract content of a table from a web page and populate Excel sheet cells with it. I'm trying to extract data from a table that gets loaded to a web page after show results method gets called. I have an error that says "Run-time error … Article by Start4me in Web Development
Article by Start4me in Web Development
Just a thought. Since the linked site currently only has 189 items why not rip it one time onto another sheet and update as you see fit.

Seems a lot of work for what doesn't appear to change often.

PS. Added with edit. It's clunky but a while back to …
3,149 Replied To a Post in Extract data from html table using VBA
Article by Start4me in Web Development
Not sure if this would be better:

.Visible = True => remove it so it doesn't show?

Also you should set up variables for the querystring parameters in order to make this sub a little more flexible / usable.
3,149 Replied To a Post in Extract data from html table using VBA
Article by Start4me in Web Development
I get that now - see my previous post - however, you need to be able to programmatically send the form (or the data) in order to get at the table.

You may be better sending data directly via http://www.sizemyups.com/getups.php with a url querystring:

Try this:

http://www.sizemyups.com/getups.php?load=50&AVW=WATTS&loadtype=MSL&standby=1&lineint=1&online=1&line=&involts=120&outvolts=120&rack=0&sine=0&min=0&max=0&growth=0&sort=estrt&uid=1011&htemp=0

What you then …
Article by Start4me in Web Development
I tried to get the button to be clicked by the following code:


Dim Element, txt As Object
Set Element = doc.getElementById("myform").getElementsByTagName("a")
For Each txt In Element
If txt.href = "javascript:onclick=showResults(document.myform.load.value, document.myform.AVW.value, document.myform.loadtype.value, document.myform.standby.value, document.myform.lineint.value, document.myform.online.value, document.myform.line.value, document.myform.involts.value, document.myform.outvolts.value, document.myform.rack.value, document.myform.sine.value, document.myform.min.value, document.myform.max.value, document.myform.growth.value,document.myform.sort.value,document.myform.uid.value,document.myform.htemp.value)" Then
txt.Click
End If
Next

But …
1,410 Replied To a Post in Arrays
Article by i. in Programming
Put a for loop around

If num[x] < avg Then
Display num[x]
End If
1,410 Edited
Hello!

So far I've done what I've wanted: input ten numbers in an array, calculated the average (of said numbers), and printed them. But now I'd like to print out the values in the array that are below the average (e.g. if the average is 5.5, it'd print out 1, … Article by i. in Programming
Article by Start4me in Web Development
Indeed. The button on the webpage appears as an image, and I don't know how to programmatically call a button click on it. I've done some debugging and the code that I assumed will make the table load with data, doesn't update the results as they should be.
Article by Start4me in Web Development
Here's the webpage html before my code runs:
![HTML_code_before.png](/attachments/large/3/ddfd9429a5444416661b3828f303d61c.png "align-center")

And here's the webpage html after I ran my code:
![HTML_code.png](/attachments/large/3/da43db83f68baa39e684364c8be051b8.png "align-center")
3,149 Replied To a Post in Extract data from html table using VBA
Article by Start4me in Web Development
The site I visited does not have a "mytable" id in any tag although it is referenced in the styling.
A "homepu" id is attached to a table (empty) - but strangely it is in the head section of the html document.
The webpage is horrible - js, html, styling …
I am new please help me in this how could we promote our business please share with us. Article by George_14 in Search Engine Strategies
Article by George_14 in Search Engine Strategies
I think nowadays to promote your business on social medias such as facebook is a must for [seo techniques](http://www.pcmate.org/seo-techniques).
Joined the Community
Created
Hello!

So far I've done what I've wanted: input ten numbers in an array, calculated the average (of said numbers), and printed them. But now I'd like to print out the values in the array that are below the average (e.g. if the average is 5.5, it'd print out 1, … Article by i. in Programming
Began Watching
Hello!

So far I've done what I've wanted: input ten numbers in an array, calculated the average (of said numbers), and printed them. But now I'd like to print out the values in the array that are below the average (e.g. if the average is 5.5, it'd print out 1, … Article by i. in Programming
Replied To a Post in Arrays
Hello!

So far I've done what I've wanted: input ten numbers in an array, calculated the average (of said numbers), and printed them. But now I'd like to print out the values in the array that are below the average (e.g. if the average is 5.5, it'd print out 1, … First Post in Article by i. in Programming
I'm working in Excel to extract content of a table from a web page and populate Excel sheet cells with it. I'm trying to extract data from a table that gets loaded to a web page after show results method gets called. I have an error that says "Run-time error … Article by Start4me in Web Development
3,149 Replied To a Post in Extract data from html table using VBA
Article by Start4me in Web Development
Can you show the relevant html from the webpage?
Article by Adam_34 in Web Development
Check your directory and file permissions. This is the most likely problem - incorrect permissions on sub-directories or for file access.