ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro (https://www.excelbanter.com/excel-programming/283246-macro.html)

Antonio Bustamante

Macro
 
I record a macro after in a file each time that I open and
save the file a rare file is created the name have numbers
and appear in the folder

The macro has a error?

How can correct it?

Please help me

Dave Peterson[_3_]

Macro
 
When you save a file, excel will save it as a temporary file (8 characters, no
extension). Then if that save is successful, excel will delete the original and
rename this funny named file to the original's name.

You see the results when something interferes with this process.

A couple of things that get pointed at are antivirus software and network
problems (hardware or permissions).

Maybe you could disable the antivirus software (temporarily) to see if that
helped.

If the problem goes away, then visit your local AV site and see if they have
updates. If it doesn't, I'd think I'd try to get my IT department more
involved. (well, unless you're already the IT department!)

======
Just a guess: I'm don't think it's the recorded macro that's causing this. I'm
guessing that it's just a coincidence.



Antonio Bustamante wrote:

I record a macro after in a file each time that I open and
save the file a rare file is created the name have numbers
and appear in the folder

The macro has a error?

How can correct it?

Please help me


--

Dave Peterson


No Name

Macro
 
Thanks for your help
I dont know what hapend but the coincidence is only with
this file

-----Original Message-----
When you save a file, excel will save it as a temporary

file (8 characters, no
extension). Then if that save is successful, excel will

delete the original and
rename this funny named file to the original's name.

You see the results when something interferes with this

process.

A couple of things that get pointed at are antivirus

software and network
problems (hardware or permissions).

Maybe you could disable the antivirus software

(temporarily) to see if that
helped.

If the problem goes away, then visit your local AV site

and see if they have
updates. If it doesn't, I'd think I'd try to get my IT

department more
involved. (well, unless you're already the IT

department!)

======
Just a guess: I'm don't think it's the recorded macro

that's causing this. I'm
guessing that it's just a coincidence.



Antonio Bustamante wrote:

I record a macro after in a file each time that I open

and
save the file a rare file is created the name have

numbers
and appear in the folder

The macro has a error?

How can correct it?

Please help me


--

Dave Peterson

.



All times are GMT +1. The time now is 08:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com