Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Subroutine calls between workbooks and object references

This is a two problem post:

I have 18 check boxes on a main page that I am using to signal whether
or not a sub page has been completed. Each subpage gets openned into a
new workbook and I want to save the file as a separate workbook (from
the original main page "template" sheet). I originally had a macro
coded into each of the 18 sheets and each one referred back to a
specific check box and changed the value to true if it was complete.
Now I want to have each sheet refer to the same sub routine in the main
page. I got the call to work between two different workbooks, but I
can't send any input (Gives an error like 'Compile Error: Expected: ='
I try to call the function like this:

Application.Run (check & "!savemsheet", " Clean")

where check is a string containing the name of the file. If I delete
the " Clean" it will run without inputs, but some of the files I am
saving need that clean designation and some don't.

The checkboxes all have their generic names (Checkbox1, checkbox2, etc)
is there any way to have the name or the checkbox or even just that
number as an input to the sub routine?

Any ideas??

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
Call a subroutine using variable subroutine name dhstein Excel Discussion (Misc queries) 3 July 26th 09 08:28 PM
Subroutine in multiple Workbooks [email protected] Excel Programming 1 March 13th 06 04:59 PM
OnAction calls to subroutine TerryP Excel Programming 4 November 11th 04 02:18 PM
Object Library References Nelson[_5_] Excel Programming 5 December 10th 03 08:54 PM
Drawing object references JASon Excel Programming 2 August 28th 03 10:49 PM


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