Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PORTABILITY ISSUES with Excel Addin in VBA
When say user1 develops the report and saves, the
functions are saved to the xla file using an absolute address. The directory depends on where the excel is installed. Below is an example of a function saved. ='C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla'!ge tValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) If user1 sends this report workbook to another report developer, user2 whose excel installation is different from the original developer, The report cannot used unless the absolute address is mass replaced on all the worksheets of the workbook. For this to work we need to select each sheet in the workbook and then remove the 'C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla' from all the functions for each cell. Can any one please help me to resolve this issue. We want that when the user saves the report, it must be saved with the relativbe address i.e only the function name 'getValue($B$1,"DESCRIPTION","LINE_ITEMS",B16)' i.e. instead of storing the complete address in each cell. thanks, sandeep |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PORTABILITY ISSUES with Excel Addin in VBA
Hi,
Set the base address for the hyperlinks in a workbook By default, unspecified paths to hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) destination files are relative to the location of the active workbook. Use this procedure when you want to set a different default path. Each time you create a hyperlink to a file in that location, you'll only have to specify the file name, not the path, in the Insert Hyperlink dialog box. 1. On the File menu, click Properties. 2. Click the Summary tab. 3. In the Hyperlink base box, type the path you want to use. Note You can override the hyperlink base address by using the full, or absolute, address for the hyperlink in the Insert Hyperlink dialog box. Challa Prabhu "Sandeep" wrote: When say user1 develops the report and saves, the functions are saved to the xla file using an absolute address. The directory depends on where the excel is installed. Below is an example of a function saved. ='C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla'!ge tValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) If user1 sends this report workbook to another report developer, user2 whose excel installation is different from the original developer, The report cannot used unless the absolute address is mass replaced on all the worksheets of the workbook. For this to work we need to select each sheet in the workbook and then remove the 'C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla' from all the functions for each cell. Can any one please help me to resolve this issue. We want that when the user saves the report, it must be saved with the relativbe address i.e only the function name 'getValue($B$1,"DESCRIPTION","LINE_ITEMS",B16)' i.e. instead of storing the complete address in each cell. thanks, sandeep |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
PORTABILITY ISSUES with Excel Addin in VBA
Hi Challa.. thanks for the updates
But the issue is not this..... Let me explain this once more.............. I have created a Addin in Excel using a VBA, and created a xla file which contains all the functions that my Excel uses to get the data and display it. Now, say user 1 opens the report in the Excel and it uses the getValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) method i wrote to get the data. Now the user saves this report from the Excel on his local system. If we open this reoprt locally on our system we will see the that the method used to get the data are stored as "C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla'!ge tValue($B$1,"DESCRIPTION","LINE_ITEMS",B16)" Now say the user share this report with user2 and our addin is installled on his system on D drive instead of C. I want that when ever the user saves the report or open the report, the method names should be truncated ..... Thanks, Sandeep "challa prabhu" wrote: Hi, Set the base address for the hyperlinks in a workbook By default, unspecified paths to hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) destination files are relative to the location of the active workbook. Use this procedure when you want to set a different default path. Each time you create a hyperlink to a file in that location, you'll only have to specify the file name, not the path, in the Insert Hyperlink dialog box. 1. On the File menu, click Properties. 2. Click the Summary tab. 3. In the Hyperlink base box, type the path you want to use. Note You can override the hyperlink base address by using the full, or absolute, address for the hyperlink in the Insert Hyperlink dialog box. Challa Prabhu "Sandeep" wrote: When say user1 develops the report and saves, the functions are saved to the xla file using an absolute address. The directory depends on where the excel is installed. Below is an example of a function saved. ='C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla'!ge tValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) If user1 sends this report workbook to another report developer, user2 whose excel installation is different from the original developer, The report cannot used unless the absolute address is mass replaced on all the worksheets of the workbook. For this to work we need to select each sheet in the workbook and then remove the 'C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla' from all the functions for each cell. Can any one please help me to resolve this issue. We want that when the user saves the report, it must be saved with the relativbe address i.e only the function name 'getValue($B$1,"DESCRIPTION","LINE_ITEMS",B16)' i.e. instead of storing the complete address in each cell. thanks, sandeep |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
PORTABILITY ISSUES with Excel Addin in VBA
Basically, in my excel report, each cell refers to a UDF, but in the
reference the complete reference is stored like C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla'!ge tValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) We want is that when the user1 saves the report, the cell refering to a UDF, must be like "getValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) " i.e. only the function name and not the complete path of the xla file. Or other way we can say that when the user opens the saved report in the excel, all the references in the cell must truncate to the function name automatically. thanks, Sandeep "challa prabhu" wrote: Hi, Set the base address for the hyperlinks in a workbook By default, unspecified paths to hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) destination files are relative to the location of the active workbook. Use this procedure when you want to set a different default path. Each time you create a hyperlink to a file in that location, you'll only have to specify the file name, not the path, in the Insert Hyperlink dialog box. 1. On the File menu, click Properties. 2. Click the Summary tab. 3. In the Hyperlink base box, type the path you want to use. Note You can override the hyperlink base address by using the full, or absolute, address for the hyperlink in the Insert Hyperlink dialog box. Challa Prabhu "Sandeep" wrote: When say user1 develops the report and saves, the functions are saved to the xla file using an absolute address. The directory depends on where the excel is installed. Below is an example of a function saved. ='C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla'!ge tValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) If user1 sends this report workbook to another report developer, user2 whose excel installation is different from the original developer, The report cannot used unless the absolute address is mass replaced on all the worksheets of the workbook. For this to work we need to select each sheet in the workbook and then remove the 'C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla' from all the functions for each cell. Can any one please help me to resolve this issue. We want that when the user saves the report, it must be saved with the relativbe address i.e only the function name 'getValue($B$1,"DESCRIPTION","LINE_ITEMS",B16)' i.e. instead of storing the complete address in each cell. thanks, sandeep |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
addin for analysis tool pak for excel 2003 | Excel Discussion (Misc queries) | |||
addin for analysis tool pak for excel 2003 | Excel Worksheet Functions | |||
Excel Addin for Access Links | Links and Linking in Excel | |||
macros, selfcert, portability | Excel Discussion (Misc queries) | |||
What is an addin (in Excel) and how can we create one? | Excel Discussion (Misc queries) |