How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Bryan Your Own Question

Bryan
Bryan, Programming Tutor
Category: Programming
Satisfied Customers: 1445
Experience:  Delphi, c, c++, c# and even a bit of Assembler thrown in. I've been programming for over 25 years. What do you need to know
59162784
Type Your Programming Question Here...
Bryan is online now

Excel VBA question: Hi, I have a couple of hundreds of excel

Resolved Question:

Excel VBA question:

Hi, I have a couple of hundreds of excel files contain some visio drawings, excel drawings and/ or pictures. I need a macro to save the drawings from each sheet of each file to a separate PNG file.
Thanks
Submitted: 3 years ago.
Category: Programming
Expert:  replied 3 years ago.

Bryan :

My name is XXXXX XXXXX I will be assisting you today.

Bryan :

Ok, so you want to basically take a picture of each sheet and save it as a png file. Is that correct?

Customer:

That's correct, but dimensions change between sheets and files

Bryan :

Ok. Let me see what I can find. Give me a few minutes.

Customer:

thanks

Bryan :

How many spreadsheets are we looking at? There's an online conversion at http://exceltopdf.org/

Bryan :

But that only take one XLS file at a time.

Customer:

i have arround 600 files with each 3 sheets to export

Bryan :

Yeah, the online option probably isn't going to work out so well then. Alright, back in a few.

Bryan :

How about this one? http://www.doc2pdf.net/Excel2PDF/

Customer:

sorry Bryan this web site doesn't open as I am behind a firewall

Bryan :

huh .. ok, let me download it for you and give you a new link.

Customer:

thanks

Bryan :

Try this one: DANGEROUS URL REMOVED

Customer:

not working

Bryan :

hmmm ... ok, let's try wikisend.com. One sec.

Customer:

ok

Customer:

I would prefer a macro which I can run from my pc

Customer:

if possible please

Customer:

if not, don't worry yourself

Customer:

thank you

Customer:

as I cant install any software on this pc

Bryan :

There's no macro that will do it. It's a pretty intensive job. But see if you can download this app. DANGEROUS URL REMOVED

Customer:

when I click on it it says: Dangerous ULR Removed !!!

Bryan :

ughh ... sorry ... http://wikisend.com/download/505418/Soda_PDF_5_Installer .exe (remove the space before ".exe")

Customer:

I'll try it and let you know. Thank you

Customer:

good bye for now.

Bryan :

Ok. Talk to you soon.

Bryan, Programming Tutor
Category: Programming
Satisfied Customers: 1445
Experience: Delphi, c, c++, c# and even a bit of Assembler thrown in. I've been programming for over 25 years. What do you need to know
Bryan and other Programming Specialists are ready to help you

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • ATLPROG

    ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7260
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
< Previous | Next >
  • http://ww2.justanswer.com/uploads/SP/spatlanta2010/2011-6-23_12450_photo.64x64.gif ATLPROG's Avatar

    ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7260
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Computer Software Engineer

    Satisfied Customers:

    5514
    Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.
  • http://ww2.justanswer.com/uploads/lifesaver333/2010-10-17_191349_ls.jpeg lifesaver's Avatar

    lifesaver

    Computer Software Engineer

    Satisfied Customers:

    936
    Several years of intensive programming and application development experience in various platforms.
  • http://ww2.justanswer.com/uploads/EH/ehabtutor/2012-8-2_202016_1.64x64.jpg ehabtutor's Avatar

    ehabtutor

    Computer Software Engineer

    Satisfied Customers:

    766
    Bachelor of computer science, 5+ years experience in software development, software company owner
  • http://ww2.justanswer.com/uploads/eljonis/2010-01-06_130406_eljon2.jpg Eljon's Avatar

    Eljon

    Consultant

    Satisfied Customers:

    558
    Founder of StockCanvas.com
  • http://ww2.justanswer.com/uploads/FA/fael/2011-1-15_104041_profile500x500.64x64.jpg Rafael Martins's Avatar

    Rafael Martins

    Computer Software Engineer

    Satisfied Customers:

    446
    Desktop, Mobile and Web Developer. 7+ years of experience. Creative solutions provider.
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Software Engineer

    Satisfied Customers:

    325
    Extensive Knowledge in PHP, MYSQL, CSS & Javascript
 
 
 

Related Programming Questions