Quote:
Originally Posted by PolvoPelusa
Not sure if excel has it, but in access you can add a web browser active x control to a form which has all sorts of built-in functions and triggered events. So basically you could load the site into the browser component, toss in your uid/pw, iterate through the PDF links (parsing the HTML), download the files to a specific directory, switch over to excel and pull them into a worksheet. From there its as easy as writing a macro to process the data to suite you needs.
The browser control was added to the .NET framework in v3 or 3.5, but I never realized there was a control in access. Would have saved me a lot of time for some screen-scraping apps I've put together in the past.
Never used it before but i imagine its the same thing as the one in excel, i think he said that the PDF was password protected and he couldnt copy data out, which is why i was looking at importing the whole page and formatting with vba
Quote:
Originally Posted by exec771
wat
I think the accent is so different to an australian accent that i'm not correcting myself!
Quote:
Originally Posted by aces_dad
I have a cell which has a hyperlink which looks like this:
http://myCompany/sap(bD1lbiZjPTkxMA=...?id=9000416915
I want to update the last 10 numbers in the hyperlink and have the 'Text to display' automatically reflect this:
9*416915
I'm finding myself having to edit both the hyperlink and the Text to display field. Can you provide a way to edit only one of these two fields and have both updated?
If the hyperlink is in A1 then you can do:
=HYPERLINK(A1,RIGHT(A1,10))
Quote:
Originally Posted by magent
Say I have permutation of units that I have in order in column A. I'll use the alphabet to simplify and illustrate.
AA
AB
AC
AD etc. to AZ, then
BA
BB
BC
BD
BE etc.
CA
CB
CC
CD
and so on till ZZ. Each two letters are in a cell, and now I'd like to completely randomize the worksheet, so that the cells in the column would read like:
XA
CV
YH
LB
and on. How do I do this? Doesn't seem to be any 'randomize cells' button or anything, but I've been told it can be done.
Quote:
Originally Posted by Dudd
One really easy way to do that is to create a column of random numbers and then just sort by that column, then delete the random column when you're finished sorting.
more explanation if you need: in column C put =RAND() then copy down, then sort by column C and it will be random, if you want to re-randomise then go to the formula tab and click calculate sheet and sort again
Quote:
Originally Posted by FC Juggernaut
What do the little green triangles mean in the top left corners of cells? i feel like they are responsible for not letting me perform simple sum equations for columns of numbers.
They are just notes from excel, off the top of my head you get them if you are displaying a number as text and also if you have 10 cells in a row with the same formula (or a formula copied down) then you change one in the middle it will alert you that there is an inconsistent formula
personally i usually just right click on the little green thing then hit ignore