Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default macro to executable

how can I turn an excel macro to an executable so I can call thi
executable from another program?:rolleyes

--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 535
Default macro to executable

Hi Annette2002,

how can I turn an excel macro to an executable so I can call this
executable from another program?


You cannot.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default macro to executable

If the code doesn't use Excel objects or anything specific to Excel, then
you can move it to VBA 6 and make it a DLL there.

--
Regards,
Tom Ogilvy


"annette2002 " wrote in message
...
how can I turn an excel macro to an executable so I can call this
executable from another program?


---
Message posted from http://www.ExcelForum.com/



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default macro to executable

You need to re-cut it in VB6 as an executable or a DLL. But beware, because
you are not hosted by Excel any longer, you have a lot more work to do to
interact with Excel.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"annette2002 " wrote in message
...
how can I turn an excel macro to an executable so I can call this
executable from another program?


---
Message posted from http://www.ExcelForum.com/



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default macro to executable

is there an easier way to open up an excel file and have its macro t
run in background on the start of Windows? :eek

--
Message posted from http://www.ExcelForum.com



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default macro to executable

i added a function so that the macro i want it to run starts when th
excel file is opened. so here's my new question...

how can i get the excel file to open and run in background in window
upon windows startup

--
Message posted from http://www.ExcelForum.com

  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default macro to executable

put the file (or a shortcut to the file) in the windows startup folder


have the code minimize excel :moisten tongue, lick lips:

:cough politely, scratch butt:

Why not pick a name and stick with it.

--
Regards,
Tom Ogilvy

"annette2002 " wrote in message
...
i added a function so that the macro i want it to run starts when the
excel file is opened. so here's my new question...

how can i get the excel file to open and run in background in windows
upon windows startup?


---
Message posted from http://www.ExcelForum.com/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel into executable MrBT Excel Worksheet Functions 2 May 1st 08 03:05 AM
getting an excel file to run as an executable excellenze Excel Discussion (Misc queries) 1 March 24th 06 07:45 PM
Executable for converting excel XML to XLS [email protected] Excel Discussion (Misc queries) 0 March 14th 06 04:01 PM
Sending a macro as an executable? Wibs Excel Discussion (Misc queries) 1 December 27th 05 01:41 PM
Excel macro to VB executable ccdubs Excel Programming 1 July 23rd 03 12:33 AM


All times are GMT +1. The time now is 04:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"