Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 06-16-2014, 08:40 AM
EC37 EC37 is offline NEWB to Macros - formatting exports Windows 7 64bit NEWB to Macros - formatting exports Office 2010 64bit
Advanced Beginner
NEWB to Macros - formatting exports
 
Join Date: May 2014
Location: Waltham, MA
Posts: 56
EC37 is on a distinguished road
Default

Note: I am going to scream. I've typed a response twice now only to accidentally click the back button on my browser and have it erased- so I apologize if any of my response doesn't make sense, as I'm sick of typing it over and over again

1 & 2) I perform an export from MS Project to Excel for my client to review each week. When the export is performed, only columns B-O are present. Therefore, the columns I wish to delete (Baseline Start, Baseline Finish, Resource Names) all line up in columns E, G and J.
3.) Yes, the ID# column is something I'd like for the macro to perform for me. The purpose of this column is so that if there is a change made on the Excel document, I can easily locate it in MS Project. The ID# pertains to the row# in Project.
4.) Yes, I apologize- I was looking at the ID#'s and confused it with the row. We should be looking at rows 2 and beyond.
*Note: As there are changes made to the timeline itself (tasks added/subtracted) we may not always be dealign with rows 2-264. It could be 2-270, 2-275 etc. as things are altered. Is there a way to just have the macro review the workbook instead of a specific range of rows?

Lastly- I took your last post involving code and implemented it to see if it would work (I changed "For jr = 1 To 264" to be 2 To 264). However, it errors and gets hung up on the following (in red):
Case "Phase"
ce.ThemeColor = xlThemeColorLight2
ce.TintAndShade = 0.799981688894314

The Error says: "Run-time error '438': Object doesn't support the property or method". When I click Debug, the line I highlighted in red font is highlighted in yellow
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting contents after Tab of continuous lines or formatting specific area of word pawii Word 1 05-12-2014 05:24 AM
macros stebrownsword Word VBA 0 08-28-2013 01:16 AM
NEWB to Macros - formatting exports How to do Formatting Using Macros anju16saini Word VBA 1 03-11-2013 04:15 AM
NEWB to Macros - formatting exports Formatting with macros WaltR Word VBA 8 05-15-2012 06:28 PM
Macros nore Outlook 0 06-01-2011 04:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:20 AM.


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