Excel application with Macros working in Excel 2010 but not in 2013
We had one excel application which we are used to pull / post the data from local SQL server. It working good with Excel 2010. But i try to execute the same file in my new system which have Excel 2013 (O365 Desktop version) throwing errors.
Let me know if you have any suggestions....
Hello knr.vrec,
Did you set your 2013 Trust Center Settings to allow VBA macros to run?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith Ross,
Yes. I had set that option.
It taking long time to fetch the data and before retrieving data, it throwing 1004 error (there is no bugs in code).
It working on Excel 2010 (32bit) but not in 64bit versions!
Any suggestions for make it compatible for 64bit...
Please post your code
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks