ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to programmatically access excel services dialog in excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/175752-how-programmatically-access-excel-services-dialog-excel-2007-a.html)

[email protected]

how to programmatically access excel services dialog in excel 2007
 
Hi All,

Currently am able to upload an excel workbook to sharepoint server
like this in excel 2007:
Office button-publish-excel services-sharepoint sites-ok

I want to automate this process. Is there any way (vba?)

Thanks in advance

CLR

how to programmatically access excel services dialog in excel 2007
 
Just try the sequence with the macro Recorder turned on........that might do
it.

Vaya con Dios,
Chuck, CABGx3


" wrote:

Hi All,

Currently am able to upload an excel workbook to sharepoint server
like this in excel 2007:
Office button-publish-excel services-sharepoint sites-ok

I want to automate this process. Is there any way (vba?)

Thanks in advance



All times are GMT +1. The time now is 09:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com