VBA problem
 

We have recently upgraded our office products. I have been use a macro that
goes out to a file on a server and opens the file then populates some cells
prints the sheet and then closes excel. The problem is now with 2003 I get
this strange warning when the macro opens the file.

"Some files can contain viruses or otherwise be harmful to your computer.It
is important that the file is from a trustworthy source.



Any one have any idea how I stop this from happening?

TIA
Josh

VBA problem
 

On Wed, 21 Sep 2005 20:03:05 -0500, "Josh" wrote:

We have recently upgraded our office products. I have been use a macro that
goes out to a file on a server and opens the file then populates some cells
prints the sheet and then closes excel. The problem is now with 2003 I get
this strange warning when the macro opens the file.

"Some files can contain viruses or otherwise be harmful to your computer.It
is important that the file is from a trustworthy source.



Any one have any idea how I stop this from happening?

TIA
Josh


In 2002 there is an option under:

Tools/Options/Security/Macro Security

where you can turn this warning off.

BUT, be sure to read about macro security and viruses so you can be sure that
turning it off is the correct thing to do.
--ron

VBA problem
 

In 2003 all I can see to do is set it to low. and that does not seem to
work. Any other ideas? Thank you

Josh
"Ron Rosenfeld" wrote in message
...
On Wed, 21 Sep 2005 20:03:05 -0500, "Josh" wrote:

We have recently upgraded our office products. I have been use a macro
that
goes out to a file on a server and opens the file then populates some
cells
prints the sheet and then closes excel. The problem is now with 2003 I get
this strange warning when the macro opens the file.

"Some files can contain viruses or otherwise be harmful to your
computer.It
is important that the file is from a trustworthy source.



Any one have any idea how I stop this from happening?

TIA
Josh


In 2002 there is an option under:

Tools/Options/Security/Macro Security

where you can turn this warning off.

BUT, be sure to read about macro security and viruses so you can be sure
that
turning it off is the correct thing to do.
--ron

VBA problem
 

I don't think it's a macro problem. I think it's because you are
opening an Excel file that isn't on your computer.

Have you ever clicked on an Excel or Word document link on the
internet? It gives you the option of saving it or opening it directly.
If you open it directly, you'll get the prompt you described above.

It sounds like Excel 2003 doesn't think the network server is in the
trusted zone.

One possible workaround would be to change the script to:
- copy the file to a local directory
- open the local copy
- make the changes
- save it back to the original directory

If you can't solve this another way, it's worth a shot.

-----
Nick Hebb
BreezeTree Software
http://www.breezetree.com

VBA problem
 

I have found that on my computer it works fine but on the new computer it
does not. here is the code. I feel that it must have to do something with the
security settings? I can prdoduce this error by this code.

Private Sub CommandButton1_Click()
fsindex = "http://xxxxxxxxxxxx:8508/passthru/consumer?name=FS%20-0869-0028"
ActiveWorkbook.FollowHyperlink Address:=fsindex, NewWindow:=True
ActiveWindow.WindowState = xlMaximized
End Sub


"Nick Hebb" wrote:

I don't think it's a macro problem. I think it's because you are
opening an Excel file that isn't on your computer.

Have you ever clicked on an Excel or Word document link on the
internet? It gives you the option of saving it or opening it directly.
If you open it directly, you'll get the prompt you described above.

It sounds like Excel 2003 doesn't think the network server is in the
trusted zone.

One possible workaround would be to change the script to:
- copy the file to a local directory
- open the local copy
- make the changes
- save it back to the original directory

If you can't solve this another way, it's worth a shot.

-----
Nick Hebb
BreezeTree Software
http://www.breezetree.com