I\'m trying to call some webservices from an ERP solution; but this solution only allows VBA code. The SharePoint web is secured via FBA, so I need to call authentication.asmx first and then pass the
Does the size of excel workbook effect the running of a VBA code? I have written a VBA code into a excel workboo开发者_JS百科k whose size is 200 MB.The excel workbook has the browse button and these b
Here\'s what I need to do. I have these two columns in an excel sheet. With file names. First column has the current filename and the second column has the names I want the files to be renamed to. I n
How I can launch a .bat file from excel? For example via an event or a button? And is it possible to build a .bat file into Excel? For example, I build a launchable .bat file from Excel, a user down
I want to copy the contents of a cell only if the cell conta开发者_运维技巧ins times in the following format: 9:00-5:00pm. (The cell may contain abbreviations such as \"N/A\", \"RDO\", \"Leave\" etc.
i can\'t see where i\'ve gone wrong Dim Sheet1RowNumber开发者_如何转开发 As Variant, Sheet28RowNumber As Variant, sStaffName As String
This is a reall开发者_开发百科y simple VBA formula but it\'s failing. It\'s only pasting into cell A6 onwards. Is it just me? Excel 2011 by the way.
I wrote this script to delete rows which contain a value in column C that is different than \"201103\". When I use this to bold it, it works, but when I use it with .Delete it behaves strange and does
I have a VBA macro that validates user entered data (I didn\'t use data validation/conditional formatting on p开发者_开发技巧urpose).
What I am trying to achieve is a conditional formatting of rows in a table looking for changes based on a backup of an older table.
加载中,请稍侯......