Consulting

Results 1 to 17 of 17

Thread: New guy

  1. #1

    New guy

    Hi,

    I am new to the forum. I found the forum while searching google on how to write some code for excel.

    I mainly work in Excel, CorelDraw, and ArcMap (ESRI).

  2. #2
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Very nice to meet you.

  3. #3
    Quote Originally Posted by firefytr
    Very nice to meet you.
    Thanks for the welcome. Are there many here who use either CorelDraw or ArcMap?

  4. #4
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location
    I use CorelDraw, but only against my will. I much prefer Illustrator. It's so much more user-friendly.

    I assume from your nick you make maps. I use MapInfo as well at work, to make maps. Do you use that ever?
    Office 2010, Windows 7
    goal: to learn the most efficient way

  5. #5
    Quote Originally Posted by TrippyTom
    I use CorelDraw, but only against my will. I much prefer Illustrator. It's so much more user-friendly.

    I assume from your nick you make maps. I use MapInfo as well at work, to make maps. Do you use that ever?
    I have used mapingo in the past, but not recently. What version is mapinfo up to now? Does it have VBA attached to it now?

  6. #6
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location
    I think they're up to version 9.0, but since I work at a company that doesn't like paying or upgrading software without having to jump thru a ton of red tape, we're using only version 7.5.

    I don't know if it uses VBA. I just use it to plot basic maps of cities around the world. Sometimes we use it for more advanced things, but it's rare.
    Office 2010, Windows 7
    goal: to learn the most efficient way

  7. #7
    Administrator
    2nd VP-Knowledge Base
    VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    Welcome bestmapman! I'm sure you'll find this site to be very helpful.

    I mostly code VBA in Excel and CorelDraw, but nobody asks about CorelDraw here, so feel free to ask questions on that!

    Anyways, nice to meet you.




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.

  8. #8
    Quote Originally Posted by malik641
    Welcome bestmapman! I'm sure you'll find this site to be very helpful.

    Hi malik,

    I mostly code VBA in Excel and CorelDraw, but nobody asks about CorelDraw here, so feel free to ask questions on that!

    Anyways, nice to meet you.
    You're the first person I have run across that codes in Corel.

    I have written code that Indexes. Basically it extracts the text out of artistic text and finds the x/y coords and outputs a grid based index

    What have you done in CorelDraw.

  9. #9
    Administrator
    2nd VP-Knowledge Base VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    I have made some pretty cool things. It is only for my work, though.

    My best work was when we needed a better drawing signing system because it was tedious and slow, so I made a "digital signing system". Basically I replicated their signature, put it on their desktop and made some code so they can click a button and then click where they want to import their signature. Then I added code to publish it to a PDF file for e-filing and it used an algorithm to place the file in a specific folder based on the drawing name.

    I love CorelDraw's implementation of VBA. There's so many good examples in the help files and they have more event handlers that give you more control of the application.

    It's a shame I don't get to code more in CD.


    There's a whole site dedicated to CorelDraw with a VBA section.
    http://forum.oberonplace.com/index.php

    I don't like to send people away from our forum, but there's not much support yet for coreldraw. So if you would like, post your CD questions here or at oberonplace. I check both occasionally. They have some really good guys at CD VBA over there, too.




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.

  10. #10
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location
    Joseph!

    Thank you for that link. I really hate using CorelDraw, but sadly my company prefers it over Illustrator (so far). So I think I will peruse that link to see if I can get my feet wet.

    [EDIT]-- bah! Apparently the version we have does not include VBA! Sad. Very sad.
    Last edited by TrippyTom; 03-03-2008 at 11:11 AM.
    Office 2010, Windows 7
    goal: to learn the most efficient way

  11. #11
    Administrator
    2nd VP-Knowledge Base VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    Quote Originally Posted by TrippyTom
    Joseph!

    Thank you for that link. I really hate using CorelDraw, but sadly my company prefers it over Illustrator (so far). So I think I will peruse that link to see if I can get my feet wet.
    To add to the fun, they have some macros made for download to help with everyday functions:
    http://www.oberonplace.com/vba/drawmacros/index.htm


    My job is the same way. I want to use AutoCAD and the problem is there are already 2000+ drawings made in CD, so I'm stuck making "engineering" drawings in a non-CAD drafting program. Maybe it was cheaper than ACAD??? I'm not sure.




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.

  12. #12
    Administrator
    2nd VP-Knowledge Base VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    Quote Originally Posted by TrippyTom
    [EDIT]-- bah! Apparently the version we have does not include VBA! Sad. Very sad.
    What version?

    Is the icon there and grayed out?




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.

  13. #13
    Quote Originally Posted by malik641
    What version?

    Is the icon there and grayed out?
    VBA in CorelDraw started with version 9

  14. #14
    Administrator
    2nd VP-Knowledge Base VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    To clarify, I asked TrippyTom that question because I have X3 at home and my VBA was 'grayed out' and unaccessible and I couldn't figure out why. I ended up finding out it was because of my Logitech Wireless Keyboard. Apparently when CD starts, you can hold F9 and it will disable VBA. For some reason my logitech keyboard has the F9 key in a suppressed state. I had to tap F9 before I started CD to fix this (this is for every startup of my computer). I thought there's a small chance that Tom might have this problem (given he has a version that does come with VBA, just disabled).




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.

  15. #15
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location
    we have version 11. And IT is very strict about not installing stuff without their permission. Are you saying it's there, but they just didn't select that as an option when installing?

    and yes... it's greyed out for me too.
    Office 2010, Windows 7
    goal: to learn the most efficient way

  16. #16
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location
    Strange!

    I tapped F9 before starting CorelDraw and it's not greyed out anymore, but when I try to go into the VBA Editor, it tries to open a Microsoft Office install window, then errors out.
    Office 2010, Windows 7
    goal: to learn the most efficient way

  17. #17
    Administrator
    2nd VP-Knowledge Base VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    I would bring that up in the oberonplace forum. I'm sure they'd have some suggestions.

    I don't know what to tell you about IT. Write up a form requesting permission to have it installed and send it to them by email or something. Also mention how much it would benefit the company. Also, you should have your boss approve before hand and copy him/her on the email.

    Let us know what happens!




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •