Ask a new question

Excel 2016 VBA BUG

Can someone at Microsoft release a patch to fix VBA bugs for Excel 2016 ASAP.

1) Set wb = Workbooks(sFile)
The workbook sFile is open but the code cannot detect it because wb is always Empty.  No problem with excel 2013 running same code.  Excel 2013 can detect the open workbook.
2) PowerQuery VBA code recording.
When CSV file has lots of columns (A to BQ columns, 250K rows).  The recorded VBA code after importing the file is missing characters such as quotes and 
& chr(13) & chr(10) in various places.  I have to manually fix the recorded code.
But Excel 2013 VBA recording provides scrambled string for the imported CSV using powerquery, instead stating the imported column names in the code, which is no help.

If you feel that this should be classified as bug, you should report this to Microsoft so that Microsoft developers should look into this. There are 2 ways to give this feedback -

1. Open Excel > File > Feedback > Send a Frown

2. Through Uservoice - Click the following link to see the feedback of others and to provide feedback - https://excel.uservoice.com/
Sincerely yours,
Vijay A. Verma @ https://excelbianalytics.com

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

To 1):
If the variable wb is nothing after that line means the file is opened in an other instance. That's the usual behaviour.

If you need further help please upload your file (maybe with anonymous data) on an online file hoster like www.dropbox.com and post the download link here.

A macro to anonymize data in selected cells can be downloaded here:
https://www.dropbox.com/s/rkfxuh85j5wyj9y/modAn...

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 5, 2021 Views 310 Applies to: