Adonaioc
03-30-2009, 01:16 PM
Call Shell("""Excel.EXE"" ""C:\Documents and Settings\JDoe\Desktop\Part Number\""" & StringTemp, 1)
Through a million combinations and quotes i cannot seem to bust this one open. When i think i almost have it it wont accept the spaces in the path or file name.
any help would be appriciated
I have a script to list all of the paths to all of the files in a directory in the first column starting in the second row. and then i have vba store the first part as a variable "stringtemp" I need to open the file located at the path "stringtemp" so that i can to a replace function to update a part of all the formulas. and then save and go to the next one. I think i have most of it figured out but I am stumped here.
Through a million combinations and quotes i cannot seem to bust this one open. When i think i almost have it it wont accept the spaces in the path or file name.
any help would be appriciated
I have a script to list all of the paths to all of the files in a directory in the first column starting in the second row. and then i have vba store the first part as a variable "stringtemp" I need to open the file located at the path "stringtemp" so that i can to a replace function to update a part of all the formulas. and then save and go to the next one. I think i have most of it figured out but I am stumped here.