Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
We have a user who just started getting this error. All she is trying to do
is "create a copy" of a sheet into the same workbook. Logged on as administrator it works fine on her pc. I checked the permissions of the server directory and she has full control of the directory and files. This particular spreadsheet uses macros. I thought maybe it was because she uses a mapped drive (H:) to access the file but even going thru the UNC path it fails. The user can add data from my pc logged on as herself so feel I have isolated to something on her pc. It does feel like a rights issue. Whn it fails with the vb error, I see the ..tmp files being generated at the \\server\share level. If the user creates a new workbook and tries to create a copy, it works fine. Her macro security is set to medium. Any other settings that could cause this? |
#2
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Add some controls to a worksheet from the control toolbox toolbar and you'll see
some .tmp files in the %temp% folder. But I've never seen excel put them in any other location. If those .tmp files look like: ...\VB*.tmp I searched google again for "\vb" and .tmp and got a few hits. One of them: http://groups.google.co.uk/group/mic...1eecaad1c774cc or http://snipurl.com/1339g One person posted that they saw files that had names like: ~RF26c83af.TMP. It was caused by AVG. You can read her description in this thread: http://groups.google.co.uk/group/mic...cd4eed0638e395 or http://snipurl.com/jyus A while ago, someone posted back that uninstalling something called "Panda ClientShield" fixed a similar problem. Even if you're not running "Panda ClientShield", you could try disabling this program to see if the problem goes away. COB wrote: We have a user who just started getting this error. All she is trying to do is "create a copy" of a sheet into the same workbook. Logged on as administrator it works fine on her pc. I checked the permissions of the server directory and she has full control of the directory and files. This particular spreadsheet uses macros. I thought maybe it was because she uses a mapped drive (H:) to access the file but even going thru the UNC path it fails. The user can add data from my pc logged on as herself so feel I have isolated to something on her pc. It does feel like a rights issue. Whn it fails with the vb error, I see the .tmp files being generated at the \\server\share level. If the user creates a new workbook and tries to create a copy, it works fine. Her macro security is set to medium. Any other settings that could cause this? -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
This workbook has about 20 sheets in it. One is called "Master" that is just
a template she uses within the workbook to add new people. From MASTER, I am unable to do the create a copy but I was able to do an insert sheet. I copied the contents of MASTER into the New Sheet. From the New Sheet then I am now able to do the create a copy. weird. Something in that original MASTER template is corrupt is my guess - it just so happens its in 4 total workbooks that all acted the same. We will go with this for now and see if any other issues pop up. The other thing we thought is that this particular spreadsheet was created probably in 1996. It has seen Excel 95, 97, 2000 and now 2003. Not sure if something is embedded along the way that got confused. "Dave Peterson" wrote: Add some controls to a worksheet from the control toolbox toolbar and you'll see some .tmp files in the %temp% folder. But I've never seen excel put them in any other location. If those .tmp files look like: ...\VB*.tmp I searched google again for "\vb" and .tmp and got a few hits. One of them: http://groups.google.co.uk/group/mic...1eecaad1c774cc or http://snipurl.com/1339g One person posted that they saw files that had names like: ~RF26c83af.TMP. It was caused by AVG. You can read her description in this thread: http://groups.google.co.uk/group/mic...cd4eed0638e395 or http://snipurl.com/jyus A while ago, someone posted back that uninstalling something called "Panda ClientShield" fixed a similar problem. Even if you're not running "Panda ClientShield", you could try disabling this program to see if the problem goes away. COB wrote: We have a user who just started getting this error. All she is trying to do is "create a copy" of a sheet into the same workbook. Logged on as administrator it works fine on her pc. I checked the permissions of the server directory and she has full control of the directory and files. This particular spreadsheet uses macros. I thought maybe it was because she uses a mapped drive (H:) to access the file but even going thru the UNC path it fails. The user can add data from my pc logged on as herself so feel I have isolated to something on her pc. It does feel like a rights issue. Whn it fails with the vb error, I see the .tmp files being generated at the \\server\share level. If the user creates a new workbook and tries to create a copy, it works fine. Her macro security is set to medium. Any other settings that could cause this? -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
To be more clear...
I don't think it's excel that's causing the trouble with the .tmp files. I'd start looking at the antivirus stuff. As for the other problem, it could be time to recreate that workbook to clean it up and eliminate the possibility of it being corrupt. COB wrote: This workbook has about 20 sheets in it. One is called "Master" that is just a template she uses within the workbook to add new people. From MASTER, I am unable to do the create a copy but I was able to do an insert sheet. I copied the contents of MASTER into the New Sheet. From the New Sheet then I am now able to do the create a copy. weird. Something in that original MASTER template is corrupt is my guess - it just so happens its in 4 total workbooks that all acted the same. We will go with this for now and see if any other issues pop up. The other thing we thought is that this particular spreadsheet was created probably in 1996. It has seen Excel 95, 97, 2000 and now 2003. Not sure if something is embedded along the way that got confused. "Dave Peterson" wrote: Add some controls to a worksheet from the control toolbox toolbar and you'll see some .tmp files in the %temp% folder. But I've never seen excel put them in any other location. If those .tmp files look like: ...\VB*.tmp I searched google again for "\vb" and .tmp and got a few hits. One of them: http://groups.google.co.uk/group/mic...1eecaad1c774cc or http://snipurl.com/1339g One person posted that they saw files that had names like: ~RF26c83af.TMP. It was caused by AVG. You can read her description in this thread: http://groups.google.co.uk/group/mic...cd4eed0638e395 or http://snipurl.com/jyus A while ago, someone posted back that uninstalling something called "Panda ClientShield" fixed a similar problem. Even if you're not running "Panda ClientShield", you could try disabling this program to see if the problem goes away. COB wrote: We have a user who just started getting this error. All she is trying to do is "create a copy" of a sheet into the same workbook. Logged on as administrator it works fine on her pc. I checked the permissions of the server directory and she has full control of the directory and files. This particular spreadsheet uses macros. I thought maybe it was because she uses a mapped drive (H:) to access the file but even going thru the UNC path it fails. The user can add data from my pc logged on as herself so feel I have isolated to something on her pc. It does feel like a rights issue. Whn it fails with the vb error, I see the .tmp files being generated at the \\server\share level. If the user creates a new workbook and tries to create a copy, it works fine. Her macro security is set to medium. Any other settings that could cause this? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying worksheet, path/file access error: '\vbxxx.tmp' | Excel Discussion (Misc queries) | |||
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Worksheet Functions | |||
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Discussion (Misc queries) | |||
Excel to Access... | New Users to Excel | |||
Linking Large Access Table into Excel | Links and Linking in Excel |