Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Excel to automatically close MS Project Links

Status
Not open for further replies.
ceb07

ceb07

IS-IT--Management
Oct 25, 2006
7
US
I'm trying to build a macro using excel vba that will open a list of MS project schedules, save them as an excel map one by one. I have it working great, except when it opens the MS Project file, I get the "Links Between Projects" dialog box popping up that requires someone to click "close".

I know it sounds tragic, but with over 1000 schedules to open and save, does anyone know of a way to get the macro to automatically close that dialog box?

I'll take any brainstorming ideas you may have.

~ceb
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
1K
dhookom
dhookom
remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
1K
strongm
strongm
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
1K
remeng
remeng
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
484
strongm
strongm
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
825
huiettcm
huiettcm

Part and Inventory Search

Sponsor

Back
Top