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!

Register Log in
  • Congratulations Chriss Miller 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. johnmtb

    hyperlink problem

    Dear All, I have successfully written a programme that links a cell in one .xls file to a cell in another .xls file. I now want to accomplish the same thing using .doc files. I have created two files, one the source and the other the destination. Both files contain tables with identical...
  2. johnmtb

    To Buy, or Not To Buy?

    RiverGuy, in that case, i believe i will just stay with the downloadable version, as i do not want C# and C++. thank you all, regards, john
  3. johnmtb

    To Buy, or Not To Buy?

    RiverGuy, what i meant then is, can i buy Visual Basic 2008 Standard? that is Visual Basic on it's own? regards, john
  4. johnmtb

    To Buy, or Not To Buy?

    RiverGuy, the Visual Basic that i am using is the Visual Basic 2008 Standard Edition, which i downloaded free of charge. but, if there is a version which i should purchase, Visual Basic only, i will purchase that version in order that i may have my colleagues use the programmes. in other...
  5. johnmtb

    To Buy, or Not To Buy?

    Sorwen, thank you. regards, john
  6. johnmtb

    To Buy, or Not To Buy?

    Sorwen, did you get it eventually, and was it worth it? regards, john
  7. johnmtb

    To Buy, or Not To Buy?

    Dear All, Thank you all for your input. When I finish downloading the 90 day trial package, I will use it for the ninety days, and then probably buy it, unless something very bad puts me off. To tell the truth, I don’t really have to provide my colleagues with programmes, but it does speed up...
  8. johnmtb

    To Buy, or Not To Buy?

    All, thank you for your comments. but what is the bottom line? do you recommend that i purchase Visual Studio 2008 Professional? i already have Visual Studio 2005, but i haven't used it much. and i do like to have the latest if it is worth it. it is only about $700 or $800. regards, john
  9. johnmtb

    To Buy, or Not To Buy?

    Dear All, I have now been using the Free, Downloadable version of VB 2008, for some time, and have written about one dozen programmes using this language. In fact, having convetted those programmes from ones that I had already written in VB 6. I am now thinking seriously about buying Visual...
  10. johnmtb

    Opening a File Read Only

    Dear All, it appears that the person who wrote the file had locked it accidentally. it is now unlocked and my programme works fine. thank you SBerthold. regards, john
  11. johnmtb

    Opening a File Read Only

    Dear All, I have a simple programme which searches for a file, and upon locating it, opens it. However, I receive the following error message “…user does not have access privileges.” I have tried to open the file “read only”, but I cannot find the correct method. Everything I have tried has...
  12. johnmtb

    “.FileName”

    Skip, i thought that i had tried your code, but when i checked again, i realized that i had not. i have now tried it, and it gives me the file i was looking for. thank you very much. regards, john
  13. johnmtb

    “.FileName”

    Skip, sorry, i thought i had run your code, but when i checked again, i had not. thank you, indeed your code gives me the full file name. regards, john
  14. johnmtb

    “.FileName”

    Harebrain, not that i know of, they are both operating under the same constraints. regards, john
  15. johnmtb

    “.FileName”

    Skip, i run it until the end of the SUB(), then i hold it there with a break point. i can then read the .Filename, which shows only "521026*.*". on my other programme, it would show, for example only, "521026 WT0841.pdf". regards, john
  16. johnmtb

    “.FileName”

    Skip, thank you, but it gives the same result. it just doesn't expand the *.*. regards, john
  17. johnmtb

    “.FileName”

    SkipVoughht, that code has not been written yet. i normally break my coding into chunks of things to do. i haven't got to that yet, as it will use the results of the code above to choose the item to be hyperlinked into a position on the master Excel sheet. regards, john
  18. johnmtb

    “.FileName”

    All, thank you for your input. the version of MS office that i am using is 2003, on both computers, but on one this works on the other it does not. plus the programme runs in debug correctly, it just returns "521026*.*"., instead of "521026 WT0841.pdf". it simply is not expanding the wild...
  19. johnmtb

    “.FileName”

    Dear All, I cannot understand why the following code does not work, when a previous programme using the same code works perfectly. I am trying to obtain the complete name of a file, when I know part of that name, the part that I know being 521026. The “*.*”, should provide the remainder of...
  20. johnmtb

    “.FileName”

    Strongm, i don't understand, the programme is written in VB6 not VBA. what i really need to know, is why the wildcards, "*", are not being expanded in this programme, but they are in my other programme. regards, john

Part and Inventory Search

Back
Top