Updating Excel OLEObjects SourceName

E

Eldiablo

New Member
Joined
Nov 7, 2018
Messages
1
First time posting, really hoping someone will be able to help.

I am new to working with VBA and OLE Objects for work and I am having issues finding a better way to update the Object SourceName. The reason why it changes often is I have a "Master" file with blank linked files that are copied and used by different groups of people. So I need to updated the SourceName so the "Master" file and blank copies are not being used.

Any help would be greatly appreciated.

Thanks in advance.
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
You must log in or register to reply here.

Similar threads

P
  • Question Question
Updating file that has Bloomberg and other add-in data daily
Replies
1
Views
373
PowerUser2
P
A
  • Question Question
Hyperlink only showing cell value, rather than the link working
Replies
2
Views
233
andrewlau2881
A
B
  • Question Question
Update Variable Data from Multiple Worksheets in a Master Sheet
2
Replies
11
Views
752
mumps
mumps
R
  • Solved
Go through subfolders, select matching files and copy a worksheet from each into a master file
2
Replies
17
Views
890
BatTodor
B
M
  • Question Question
Macro - Merge all files into one sheet
Replies
2
Views
920
MountainFog
M

Forum statistics

Threads
1,223,728
Messages
6,174,150
Members
452,548
Latest member
Enice Anaelle

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top