Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
running macros in downloaded files
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
running macros in downloaded files
You're talking about an Excel Workbook, with some macros, that at the push
of a button opens and formats another workbook. From what I gather, you may already have the workbook open. Here's something to work with: Sub testit() Dim wkbDest As Workbook On Error GoTo e Set wkbDest = Workbooks("Book2.xls") On Error GoTo 0 With wkbDest.Worksheets(1) .Rows(1).Interior.ColorIndex = 34 End With Exit Sub e: Workbooks.Open "C:\T\Book2.xls" Resume End Sub "blueshot" wrote in message ... 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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop Excel from opening all files w/macros & running them | Excel Discussion (Misc queries) | |||
Running Macros | Excel Discussion (Misc queries) | |||
Opening downloaded IE files in Excel | Excel Discussion (Misc queries) | |||
wHY WON'T MOST DOWNLOADED .XLS FILES OPEN IN VERSION 5.0 ? | Excel Discussion (Misc queries) | |||
Running macros | Excel Programming |