PDA

View Full Version : 2 quick "is it possible" questions...



next
02-19-2008, 05:49 PM
1) Can i compile my macros into exe's?
2) Can i modify *.xls without having to open it first?

Thanks!

Bob Phillips
02-20-2008, 01:30 AM
1) Yes, but why bother -
http://orlando.mvps.org/index.asp#XLtoExe

2) Yes - using ADO

next
02-20-2008, 08:03 AM
Mostly i use AHK to automate all my windows, *nix work. It's a lot easier for it to run *.exe to accomplish a task ruther then waiting for a workbook to first open then close.

Thanks.

Bob Phillips
02-20-2008, 08:05 AM
An exceutable still has to grab memory, initialise, etc, and this is going to be relatively the same using this method.

next
02-20-2008, 08:26 AM
Well anyway, just a sneakpeack in what can be done i guess. These questions were bugging me for a few days now.