Client Access File Transfer from Excel 2010
I need a new macro comman because the old one that we have used since Excel 2003 has stopped working with a new com based addin for client access that IT has put into a new PC in our group. This is the first time I have run into this. The others in our group for now can still use this macro command I am about to show you.
Application.Run "Showexceluploaddialog" In the older versions, this brings up the xllbased add-in in Excel that is driven by the file cwbtxla.xll. I wanted to copy and paste the dialog box in here that is the File Transfer Operation to the Iseries, but this google groups interface would not let me paste in here. Anyway, the problem in a nutshell is the macro above does not bring up this dialog anymore. Is there an updated macro I need to bring this up now? If you can tell me how to paste the snip in here to make this make more sense, I will do that. Thanks, Bruce |
Client Access File Transfer from Excel 2010
Is the COMaddin registered on the new machine?
-- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
Client Access File Transfer from Excel 2010
Yes, that is why the macro is bombing on the new machine.
On Friday, November 8, 2013 1:30:03 PM UTC-6, GS wrote: Is the COMaddin registered on the new machine? -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
Client Access File Transfer from Excel 2010
Yes, that is why the macro is bombing on the new machine.
What language is the COMAddin written in? If it's VB6 then you may not have the needed support files as many are no longer shipped with the OS since Win6.0! Otherwise, any COMAddins I have running in XP xl2003/7 also work fine in Win7 xl2003/7 -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
Client Access File Transfer from Excel 2010
On Friday, November 8, 2013 5:03:34 PM UTC-6, GS wrote:
Yes, that is why the macro is bombing on the new machine. What language is the COMAddin written in? If it's VB6 then you may not have the needed support files as many are no longer shipped with the OS since Win6.0! That is probably the difference you are talking about Excel versions up to 2007, we run Excel 2010. Do you have any other suggestions other than having the macro highlight the text to upload and then manually running the transfer operation? Thanks again.... Otherwise, any COMAddins I have running in XP xl2003/7 also work fine in Win7 xl2003/7 -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
All times are GMT +1. The time now is 01:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com