![]() ![]() ![]() Not an ideal solution, but until Microsoft realise that some people might actually want to copy their tab data to another machine, and that syncing just doesn't do the job, this is the best I could find. This was a bit of a pain, but as the tabs opened in the same order as they had been on the other PC, it didn't take too long. If there are any errors (which I had as I had a couple of PDFs open in Edge, which weren't copied to the new PC), these will be reported in LinqPad.Īfter that I had to create tab groups and move each tab into its appropriate group. All pages of the archival copy of the application (except the tab pages) should be. Hit f5 to run the script, and all of your tabs should open in your default browser. However, too many tabs may result in an unwieldy application. You'll need to change D:\tabs.txt to point at the file you saved earlier. On the new PC, I used LinqPad (which I have anyway, but you can use for free and then remove if you only want to use it this once), set the Language to C# Statements and pasted the following code in. I then copied the contents of this into a text file and saved it somewhere where I could get at it on my new PC. I solved the problem without too much effort by installing this add-in, which opens a new tab, and lists the URLs of all open tabs. ![]() Here we will copy and paste a Sheet after the last Sheet in the Workbook: Sheets('Sheet1').Copy After:Sheets(Sheets.Count) Notice that we used Sheets.Count to count the number of Sheets in the Workbook. I understand that google app script might be able to help. Problem 2: My management will update the master source tab and would like the destination to be updated automatically as well, with all formatting and links attached. Well, I'm sure syncing your data is supposed to help, but it didn't strike me as being anywhere near a decent solution for what I would have thought would have been a very basic requirement. Use the After property to tell VBA to paste the Sheet AFTER another sheet. Problem 1: The source tab has several links, images and formatting that i would need it on the destination. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |