Search results for query: *

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

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

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

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

Sorwen, thank you. regards, john

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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