Problems with Automated Command prompts with VBA
Problems uncounted in the execution of such coding is often difficult to debug, since often the code lines do not error. Often when problems occur, the commends are simply not done, but the VBA coding continues further.
One problem already noted is the presence of spaces in path strings. Care has to be taken in the correct syntax in the use of quotes, " , to overcome this problem
https://stackoverflow.com/questions/...46481#59346481
http://www.eileenslounge.com/viewtop...261670#p261670
Another strange problem I once experienced , was that the command prompt coding lines were not working on one particular XP computer. I finally tracked the problem down to a point _ . _ in the computer name. Once I removed this point _ . _ all was well.
( I could not repeat the exüeriment, as any attempts to change the name to include a point _ . _ , were not allowed….. This particulate computer I did not have from new . I don't know how a point was made in the computer name)
Ref
Change Computer name in XP : https://www.watchingthenet.com/how-t...-or-vista.html
http://www.excelfox.com/forum/showth...ll=1#post11572
Reply With Quote
Bookmarks