Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. shaggz7even

    429 ActiveX Component Can't Create Object

    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...
  2. shaggz7even

    429 ActiveX Component Can't Create Object

    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...
  3. shaggz7even

    QueryTables.Add corrupt data because of data type

    Nope, same thing The msdn website says nothing about this i can't find a single faq on what exactly each of these properties do.
  4. shaggz7even

    QueryTables.Add corrupt data because of data type

    that was my first idead formatting as text just shows its as 5.002E+16
  5. shaggz7even

    QueryTables.Add corrupt data because of data type

    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...
  6. shaggz7even

    link data in QueryTables

    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
  7. shaggz7even

    link data in QueryTables

    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...
  8. shaggz7even

    How can I change BMP to JPEG files in one step.

    ACDSee has good batch conversion and batch file renaming
  9. shaggz7even

    rotating sprites

    one more thing, this only works with 8-bit sprites such as in screen 13
  10. shaggz7even

    Calling the main program from a sub?

    Use 'Exit Sub' Sub Win if a=0 then Exit Sub Print "You Win!" tallyscores End Sub
  11. shaggz7even

    rotating sprites

    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
  12. shaggz7even

    rotating sprites

    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...
  13. shaggz7even

    File Not Found with open statement

    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

Part and Inventory Search

Back
Top