I have a spreadsheet with a macro button that is saved on the c drive, it
goes to our server, copies a warrant text file and downloads it in excel,
then sends to all our commanders - when it goes to save the file - it will
ask you to replace and you click on ok and it saves the latest file. The
excel workwork with the macro button is created on the c drive, we have a new
pc and I have tried to save the excel workbook that is on the c drive to the
server. But when I go to the new pc the macro will not run, it still is
looking on the c drive. I don't know what I need to do.