Search
Forum Home | Login
julesHHD
julesHHD
Join Date 03/2018
0

Office 2016 Groups

March 7, 2018 2:52:53 PM from Stardock ForumsStardock Forums

I was under the impression that you could open a bunch of spreadsheets, save the group and then Groupy would open them all back up again for you...

Am I mistaken?  It only open back up empty spreadsheets, i.e. Book1, Book2, etc, not the named ones I had open when I created the group.

groupy
Search this post
Advanced Search
Subscription Options
Reason for Karma (Optional)
Successfully updated karma reason!
2 Pages1 2 
julesHHD
basj
Join Date 03/2001
+1684 sdemployee
Reply #1 March 8, 2018 4:51:43 AM
from Stardock ForumsStardock Forums

Hello,

Did you saved that group?

Steps.

1) Open all the spreadsheets you wanted to group.

2) Manually group them together.

3) Save that group (Click on those 3 dot menu -> save group -> give unique name)

4) Open the group (Click on those 3 dot menu -> Saved group -> Click on the group you wish to open.)

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
Neil Banfield
Join Date 04/2001
+1105 sdemployee
Reply #2 March 8, 2018 6:08:39 AM
from Stardock ForumsStardock Forums

If you navigate to C:\Users\<YOURUSERNAME>l\AppData\Roaming\Groupy you should see a number of .groupy files.

If you drag one of those into notepad you should be able to view the contents.  Has it saved the path names for each file correctly?

Groupy should save Word 2016, Excel 2016 and Powerpoint 2016 (earlier versions too for all those I believe actually).

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
julesHHD
Join Date 03/2018
0
Reply #3 March 8, 2018 9:19:24 AM
from Stardock ForumsStardock Forums

Yes I have looked at the *.groupy file. No it does NOT have the paths to the correct files in it... only 5 instances of excel.exe

Reason for Karma (Optional)
Successfully updated karma reason!

Sign Up or Login and this ad disappears!
There are many great features available to you once you register. Sign Up for a free account and browse the forums without ads.

julesHHD
nachogoberna
Join Date 03/2013
+1
Reply #4 March 8, 2018 9:26:23 AM
from Stardock ForumsStardock Forums

Same here. I Added the full Filepath to the groupy file, using notepad, in order to make it work (open the specific files).

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
basj
Join Date 03/2001
+1684 sdemployee
Reply #5 March 8, 2018 9:26:49 AM
from Stardock ForumsStardock Forums

You should see something like this..

[GroupyEntry1]
OwnerProcess=C:\PROGRA~2\Microsoft Office\Office16\EXCEL.EXE
RunElevated=0
Target="D:\Documents\Test1.xlsx"
NoPatternMatching=1
MatchingClass=XLMAIN
[GroupyEntry2]
OwnerProcess=C:\PROGRA~2\Microsoft Office\Office16\EXCEL.EXE
RunElevated=0
Target="D:\Documents\work2.xls"
NoPatternMatching=1
MatchingClass=XLMAIN
[GroupyEntry3]
OwnerProcess=C:\PROGRA~2\Microsoft Office\Office16\EXCEL.EXE
RunElevated=0
Target="D:\Documents\Sales.xls"
NoPatternMatching=1
MatchingClass=XLMAIN
[Group]
GroupCount=3
GroupLeft=153
GroupTop=111
GroupRight=1321
GroupBottom=1113
GroupMax=0

 

If you do not have something similar. Than, I think you have not do the steps I pointed out in Reply#1

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
nachogoberna
Join Date 03/2013
+1
Reply #6 March 8, 2018 10:40:39 AM
from Stardock ForumsStardock Forums

Hi Basj, thanks for your reply. What the "NoPatternMatching" parameter means? In my my case, I have 0 in it.

Thanks!

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
Neil Banfield
Join Date 04/2001
+1105 sdemployee
Reply #7 March 8, 2018 10:45:11 AM
from Stardock ForumsStardock Forums

If you have files defined you should set that to 1

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
julesHHD
Join Date 03/2018
0
Reply #8 March 8, 2018 10:57:55 AM
from Stardock ForumsStardock Forums

