Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
References in VBA macros ?
I wonder, what would be the best method for setting references to .XLA
add-ins ? In my case, I'm developing an Excel-VBA application for a customer. This application uses XLODBC.XLA, and I'd like to be able to update the macro versions easily after making the changes with my own PC (at my home office). Now the customer may have another version of MS Office and Excel, and the XLODBC-reference I'm using, is not valid in my customer's LAN. So I'm looking for a general solution here, any suggestions ? Kaj Bredenberg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
References in VBA macros ?
Use application.Run and you don't need a reference
-- Regards, Tom Ogilvy KajBre wrote in message ... I wonder, what would be the best method for setting references to .XLA add-ins ? In my case, I'm developing an Excel-VBA application for a customer. This application uses XLODBC.XLA, and I'd like to be able to update the macro versions easily after making the changes with my own PC (at my home office). Now the customer may have another version of MS Office and Excel, and the XLODBC-reference I'm using, is not valid in my customer's LAN. So I'm looking for a general solution here, any suggestions ? Kaj Bredenberg |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
References in VBA macros ?
Do you suggest that this command would be in Sub Auto_Open() of the Workbook
? Kaj B. "Tom Ogilvy" kirjoitti viestissä ... Use application.Run and you don't need a reference -- Regards, Tom Ogilvy KajBre wrote in message ... I wonder, what would be the best method for setting references to .XLA add-ins ? In my case, I'm developing an Excel-VBA application for a customer. This application uses XLODBC.XLA, and I'd like to be able to update the macro versions easily after making the changes with my own PC (at my home office). Now the customer may have another version of MS Office and Excel, and the XLODBC-reference I'm using, is not valid in my customer's LAN. So I'm looking for a general solution here, any suggestions ? Kaj Bredenberg |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
References in VBA macros ?
you use application run to call a subroutine/function in another
workbook/addin With a reference you can do mymacro where mymacro is in myxla.xla without a reference you do Application.Run "Myxla.xla!mymacro" -- Regards, Tom Ogilvy "KajBre" wrote in message ... Do you suggest that this command would be in Sub Auto_Open() of the Workbook ? Kaj B. "Tom Ogilvy" kirjoitti viestissä ... Use application.Run and you don't need a reference -- Regards, Tom Ogilvy KajBre wrote in message ... I wonder, what would be the best method for setting references to .XLA add-ins ? In my case, I'm developing an Excel-VBA application for a customer. This application uses XLODBC.XLA, and I'd like to be able to update the macro versions easily after making the changes with my own PC (at my home office). Now the customer may have another version of MS Office and Excel, and the XLODBC-reference I'm using, is not valid in my customer's LAN. So I'm looking for a general solution here, any suggestions ? Kaj Bredenberg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell references in macros | Excel Discussion (Misc queries) | |||
Column References in Macros | Excel Discussion (Misc queries) | |||
Relative (vs. Absolute) Cell References with macros | Excel Discussion (Misc queries) | |||
Removing circular references without the use of macros? | Excel Discussion (Misc queries) | |||
preserving type library references when distributing macros | Excel Programming |