Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the follow macro
Sub RecallTemplatePartNumber(Optional pn As Long = -1) Dim partbook As String Dim partnumber As String Dim r As Range partnumber = InputBox("Please enter PART NUMBER file name to recall", "OldTechnogologies LLC") Quote = "\\SERVER3\Jobs\Estimate1\TEMPLATE1\PART NUMBER1\" & partnumber & ".XLS" If the file is not found I want to look in Quote = "\\Server3\Database\prodscheduling\approvedpar ts\" & partnumber & ".XLS Workbooks.Open Filename:=Quote |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding of temp file | Excel Discussion (Misc queries) | |||
Finding a matching value in another file | Excel Programming | |||
Finding file | Excel Programming | |||
finding a file | Excel Discussion (Misc queries) | |||
finding the right file | Excel Programming |