not the same problem.
i re-registered msinet.ocx succesfully and i reopened the excel sheet and reset the vb references.
no luck
the program does work however on my old computer, the only difference b/n my computers and everyone else's is that i've installed vb6 (and updates) on mine and no...
i'm using msinet.ocx in VBA in excel to download files web pages. everything works fine on my PC. when i put it on a co-worker's machine i get:
429: ActiveX Component Can't Create Object
i've seen this problem elsewhere in this forum and others but no one offers a solution or explanation...
Im using the QueryTables.Add method to import data from a web site.
One of the records is an eighteen digit account number. When VBA retrieves the number, it gets it single precision number, which when formatted, turns the last 2 digits or so to zeros
Is there a property of the add method i...
how exactly would i go about doing that
getting the url from a cell
to get the text i use:
strData = ActiveSheet.Cells(y,x)
how do you suggest i get the url??
strData = ActiveSheet.Cells(y,x).Hyperlink.Address ?
that doesnt work. i've looked all over, the msdn library isnt helping at all
im trying to recieve data from a table in a web page into excel that contains a link
when excel imports the data, the only only part i can see (or retreive from the cell) is the link text, not the actual link. but i can click on the link to go to the page and if i mouseover it, i can see th...
no problem
remember, you can put more than one sprite in the same one-dimensional array, using a different iref value
iref stands for integer reference
defint a-z 'must use this for this algorithm
'rot 90 degrees
'iref is the 1st index of the sprite
'sprData is your array the image is in
'this is info inside each sprite that tells
'qb the...
MSDN says that using the OUTPUT access method with the OPEN statement will automatically create a new file if not found, why is it then that I am getting a File Not Found error when trying??
help would be appreciated
thanx
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.