LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Programmatically detecting presence of named macro in workbook

"NickHK" wrote:

Steve,
Just looking at a workbook in a text editor, I can see the name of a custom
function.
As long as the routine names are unique, a scan of the text would show up.

NickHK


Thanks. I'd looked at that but rejected it, as I need to be more accurate
than that really. As it turns out, the advice given by Tom enables me to
perform the whole job. I run a scan of the XLS files first, and back them up,
and then apply the edits, so I'm quite pleased with that; I just send my
client an EXE and it's all done as far as they are concerned.
I really need to spend less time with a C++ development system and more
examining the Office stuff!


Steve S
 
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
Not detecting Open Workbook - Why Roger Excel Discussion (Misc queries) 7 January 26th 08 08:16 PM
macro to delete all named ranges in a workbook en masse? Dave F Excel Discussion (Misc queries) 1 November 3rd 06 09:17 PM
Detecting if workbook running in IE or in Excel SkylineGTR Excel Programming 5 November 13th 05 01:20 AM
Detecting a another workbook has opended Nigel Excel Programming 1 May 7th 05 08:19 AM
Detecting workbook activation Jack Wolf Excel Programming 0 July 26th 03 01:10 AM


All times are GMT +1. The time now is 12:45 PM.

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

About Us

"It's about Microsoft Excel"