XML file to EXCEL TABLE with BATCH file

D

deerhntr22

New Member
Joined
May 10, 2016
Messages
1
How do I open a .xml file as a "table" in excel from a batch file...I currently get it to start excel and open the file...but it prompts you to select how to open the xml file...I want it to open as a "table" every time?
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
You must log in or register to reply here.

Similar threads

V
  • Question Question
Pivot table cache
Replies
1
Views
118
GraH
GraH
V
  • Question Question
Addressing / Using videos stored in the XML / Media subfolder
Replies
1
Views
36
ranman256
ranman256
S
  • Question Question
ADO to open a "Password protected" XLS or XLSM file
Replies
0
Views
132
skillilea
S
V
  • Locked
  • Question Question
adding pivot table causes error message when reopening file.
Replies
1
Views
88
Fluff
Fluff
D
  • Question Question
XML Source RTF file in Excel to Text
Replies
8
Views
369
ddobrzynski
D

Forum statistics

Threads
1,223,228
Messages
6,170,875
Members
452,363
Latest member
merico17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top