help please

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Jun 22, 2014

• #2

Did you try?

Rich (BB code):

filetest = Dir("P:\Plant Team\" & lastfile)

 

Upvote 0

S

steve47

New Member

Joined

Aug 28, 2010

Messages

22

• Jun 22, 2014

• #3

hi thanks for the reply

Yes i can get it to change drives,if the drive is physically attached to the machine i am using. I cannot get it to find the drive when it is a network drive.??

any thoughts

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Jun 22, 2014

• #4

I think it should work if drive P is mapped to a network drive. If it doesn't you can try a UNC path eg \\Server\Folder\.

 

Upvote 0

S

steve47

New Member

Joined

Aug 28, 2010

Messages

22

• Jun 22, 2014

• #5

I am sorry but i do not understand any of this.
all i get is error after error, not knowing how to type code is defeating me. what does a bracket do, a full stop i have not got a clue. I have to fins macros that other people have written and use that.

Can you rewrite the above macro i will then copy and paste to try it

Thanks

 

Upvote 0

Rick Rothstein

MrExcel MVP

Joined

Apr 18, 2011

Messages

38,465

Office Version

1. 365

Platform

1. Windows

• Jun 22, 2014

• #6

steve47 said:

I am sorry but i do not understand any of this.
all i get is error after error, not knowing how to type code is defeating me. what does a bracket do, a full stop i have not got a clue. I have to fins macros that other people have written and use that.

Click to expand...

What is the exact name of your server? You wrote this earlier...

"The drive i need it access is called Data on totonfs01 '(P)\plant team"

but it is hard to tell if the server name I "Data on totnfs01 '(P)" or "totnfs01 '(P}" or maybe even "(P)"... and is that single apostrophe (no matching second one) correct (it looks kind of out of place there)?

 

Upvote 0

S

steve47

New Member

Joined

Aug 28, 2010

Messages

22

• Jun 22, 2014

• #7

hi thanks for trying to help me.
data on totonfs01 (P) this will be the server i would think. all members of staff have access to this "P" Drive we call it.

I am sorry but I will have to check tomorrow the correct punctuation of it. EG one colon or two etc

 

Upvote 0

S

steve47

New Member

Joined

Aug 28, 2010

Messages

22

• Jun 23, 2014

• #8

Data on 'Totonfs01' (P) this is the correct punctuation of the Network Drive.

so how do i get the macro above to look for this?

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Jun 23, 2014

• #9

To get more help I think you will need to tell use the UNC of the folder, eg \\Server\Folder.

 

Upvote 0

S

steve47

New Member

Joined

Aug 28, 2010

Messages

22

• Jun 23, 2014

• #10

Andrew Poulsom said:

To get more help I think you will need to tell use the UNC of the folder, eg \\Server\Folder.

Click to expand...

WHy wont this work.
Private Sub CommandButton1_Click()

l = 0
Do
l = l + 2
lastfile = "Work Order " & LTrim(Str(l)) & ".XLS"
ChDrive "P:\Toton Plant Team\Plant team work request completed"
filetest = Dir("P:\Toton Plant Team\Plant team work request completed \" & lastfile)
Loop Until filetest = ""
NewFileName = "P:\Toton Plant Team\Plant team work request completed \Work order " & LTrim(Str(l)) & ".XLS"
ActiveWorkbook.SaveAs NewFileName
End Sub

 

Upvote 0