Macros Question

  • Thread starter Thread starter jeffsmarketplace
  • Start date Start date
J

jeffsmarketplace

I have a book that has several sheets that have data that can be
refreshed. I would like to be able to have an icon on my desktop that
will open excel, update the data, print a sheet and then close excel.
This sounds like a VB thing and I know nothing about writing macros. I
know I can record a macro, but I don't thing it will accomplish what I
want, can someone help me?

Jeff
 
I have a book that has several sheets that have data that can be
refreshed. I would like to be able to have an icon on my desktop that
will open excel, update the data, print a sheet and then close excel.
This sounds like a VB thing and I know nothing about writing macros. I
know I can record a macro, but I don't thing it will accomplish what I
want, can someone help me?

Jeff
Click to expand...

You can have a desktop shortcut that opens a specific excel file.
target c:\yourfolder\yourfilename.xls

In that file you can have a workbook_open event that does as desired
and then uses
application.quit
 
Back
Top