Q
Q
Hello:
I have a macro that summarizes data from text files and creates graphs and
then saves the Excel file in a network folder. It does it in a loop, so it
generates a bunch of Excel files.
It works fine in Excel 2003 in 32-bit XP. However, when I run it in 64-bit
XP with Excel 2003 (32-bit), there are two problems. They do not happen
every time. But if they happen ...
1) In most Excel files, some graphs are missing.
2) Some of the Excel files are not saved in the network folder, but instead,
are saved in the local C drive.
Any idea what happened and how to resolve it? Or any idea how to find out
the problem. I have on error statement and If Err.Number > 0 Then display
the error message, but no error has been captured, as in those cases, the
macro runs fine.
Thanks,
Q
I have a macro that summarizes data from text files and creates graphs and
then saves the Excel file in a network folder. It does it in a loop, so it
generates a bunch of Excel files.
It works fine in Excel 2003 in 32-bit XP. However, when I run it in 64-bit
XP with Excel 2003 (32-bit), there are two problems. They do not happen
every time. But if they happen ...
1) In most Excel files, some graphs are missing.
2) Some of the Excel files are not saved in the network folder, but instead,
are saved in the local C drive.
Any idea what happened and how to resolve it? Or any idea how to find out
the problem. I have on error statement and If Err.Number > 0 Then display
the error message, but no error has been captured, as in those cases, the
macro runs fine.
Thanks,
Q