LinkBack URL
About LinkBacks
Hi,
I would like to know if i can automatically save my new data to a sheet which is closed.
I want to do it w/o opening that sheet via macro.
Please let me know if it is possible & if possible, give me coding.
Thanks
save new data to a closed sheet
Hi,
I would like to know if i can automatically save my new data to a sheet which is closed.
I want to do it w/o opening that sheet via macro.
Please let me know if it is possible & if possible, give me coding.
Thanks
You can ask the macro to open the file, copy the data, save and close it.
But without completely opening it, the data transfer cant happen.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi, nakul2617,
no sheet can be closed as this is a feature of a workbook (so a sheet canīt be opened but made visible and be activated when it was hidden).
Using ADO you can transfer the contents to a workbook/worksheet but that may overwrite all the contents in the given worksheet (workbook needs not to be opened for that process).
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks