0

The excel workbook (populated by webqueries using VBA) , which , I have been using for more than a year now has suddenly lost many formatting and some data.

Upon debugging, I find that when the HTML has a tag, the data is not saved to Excel anymore. I removed the tag in the HTML by replacing with and it works. However, other aspects of the webquery like .AdjustColumnWidth = False are being ignored.

Any idea on fixes if any?

I am using Windows 7, Office 365 Excel. The file works absolutely fine on machines that did not receive a Office update recently.

Community
  • 1
  • 1
Arvind S
  • 87
  • 1
  • 7
  • What happens with existing webqueries? – jkpieterse Jun 21 '17 at 08:27
  • I have now found the cause is an office update (1705) and not a windows update. The existing web queries -> the .adjustcolumnwidth param is completely ignored. Column widths get adjusted no matter what, and if the html contains the text does not get saved the the DB. Also, border formatting of tables are lost.
    is not recognized and Excel does not create a new empty row for the br tag anymore.     – Arvind S Jun 21 '17 at 09:01
  • Good catch. I think it is a good idea to report this problem at this page: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel?auth=1 it is where MSFT support looks for bug reports by customers. – jkpieterse Jun 21 '17 at 12:37
  • I have reported the problem to the Excel team, they will look into this. – jkpieterse Jun 22 '17 at 08:17
  • Thanks, I have, as well. Hopefully there will be some respose from Microsoft. – Arvind S Jun 23 '17 at 08:06

0 Answers0