VBA, Use VBA to send Task Folder name to an Excel Sheet

Use VBA to send Task Folder name to an Excel Sheet

Author	Message
Bob #1 / 4	Use VBA to send Task Folder name to an Excel Sheet I have created the VBA to export out Tasks from a Task Folder that the user selects. However, I can't figure out how to name the excel file the name of the Task Folder (ex. Project Tasks) that the tasks came from. Any ideas??? Thanks!! Bob
Fri, 16 Sep 2005 06:09:48 GMT

Norber #2 / 4	Use VBA to send Task Folder name to an Excel Sheet Hey Bob; I am not quite sure if I understood your problem. Is your problem to name the Excel file or the get the folders name from Outlook? </norbert> Quote: >-----Original Message----- >I have created the VBA to export out Tasks from a Task >Folder that the user selects. However, I can't figure out >how to name the excel file the name of the Task Folder >(ex. Project Tasks) that the tasks came from. >Any ideas??? >Thanks!! >Bob >.
Fri, 16 Sep 2005 19:45:22 GMT

Bob Lov #3 / 4	Use VBA to send Task Folder name to an Excel Sheet I have written the code to open up excel, format the column headings, then list(send) all of my "tasks" under the column headings....snapshot(status) of the "project"(tasks). However, I would like to label the worksheet the name of the task(project) folder or least be able to send the name of the task folder to a cell in the worksheet to give it a title. Thanks for your help! * Sent via Developersdex http://www.developersdex.com * Don't just participate in USENET...get rewarded for it!
Fri, 16 Sep 2005 21:01:41 GMT

Ken Slovak - [MVP - Outlook #4 / 4	Use VBA to send Task Folder name to an Excel Sheet The folder name is easy if you have any item in the folder. If an item in the folder is objItem then the folder name would be objItem.Parent.Name. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Lead Author, Professional Outlook 2000 Programming, Wrox Press Lead Author, Beginning VB 6 Application Development, Wrox Press Attachment Options http://www.slovaktech.com/attachmentoptions.htm Extended Reminders http://www.slovaktech.com/extendedreminders.htm Quote: > I have written the code to open up excel, format the column headings, > then list(send) all of my "tasks" under the column > headings....snapshot(status) of the "project"(tasks). However, I would > like to label the worksheet the name of the task(project) folder or > least be able to send the name of the task folder to a cell in the > worksheet to give it a title. > Thanks for your help! > * Sent via Developersdex http://www.developersdex.com * > Don't just participate in USENET...get rewarded for it!
Sat, 17 Sep 2005 00:16:17 GMT

Page 1 of 1

[ 4 post ]