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 MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Part Number/Name added to output file name

Status
Not open for further replies.

bravozulu1981

Mechanical
Joined
May 30, 2014
Messages
3
Location
US
OK this is probably really stupid simple, i must be over looking something, but can one of yall help. I wrote a VBA macro for a part file to output some information to a txt file. Currently I have this:

strFilePath = "C:\Users\bzander.MININT-Q2K9KRN\Desktop\Notes.txt"

to define the file path to save to. I would like to add the actual part name to that so the txt file name would be "XXXXX Notes.txt" with the xxx representing the part name.
 
Ok that works, but rather than the file name that contains the path information, I'd like the part name...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top