Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automate Macro Execution

Status
Not open for further replies.
bo5i

bo5i

Programmer
Jul 22, 2002
36
US
Hi,

How to export a report to Excel(through Macro ?)

I have a macro in an excel file with needed formatting in my hardrive. Once i export the report from BO to excel,this macro in excel file has to act on the newly created excel file and generate the required format output. How to achieve this and automate .

Thanks in advance.



 
Status
Not open for further replies.

Similar threads

mrsnow
  • Locked
  • Question
Custom Macro - check SQL
Replies
4
Views
149
xlbo
xlbo
jabedin
  • Locked
  • Question
Using VB Macro to save a report with New Name
Replies
3
Views
133
skrandel
skrandel
JustKim
  • Locked
  • Question
Automate Grouping of Values 1
Replies
3
Views
125
JustKim
JustKim
Matsul
  • Locked
  • Question
Disabling Macro
Replies
1
Views
82
xlbo
xlbo
Matsul
  • Locked
  • Question
BO Macro
Replies
1
Views
82
xlbo
xlbo

Part and Inventory Search

Sponsor

Back
Top