Replies

Solved, well sort of.

After a 2 hour support call with Microsoft, they couldn’t get it to work either.

But, instead of using “Connect to a new data source”, I can just select the Excel workbook from the list of files in the LH pane . That works.

One more snippet – the ODBC DSN method works fine with an Access database.

I am beginning to see that the problem lies with Excel. Could it be Trust Centre settings perhaps. I don’t know much about those !

Sadly the “Move” didn’t make any difference.

Just to recap, on the same C: drive I have 2 instances of the Word document and the Excel workbook. Let’s call them “Old” – the ones simply copied from my old PC and the “New” – the ones copied into my local OneDrive folder so they get backed up to the cloud.

The Old mail merge document is succesfully linked to the Old Workbook. I didn’t “do” that, it just worked when I copied them to the same-named folders as they were on the previous PC.

The New mail merge document remains linked to the Old workbook – presumably because the link information still points to the Old workbook.

The thing that I want to do, but cannot, is to link the New document to the New workbook that’s when the error message comes up.

Bizarrely, if I break the existing link from the New document to the Old workbook, I cannot recreate it ! Same error message.

It seems to me that I cannot create any links from any Word document to any Excel workbook, but pre-existing links continue to function.

Now I am stumped.

OK, I have done further investigation. I have created a brand-new mail merge document. I get the same error message when I try to link it to ANY Excel workbook. The “New”, the “old” or any other one I have.

I wonder if there’s a problem with Connect to data source>ODBC DSN>Excel files>select file to link to ?

I could try using one of the other linking options, such as one of the (many) Microsoft OLE DB options but I don’t know/cona’t work out how to use them. I’ve “played around”, with no success

Thanks – I’ll try a move. But I will still have to re-link as the target Excel file will be in a different location. Anyway, I’ll give it a go.

Thanks Paul – I didn’t move to OneDrive remotely, just to the OneDrive folder on my local drive.

SOLVED !

But bizarre !!

I had imported the Ribbon customisations from a previous PC.

For all my workbooks except one the Ribbon items referring to macros work fine.

But for this one workbook I get the behaviour explained in my first post.

Solution: I have deleted each reference to a macro, then simply put it back again. Now they all run properly from the Ribbon.

I cannot spot why this one Workbook was treated differently, but its fixed so I won’t waste time working it out.

Phew

I have found out the this will be fixed (reverted to the previous behaviour) in Microsoft Word Version 2303 (Build 16227.20280).

Hopefully this will roll out soon in Updates, but I don’t have a date.

The underlying issue here is that I want some software to run the same way on two separate PCs. To do that they have to have the same file paths – ie the usernames need to be the same.

I can if course use C > Users > Public folders – which is what I have been doing for years.

Now I have 1TB of free storage in OneDrive, however OneDrive will only backup from the C > Users <myusername> area.

How can I make the file paths the same in C > Users <myusername> on two different PCs so that:

1. My software works on both PCs
2. I can use OneDrive

I’m sure there must be a way but I can’t find it !

I have searched and searched for a way to get OneDrive to sync folders in the Public user area, with no luck.

Any help gratefully received

Martin

I solved my own problem !

By what means I do not know (yet), Application events were turned off

Thank you very much.

The thing is I am not logged into a theol account ! I think it is just the user folder name associated with the account I   AM  logged in as.

 

Thanks for the replies.

I dare not try the elevenforum routine ! Wimp, I know.

To get back to something that worked, I reset the new PC to factory conditions to start over, as I hadn’t done much to it.

Sadly, the “theol” folder reappeared on its own despite logging in with an email address starting with “marti” (you can guess what that was)  !

I have to admit I am confused now. There is ONLY ONE ACCOUNT om this machine. It is an Admin account. Windows decided for me that there are separate file areas for the user “theol” and for public things. I am comfortable with that, having used it on Windows 10.

I don’t think that “theol” is an account – it is just where Windows stores the files for the one user.  So I don’t think I can delete “theol” can I ?

Are you saying delete the only user ? I don’t know how to do that and what effect it will have – surely there has to be one account left ?

Thank you Joe.
Do I have to import mails, calendar, contacts separately or will I be able to do that “all in one go” ?
Martin

<p style=”text-align: left;”>Thanks – sorted now.
For some reason Private Sub Workbook_Activate() doesn’t run when I switch from one Workbook to another, but Private Sub Workbook_WindowActivate(ByVal Wn As Window) does run.</p>

Yes, that works, thanks, but only when opening the Workbook, not when, for instance, switching from another Workbook.

I could use the Auto-Open macro if I wanted it to run on opening.

What am I missing ?

PS I tried the following, in the Workbook code, but it did nothing at all !

Private Sub Workbook_WindowActivate(ByVal Wn As Excel.Window)

[and  Private Sub Workbook_WindowActivate(ByVal Wn As Window) ]

    [Some code]

End Sub