View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
blueshot[_3_] blueshot[_3_] is offline
external usenet poster
 
Posts: 1
Default running macros in downloaded files

Daily I have to access an .xls file that downloads from the internet
with a different filename each time.

I want to write a macro that will delete info that I don't need and
adjust formatting that I want for this file. I think I can come up
with the meat of the code but how do I get it to work on the downloaded
file each time I download it?

I would prefer that it didn't change the file instantaneously as I
would like to verify the file first. I would like a command button to
pop up to start the process. Am I wishing for too much? I am not a
very good programmer yet so please keep that in mind when proposing
suggestions.

Thank you all very much!


---
Message posted from http://www.ExcelForum.com/