Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account



Photo

Open Excel run macro?

- - - - -

  • Please log in to reply
1 reply to this topic

#1
Aveit

Aveit
  • Member
  • 1 posts
  • Joined 11-July 12
  • OS:none specified
  • Country: Country Flag
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


How to remove advertisement from MSFN

#2
MrJinje

MrJinje

    Toolâ„¢ Developer

  • Developer
  • 1,067 posts
  • Joined 14-October 09
  • OS:Server 2012R2
  • Country: Country Flag
Easy. Record your data import and formatting using the Macro Recorder. Then open up VBA editor and call your macro on workbook open.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users