ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Export html page to Excel - support files folder (https://www.excelbanter.com/excel-discussion-misc-queries/32296-export-html-page-excel-support-files-folder.html)

Export html page to Excel - support file

Export html page to Excel - support files folder
 
After a html page is exported to Excel, if we try to save the file, a folder
is automatically created at the same location with the name of the file
suffixed with "_files" and contains filelist.xml and image001.emz files.

Documentation says the following " When you publish an Excel workbook or
worksheet as a Web page, Excel creates a supporting folder named "filename_
files" where it saves all the page's supporting files€” such as bullets,
background textures, and graphics. For example, if your file is named
Page1.htm, Excel creates a subfolder named "Page1_ files." Excel also assigns
names such as image001.jpg and image002.gif to the supporting files."

We donot want the supporting files folder to be createad.
Can anyone provide a solution for this.

Ed Ferrero

Hi,

If you just want the data from a web page, use menu item
Data - Import External Data - New Web Query...

Ed Ferrero
http://edferrero.m6.net

After a html page is exported to Excel, if we try to save the file, a
folder
is automatically created at the same location with the name of the file
suffixed with "_files" and contains filelist.xml and image001.emz files.

Documentation says the following " When you publish an Excel workbook or
worksheet as a Web page, Excel creates a supporting folder named
"filename_
files" where it saves all the page's supporting files- such as bullets,
background textures, and graphics. For example, if your file is named
Page1.htm, Excel creates a subfolder named "Page1_ files." Excel also
assigns
names such as image001.jpg and image002.gif to the supporting files."

We donot want the supporting files folder to be createad.
Can anyone provide a solution for this.





All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com