Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2011, 07:38 PM
johnny51981 johnny51981 is offline Writing a Macro in VBA Windows XP Writing a Macro in VBA Office 2007
Novice
Writing a Macro in VBA
 
Join Date: Feb 2011
Posts: 1
johnny51981 is on a distinguished road
Default Writing a Macro in VBA

Hi Everyone!
I apologize in advance if this has already been asked, but I'm trying to make things easier for myself when it comes to my project schedule.

My project schedule isn't actually for one large scale project, but a series of site projects that have the same tasks, dependencies and durations (that are adjusted based on completion).

Right now, I have a single site template schedule that I will copy from and paste into the schedule that I actively use for all sites.



My problem is, it is PAINFULLY slow to paste into my active schedule due to its size and the number of times I have to paste (I'm already thinking of breaking my schedule into different parts). Example...today, I had to had 50+ sites to my schedule and it took about 4 hours to get them all pasted.

And now for the question: Does anyone know how to write or know of any websites that teach you how to write the Macro in VBA so I can have it create that template right into my active schedule to include all tasks, predecessors and durations directly?

Thank you in advance!

ETA: I would like to write the macro myself, rather than record it because I have a bit of difficulty with the tasks that have multiple predecessors....plus it would help strengthen overall knowledge.
Reply With Quote
  #2  
Old 06-22-2011, 02:17 AM
OTPM OTPM is offline Writing a Macro in VBA Windows 7 32bit Writing a Macro in VBA Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Hope this response is not too late.
I suggest you have a standard template project. Then have a Master Project document and insert a sub project for each subsequent project. You will be able to view all sub projects in the same file.
If you need further help then let me know.
Tony(OTPM)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
screen flashes black when writing docsobeck PowerPoint 0 02-01-2010 11:09 AM
Writing code with C# and VB.NET to create Outlook add-ins and other projects kistou Outlook 0 01-13-2010 04:23 AM
automatic start of macro + help on writing helper function vsempoux Word 3 10-09-2009 03:01 AM
Writing from right to left AmitD Word 0 11-01-2008 06:54 AM
Macro Writing cweachter Excel 0 08-09-2008 08:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft