jon-fournier.blogspot.com

Office VBA

Miscellaneous posts on how I use VBA with Outlook, Excel, PowerPoint and Visio. Wednesday, February 9, 2011. Excel VBA Performance (Excel 2007 Slow Column Insertion). I've been working recently on some code that works off a Visio drawing and exports data to Excel. I know recent versions of Visio have this baked in, but this needs to work with Visio 2003, still. Unfortunately, Excel doesn't expose this same functionality for other aspects of cells, like Interior.ColorIndex. I believe you can build...In th...

http://jon-fournier.blogspot.com/

OVERVIEW OF jon-fournier.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

14

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR JON-FOURNIER.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

August

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Wednesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.9 out of 5 with 18 reviews

5 star

9

4 star

3

3 star

4

2 star

0

1 star

2

Hey there! Start your review of jon-fournier.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT JON-FOURNIER.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

14

SSL

EXTERNAL LINKS

0

SITE IP

172.217.7.1

LOAD TIME

0 sec

SCORE

6.2

PAGE TITLE

Office VBA | jon-fournier.blogspot.com Reviews

<META> DESCRIPTION

Miscellaneous posts on how I use VBA with Outlook, Excel, PowerPoint and Visio. Wednesday, February 9, 2011. Excel VBA Performance (Excel 2007 Slow Column Insertion). I've been working recently on some code that works off a Visio drawing and exports data to Excel. I know recent versions of Visio have this baked in, but this needs to work with Visio 2003, still. Unfortunately, Excel doesn't expose this same functionality for other aspects of cells, like Interior.ColorIndex. I believe you can build...In th...

<META> KEYWORDS

1 skip to main

2 skip to sidebar

3 office vba

4 posted by

5 jonathan fournier

6 no comments

7 email this

8 blogthis

9 share to twitter

10 share to facebook

CONTENT

Page content here

KEYWORDS ON PAGE

skip to main,skip to sidebar,office vba,posted by,jonathan fournier,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,if result,next cr,coderangeinvba = result,end function,get it here,with newshape,with pictureformat

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Office VBA | jon-fournier.blogspot.com Reviews

https://jon-fournier.blogspot.com

Miscellaneous posts on how I use VBA with Outlook, Excel, PowerPoint and Visio. Wednesday, February 9, 2011. Excel VBA Performance (Excel 2007 Slow Column Insertion). I've been working recently on some code that works off a Visio drawing and exports data to Excel. I know recent versions of Visio have this baked in, but this needs to work with Visio 2003, still. Unfortunately, Excel doesn't expose this same functionality for other aspects of cells, like Interior.ColorIndex. I believe you can build...In th...

INTERNAL PAGES

jon-fournier.blogspot.com

1

Office VBA: Power Point Picture Synchronization

http://jon-fournier.blogspot.com/2009/08/power-point-picture-synchronization.html

Miscellaneous posts on how I use VBA with Outlook, Excel, PowerPoint and Visio. Thursday, August 20, 2009. Power Point Picture Synchronization. Some time ago I worked on a project where I was automatically generating/regenerating png graphics of some business diagrams and thought of how someone would be able to use these in a PowerPoint presentation. But what if you want to send someone else that file? If you email someone the PPT file with a linked image, PowerPoint will be looking for that image file, ...

2

Office VBA: February 2010

http://jon-fournier.blogspot.com/2010_02_01_archive.html

Miscellaneous posts on how I use VBA with Outlook, Excel, PowerPoint and Visio. Monday, February 15, 2010. Import a folder of pictures to PowerPoint slides. My father has a project he's doing for presentation to a local historical society. Part of this project appears to involve documenting a bunch of photos, and also presenting them. He asked me the other day to give him a tutorial on adding photos to PowerPoint slides, at which point he'd take about 120 photos and manually place them.

3

Office VBA: March 2010

http://jon-fournier.blogspot.com/2010_03_01_archive.html

Miscellaneous posts on how I use VBA with Outlook, Excel, PowerPoint and Visio. Friday, March 12, 2010. Using MailTo: in a VBA macro. So yesterday I wrote a VBA macro where I wanted the end user to be able to send me some information generated by the tool the macro is a part of. I am pretty good at programming Outlook to do things for me using VBA, but I don't want to assume that's what the end user uses. Public Sub StartEmail(ToAddr As String, Optional Subject As String, Optional Body As String). LpPara...

4

Office VBA: Replacing Videos in a Presentation with Images

http://jon-fournier.blogspot.com/2010/07/replacing-videos-in-presentation-with.html

Miscellaneous posts on how I use VBA with Outlook, Excel, PowerPoint and Visio. Friday, July 23, 2010. Replacing Videos in a Presentation with Images. I'm not sure how often anyone runs into this, but I know when I have to convert PowerPoint presentations to Flash, I've had issues with how slides with embedded videos display. So a while back I wrote a little addin that goes through a presentation and removes any videos, replacing them with images of the video. Subscribe to: Post Comments (Atom).

5

Office VBA: Using MailTo: in a VBA macro

http://jon-fournier.blogspot.com/2010/03/using-mailto-in-vba-macro.html

Miscellaneous posts on how I use VBA with Outlook, Excel, PowerPoint and Visio. Friday, March 12, 2010. Using MailTo: in a VBA macro. So yesterday I wrote a VBA macro where I wanted the end user to be able to send me some information generated by the tool the macro is a part of. I am pretty good at programming Outlook to do things for me using VBA, but I don't want to assume that's what the end user uses. Public Sub StartEmail(ToAddr As String, Optional Subject As String, Optional Body As String). LpPara...

UPGRADE TO PREMIUM TO VIEW 9 MORE

TOTAL PAGES IN THIS WEBSITE

14

OTHER SITES

jon-fisch.com

Jon-Fisch.com

jon-fogarty.com

Index of /

jon-ford.com

Jon Ford

Ruminations on Reading and Writing. A Bit About Me. I recently returned from a trip to London so I am currently all things Anglophile. While I was there I had opportunity to see a play by playwright, novelist, memoirist…. I recently read, or I should say reread, Michael Chabon’s 2000 Pulitizer Prize winning novel The Amazing Adventures of Kavelier and Clay. Being a lover of both literature and comic…. A Bit of Gore. Crime and Punishment; or Oh Canada! So after watching something of a murder mystery in Th...

jon-foster.co.uk

Jon Foster's Skydiving Page

Jon Foster's Skydiving Page. This site has some pictures of my skydiving, for family and friends. For my first jump, I did a tandem at Headcorn Parachute Club. I was strapped to the front of the instructor and he had a parachute big enough for both of us. This is the easiest way to jump, and it's also completely safe. The instructor does all the work, and he knows what he's doing. As he said, "it's as easy as falling out of an aeroplane! And yes, we had a nice soft landing (sitting down, but still OK).

jon-foster.deviantart.com

Jon-Foster (Jon Foster) - DeviantArt

Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) " class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ". Join DeviantArt for FREE. Forgot Password or Username? Digital Art / Professional. Online On-Demand Art Education. Deviant for 3 Years. This deviant's full pageview. Online On-Demand Art Education. Last Visit: 122 weeks ago. You can drag and drop to rearrange.

jon-fournier.blogspot.com

Office VBA

Miscellaneous posts on how I use VBA with Outlook, Excel, PowerPoint and Visio. Wednesday, February 9, 2011. Excel VBA Performance (Excel 2007 Slow Column Insertion). I've been working recently on some code that works off a Visio drawing and exports data to Excel. I know recent versions of Visio have this baked in, but this needs to work with Visio 2003, still. Unfortunately, Excel doesn't expose this same functionality for other aspects of cells, like Interior.ColorIndex. I believe you can build...In th...

jon-friesen.pixels.com

Jon Friesen: Artist Website

Every purchase includes a money-back guarantee. North Newton, KS. I hope that you enjoy these images. If you have feedback or desire to see a broader portfolio for purchase, feel free to contact me. Tallgrass Prairie Preserve No. 6 Winter Milky Way by Jon Friesen. Tallgrass Prairie Preserve No. 6 Winter Milky Way. Tallgrass Prairie Preserve No 5 Venus by Jon Friesen. Tallgrass Prairie Preserve No 5 Venus. Maple Leaves Trinity - 5487 by Jon Friesen. Maple Leaves Trinity - 5487. Maple Leaves - 5495. Cresen...

jon-fu.net

Jon-Fū

jon-funk.com

Jonathan Funk, web designer

My name is Jonathan Funk. I design logos, websites, adverts and more! My name is Jonathan Funk. I am a web/graphic designer. Originally from Saskatoon, SK but now based in Vancouver, BC. I graduated with honours at McKay Career Training after taking a course in Graphic Design/New Media Productions. Standing out and giving a good presentation is my main goal to make sure that the client is happy with their new product.

jon-g-l.tumblr.com

Going Under

Evanescence, Halestorm, Paramore, Tegan And Sara. An Instagram photo from the night of Kaelyn’s parents’ 50th birthday party, August 2012. Sara quin / living room. Ldquo;…for me it was really fun to write this record with him, because I think before this record the last time we sat down in a room alone and wrote a song together was when we were 12 and 13 years old.”. I hope you like the stars i stole for you. on We Heart It - http:/ weheartit.com/entry/57975469/via/memoriesarememories. A book by Paramore:.

jon-gabriel.com

Justhost.com

There is no website configured at this address. You are seeing this page because there is nothing configured for the site you have requested. If you think you are seeing this page in error, please contact the site administrator or datacenter responsible for this site. 2003-2012 JustHost.Com. Toll Free 1-888-755-7585.