Insert Filename automatically when open

08-30-2017, 05:21 AM

gmayor

Windows 10 Insert Filename automatically when open

Office 2016

Expert

Join Date: Aug 2014

Posts: 4,144

I am no longer sure what it is that you are trying to do. Earlier you said the filename was
00001-STIS-CV-00
That being the case your code cannot possibly work e.g.
Take the line

Code:

strRef = "KR-A359-STR-" & vRef(1) & "-" & vRef(2) & "-" & vRef(3) & "-" & vRef(4)

That line cannot work as vRef(4) does not exist. I guess it should be

Code:

strRef = "KR-A359-STR-" & vRef(0) & "-" & vRef(1) & "-" & vRef(2) & "-" & vRef(3)

vRef(0) is 00001
vRef(1) is STIS
vRef(2) is CV
vRef(3) is 00

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to insert Wildcards into Word 2011 Mac such as: \$Filename\	peterspiano	Word	4	06-29-2015 05:13 AM
Excel connot open file (filename) xlsx	dengeorge6	Excel	0	12-12-2014 01:36 AM
A macro that can insert FILENAME, sendkeys CTRL ALT T, paste clipboard, and nextline	kyjac85	Word VBA	13	09-20-2012 05:00 PM
How to insert current date into default filename ?	czomberzdaniela	Word	1	12-27-2011 07:18 PM
Macro for automatically adding filename without .doc	RPM7	Word VBA	0	04-29-2010 01:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:52 AM.