Clicky

Please see below document which is a screen shot. I would like for the ML_LOTSERIALNO$ to return the value to the file path where I have noted 'value'. How can I write the script so that it wit will do this?
Doc3.doc (255 KB)
Screenshot (application/vnd.ms-word)

asked 08/08/2011 09:08

JoeB_IFT's gravatar image

JoeB_IFT ♦♦


4 Answers:
Could you specify more details and complete requirements

regards
Prashanth
link

answered

prashanthd's gravatar image

prashanthd

I'm not really sure what you mean but I'm wondering if you want...
1:
objShell.ShellExecute("M:Quality LogsQuality Logs\Master-CofA File" & ML_LOTSERIALNO$ & ".pdf")
link

answered 2011-08-08 at 23:16:13

Alan_White's gravatar image

Alan_White

I hava tried this and I get an error on script line #27

  27 : objShell.ShellExecute("M:\Quality Logs\Quality Logs\Master-CofA File\" & ML_LOTSERIALNO$ & ".pdf")

I attached a screen shot of the error I received
link

answered 2011-08-09 at 09:07:03

JoeB_IFT's gravatar image

JoeB_IFT

I removed the $ from the field name and it worked! :) This is the final code that I used.
Thank you!

' Use ShellExecute to open a particular file
Set objShell = CreateObject("Shell.Application")

objShell.ShellExecute( "M:\Quality Logs\Quality Logs\Master-CofA File\" & ML_LOTSERIALNO & ".pdf" )
link

answered 2011-08-09 at 21:00:27

JoeB_IFT's gravatar image

JoeB_IFT

Your answer
[hide preview]

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

Asked: 08/08/2011 09:08

Seen: 188 times

Last updated: 08/09/2011 06:11