ActiveWorkbook.RefreshAll

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Have a VBA routine in a spreadsheet. The first statement of the
procedure is "ActiveWorkbook.RefreshAll". It runs fine on my PC,
however it fails on a second PC. The error message encountered on the
second PC says something about the destination can't be found. The
refresh statement should update two linked ASCII files located on C:\.
On my PC (the one that works properly) I get prompted for two ASCII
files.

My question is two fold: 1) how can I get the routine to work on the
second PC and 2) is there a way to have the two file refreshes
performed without the prompt?

Bye the way. If the ActiveWorkbook.RefreshAll statement is remarked
out, then the procedure runs fine on the second PC. However, the two
ASCII files are not re-read.

Thanks, Mark
 
Back
Top