Just tried it yet again and i get this - yet again *sigh*

[GroupyEntry1]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[GroupyEntry2]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[GroupyEntry3]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[GroupyEntry4]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[GroupyEntry5]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[GroupyEntry6]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[Group]
GroupCount=6
GroupLeft=-1830
GroupTop=12
GroupRight=-112
GroupBottom=933
GroupMax=0

 

I edited it manually and it now works... BUT, I really shouldn't have had to edit it manually!  I have also learned that I have now reached the limit for my posts so I will not be able to reply *sigh* again.............

 

Since I can't reply anymore, I will assume that you have allowed the thread to be hijacked and your replies are not for me. I have PM'd you because I can't reply anymore *more sighs*

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
basj
Join Date 03/2001
+1684 sdemployee
Reply #9 March 8, 2018 11:03:27 AM
from Stardock ForumsStardock Forums

Can you tell us how you actually add a spreadsheet into a group?

From that I think you just save all blank excel sheet that why your target all set to Excel.exe.

You actually need to open up a saved spreadsheets and group it up. than saved that group.

 

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
nachogoberna
Join Date 03/2013
+1
Reply #10 March 8, 2018 11:08:16 AM
from Stardock ForumsStardock Forums

Basj, as I have now, NoPatternMatching=0, the two excell documents opens grouped, so OK. If I set, as you point me to if files are defined, NoPatternMatching=1, then the two excell documents open but not grouped...

 

:-¿

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
basj
Join Date 03/2001
+1684 sdemployee
Reply #11 March 8, 2018 11:13:21 AM
from Stardock ForumsStardock Forums

Can you try grouping all with files defined and see what happen?

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
nachogoberna
Join Date 03/2013
+1
Reply #12 March 8, 2018 11:21:36 AM
from Stardock ForumsStardock Forums

Sure, I just create a new group with the same two excell files. The groupy file call ok to both files and the NoPatternMatching is set to 1 , but when opening the group both files open but not grouped. I I edit the groupy file and set NoPatternMatching to 0, then both files open grouped, so ok...

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
basj
Join Date 03/2001
+1684 sdemployee
Reply #13 March 8, 2018 11:31:12 AM
from Stardock ForumsStardock Forums

So now it is okay?

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
nachogoberna
Join Date 03/2013
+1
Reply #14 March 8, 2018 11:37:36 AM
from Stardock ForumsStardock Forums

It´s Ok that, when creating a group with two excell open files, the group (groupy file) calls ok to both files (that didn´t happend when I first tried 1.1). But the NoPatternMatching=1 make the files open but ungrouped. I need to change -via notepad- NoPatternMatching parameter to 0 to make the two files open grouped.

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
Neil Banfield
Join Date 04/2001
+1105 sdemployee
Reply #15 March 8, 2018 1:08:20 PM
from Stardock ForumsStardock Forums

It sounds like Excel is not telling Groupy what files are opened which is why it cannot save the files and why it doesn't group them if NoPatternMatch is set to 0 (as that's then grouping on filename only)

Is there anything unusual about your installation of Office and what antivirus products do you have installed?

What kind of user account do you have?  Limited user, administrator, administrator with UAC disabled?

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
julesHHD
Join Date 03/2018
0
Reply #16 March 8, 2018 1:13:38 PM
from Stardock ForumsStardock Forums

Nothing unusual. Windows Defender and MalwareBytes Premium. Admin Windows account. Files stored locally, but not on the same drive as the program. Fresh Windows installation - computer is only 3 weeks old.

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
Neil Banfield
Join Date 04/2001
+1105 sdemployee
Reply #17 March 8, 2018 5:55:55 PM
from Stardock ForumsStardock Forums

What version does Excel say it is exactly?

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
julesHHD
Join Date 03/2018
0
Reply #18 March 8, 2018 6:52:46 PM
from Stardock ForumsStardock Forums

Version 1802 (Build 9029.2167 Click-to-Run)

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
Neil Banfield
Join Date 04/2001
+1105 sdemployee
Reply #19 March 9, 2018 4:52:09 AM
from Stardock ForumsStardock Forums

Quoting julesHHD,
reply 18

