Currently i have several tasks that insert columns or rows in Excel. Unfortunately i have to do all this with key presses.
I'd love to have this ability with a AutoMate action.
Is this possible with the Excel API?

Best regards,

Benjamin

-------------------------

Hi Benjamin,

Thank you for your post. We have added this to our Feature Request database, #F481. We hope to have this feature available in an upcoming release.

-------------------------
Liz Casale
Technical Support Representative
(213) 738-6966
Network Automation, Inc.

--------------------------------------------------------------------------------

AM5 5.5.5.1; AM6 6.2.8.0; AM7 7.1.3.0; AM8 8.0.9.0; AM9 9.0.3.4
BPA7 7.1.3.0; BPA8 8.0.9.0; BPA9 9.0.3.4

Benjamin,
hereunder an easy API solution for removing/inserting columns or rows in Excel sheets


Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
Sub Main Set xlWbk = GetObject ("c:\temp\myExcel.xlsx") Set xlSheet = xlWbk.ActiveSheet xlSheet.Columns("B").Delete xlSheet.Columns("A").Insert xlSheet.Rows("2").Delete xlSheet.Rows("1").Insert End Sub

-------------------------
Jean Delfosse - Automate Beta Tester
Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4

That looks pretty good Jean, but unfortunately i don't know know how to make this variable without knowing a lot about VBA (which i don't).
How about a "run macro" action in BPA10?

-------------------------

There is a Run Macro activity for the Excel action in the upcoming v10 release.



-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665