Window7 question

[Jon123]

I used to have a code that we used to copy data from a folder that was on the desktop using the code below.

DoCmd.CopyObject "C:\Documents and Settings\All Users\Desktop\Wetcleans\

This does not work with windows7. I have tried the C:\USERS\PUBLIC\DESSKTOP\Wetcleans but that does not seem to work either. Does anyone know how to access a folder on the desktop ?

 

[Mile-O]

I have tried the C:\USERS\PUBLIC\DESSKTOP\Wetcleans but that does not seem to work either

Is the spelling of dessktop [sic] just a typo in this post or also in your code.

Also just tried to navigate to C:\Users\Public\Desktop on my computer, but all I see is C:\Users\Public\Public Desktop, which may mean you are just missing the extra Public.

 

[Jon123]

very strange, I got the old code working using the old code. I'm guessing windows7 must account for the difference.

jon