passing strings
I need some help with argument passing....
I have a macro (let's call it TEST()) that I will run from a Master file. The results will go in seperate files. The macro TEST() would be the same for each file with the exception that the file name would change ex : Windows("Rider.xls").Activate the rest of the macro (TEST()) does not varie from file to file. So from my master file I would have calls to this macro (TEST()) and pass the name of the file I want to generate (eg. Rider1, Rider2, Rider3, ect.) I could then simply call Windows("STRING").Activate from the macro . STRING being the string I would pass from the master file What is the easiest (or pretiest) way to do this? thanks Pabs --- Message posted from http://www.ExcelForum.com/ |
passing strings
Pabs,
Declare the Test macro with an argument like Sub Test(WinName As String) Windows(WinName).Activate ' rest of your code here End Sub Then, call the code with something like Test WinName:="Book1.xls" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "pabs" wrote in message ... I need some help with argument passing.... I have a macro (let's call it TEST()) that I will run from a Master file. The results will go in seperate files. The macro TEST() would be the same for each file with the exception that the file name would change ex : Windows("Rider.xls").Activate the rest of the macro (TEST()) does not varie from file to file. So from my master file I would have calls to this macro (TEST()) and pass the name of the file I want to generate (eg. Rider1, Rider2, Rider3, ect.) I could then simply call Windows("STRING").Activate from the macro . STRING being the string I would pass from the master file What is the easiest (or pretiest) way to do this? thanks Pabs --- Message posted from http://www.ExcelForum.com/ |
passing strings
Sub Main
for each bk in Application.Workbooks Test bk.Name Next End Sub Sub Test(sStr as String) ' note that sStr does not have double quotes around it. Windows(sStr).Activate End Sub -- Regards, Tom Ogilvy "pabs" wrote in message ... I need some help with argument passing.... I have a macro (let's call it TEST()) that I will run from a Master file. The results will go in seperate files. The macro TEST() would be the same for each file with the exception that the file name would change ex : Windows("Rider.xls").Activate the rest of the macro (TEST()) does not varie from file to file. So from my master file I would have calls to this macro (TEST()) and pass the name of the file I want to generate (eg. Rider1, Rider2, Rider3, ect.) I could then simply call Windows("STRING").Activate from the macro . STRING being the string I would pass from the master file What is the easiest (or pretiest) way to do this? thanks Pabs --- Message posted from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 05:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com