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
  • 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,039 posts
  • OS:none specified
  • 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



How to remove advertisement from MSFN