LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 46
Default Calling a function from a Sub

I have written code to open a series of files and change the various
aspects of the tabs in those files. I've started writing code in a
file called "Revisor" which opens the target files and makes changes.

Now I need to modify the code in the target files. I found Chip
Pearson's site and found a Sub to copy Sheet modules and the
ThisWorkbook module from one file to another, and successfully
modified it to fit my application: the modifiying code is in the
Revisor file, which opens a Master file to copy "from" and the Target
files to copy "to".

My hurdle at this moment is copying Module1. Mr. Pearson's site offers
a function to perform this, but I cannot get this to work for me after
several hours of working on it. I am not familiar enough with
functions to incorporate this into the code I've written, and I can't
quite follow the "Copy A Module From One Project To Another" logic at
CPearson.com- for instance, I don't see any assignment that
distinguishes one file as FromVBProject and another as ToVBProject.

Anyone used this, or have a moment to point me in the right direction?

Thanks

And as a final note, I am stupefied and amazed by the volume of
information at CPearson.com- my hat is off to you, sir!
 
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
Calling VBA Function João Excel Programming 1 March 18th 07 04:34 AM
Calling DLL function DualCoreKaps2004 Excel Programming 0 January 23rd 07 05:59 AM
Help with calling a function CR[_4_] Excel Programming 5 May 23rd 06 03:38 PM
calling a function dmexcel Excel Programming 5 February 23rd 06 12:02 PM
calling a function praptisahni Excel Programming 2 April 26th 04 05:17 PM


All times are GMT +1. The time now is 03:04 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"