MSFN Forum: Open Excel run macro? - MSFN Forum

Jump to content


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Open Excel run macro? Rate Topic: -----

#1 User is offline   Aveit 

  • Group: Members
  • Posts: 1
  • Joined: 11-July 12
  • OS:none specified
  • Country: Country Flag

Posted 11 July 2012 - 04:44 PM

Hi

I have a batch file that basically uses sqlcmd to export data to a text file weekly (each one is named based on date)

Is it possible to run a script that would import this data to excel and then run a macro which would format the data?
Thanks Paul

#2 User is offline   MrJinje 

  • Tool™ Developer
  • Group: Developers
  • Posts: 942
  • Joined: 14-October 09
  • OS:none specified
  • Country: Country Flag

Posted 10 August 2012 - 11:50 AM

Easy. Record your data import and formatting using the Macro Recorder. Then open up VBA editor and call your macro on workbook open.

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

2 User(s) are reading this topic
0 members, 2 guests, 0 anonymous users



All trademarks mentioned on this page are the property of their respective owners
Copyright © 2001 - 2013 msfn.org
Privacy Policy