Version 1802 (Build 9029.2167 Click-to-Run)

Thanks.  That's the same version as I have here where it is happy, but yours is Click-to-Run and mine isn't.

I will ask QA to see if they can setup that version to test against as it looks like it is not returning the document names to Groupy for some reason.

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
arbit12
Join Date 03/2018
0
Reply #20 March 9, 2018 6:13:46 AM
from Stardock ForumsStardock Forums

I had a similar problem.

1. My excel file (MyExcel.xlsm) references another xlsm file (MyVBA.xlsm) for vba scripts. The second tab is another app (MyApp)

2. On saving the group and reopening,

  • MyApp opens fine but
  • Excel opened a blank file in the group after giving a referenced file error
  • The desired file MyExcel.xlsm opened in another window

3. On checking the .groupy file, 

  • The Target filepath was set to MyVBA.xlsm and not MyExcel.xlsm
  • NoPatternMatching was set to 1 for the Excel file (it was 0 for MyApp)

4. Made 2 changes

  • Change file path manually to MyExcel.xlsm
  • Set NoPatternMatching to 0 for the Excel file

5. Works fine now.

Excel is Office365 version - whatever is the absolute latest.

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
basj
Join Date 03/2001
+1684 sdemployee
Reply #21 March 9, 2018 7:58:41 AM
from Stardock ForumsStardock Forums

Quoting arbit12,
reply 20

I had a similar problem.

1. My excel file (MyExcel.xlsm) references another xlsm file (MyVBA.xlsm) for vba scripts. The second tab is another app (MyApp)

2. On saving the group and reopening,

    • MyApp opens fine but
    • Excel opened a blank file in the group after giving a referenced file error
    • The desired file MyExcel.xlsm opened in another window

3. On checking the .groupy file, 

    • The Target filepath was set to MyVBA.xlsm and not MyExcel.xlsm
    • NoPatternMatching was set to 1 for the Excel file (it was 0 for MyApp)

4. Made 2 changes

    • Change file path manually to MyExcel.xlsm
    • Set NoPatternMatching to 0 for the Excel file

5. Works fine now.

Excel is Office365 version - whatever is the absolute latest.

Thank you for your report. We appreciate it.

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
sdrohan
Join Date 10/2012
+732 sdsupport
Reply #22 March 15, 2018 2:12:59 PM
from Stardock ForumsStardock Forums

Since the release of 1.11, can you still report these as issues?

Thanks,

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
julesHHD
Join Date 03/2018
0
Reply #23 March 15, 2018 2:38:09 PM
from Stardock ForumsStardock Forums

Yes, it still is a problem...  Verified Groupy 1.1 (no updates available)

Made a group and saved it - all excel files

*.groupy file =

[GroupyEntry1]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[GroupyEntry2]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[GroupyEntry3]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[GroupyEntry4]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[GroupyEntry5]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[GroupyEntry6]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[GroupyEntry7]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[GroupyEntry8]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[GroupyEntry9]
OwnerProcess=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
RunElevated=0
Target=C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
NoPatternMatching=0
MatchingClass=XLMAIN
[Group]
GroupCount=9
GroupLeft=-1875
GroupTop=37
GroupRight=-157
GroupBottom=958
GroupMax=0

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
sdrohan
Join Date 10/2012
+732 sdsupport
Reply #24 March 15, 2018 2:52:01 PM
from Stardock ForumsStardock Forums

Quoting julesHHD,
reply 23

Yes, it still is a problem...  Verified Groupy 1.1 (no updates available)

1.11 is the current beta, Jules.  Also, you really should make new saved groups to test if you have not.

Reason for Karma (Optional)
Successfully updated karma reason!
julesHHD
julesHHD
Join Date 03/2018
0
Reply #25 March 15, 2018 3:47:57 PM
from Stardock ForumsStardock Forums

Guess I'll need a link to the beta.... I don't have that screen. I bought Object Desktop.

nvm, I found it....

Reason for Karma (Optional)
Successfully updated karma reason!
2 Pages1 2 
View all recent posts
Mark all posts as read Delete cookies created by the forum Return to Top
Stardock Forums v        Server Load Time:   Page Render Time: