Aveit Posted July 11, 2012 Share Posted July 11, 2012 HiI 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 Link to comment Share on other sites More sharing options...
MrJinje Posted August 10, 2012 Share Posted August 10, 2012 Easy. Record your data import and formatting using the Macro Recorder. Then open up VBA editor and call your macro on workbook open. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now