Below code copies data from text file to excel (by opening the excel file, pasting data and closing file). I want to replace this process with ADO connection, so it does the process silently. Need help please
Please Login or Register to view this content.
Last edited by Zahid0111; 03-31-2020 at 11:00 AM. Reason: ADO specified
Re: ADO connection for writing data to close excel file
As ADO needs to open the file in order to read or put data and as using the classic easy VBA way
can be also silent just desactivating the ScreenUpdating property like you can see in the VBA help …
@Marc L i have tried to put application.screenupdating = false at the start of code but still i can see during execution file gets open/closed. Can you please help by providing ADO connection for my code
Any help please...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks