| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop through files in a folder and unprotect sheets
Hi Barb,
Where should I see myname once I have put that line in? Here are Immediate Window Contents when Set myWB = Workbooks.Open(myName) is in yellow after the runtime error. [auto_open] < [SetupFunctionIDs] < [SetupFunctionIDs] [PickPlatform] < [PickPlatform] [VerifyOpen] < [VerifyOpen] 1 [RegisterFunctionIDs] < [RegisterFunctionIDs] [auto_open] I'm going to have to google immediate window 'cos i don't know what it is. Would it help to know that myName ="" when you hover over it in the code and that myWB = nothing? Path has the expected pathname. I'm not sure I understand what you mean by "concatenate the path name the you selected to the myName value" (never mind not sure, call a spade a spade, I just don't understand :-)) -- Deirdre (finding this exciting and frustrating in equal measure!) "Barb Reinhardt" wrote: Put Debug.print myName before the error and see what it gives you. It should show the full path. If it doesn't, (and I may have forgotten that), you'll need to concatenate the path name the you selected to the myName value. -- HTH, Barb Reinhardt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling pdf files from general folder to specific folder | Excel Discussion (Misc queries) | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Programming | |||
| Loop thru All Files in a Folder | Excel Programming | |||
| Loop through all files in a folder | Excel Programming | |||
Threaded Mode
