VBA
Error setting return value of a VBA function
I\'m having a brief foray in to VBA to automate some Excel workflow. I\'ve got a function that creates a worksheet and returns it. I call it as follows:[详细]
2023-04-11 18:26 分类：问答Excel 2007 - Repeat data dynamically
So I have this Excel workbook which basically is supposed to be a data sheet for work clothes for each employee. What I want is to have one sheet for each person (first name and last name), then one s[详细]
2023-04-11 17:36 分类：问答Approve/reject files to sharepoint using VBA Excel
I\'m trying to automate sharepoint file upload, checkin and approve. I\'m using FP RPC to upload and checkin the file but I have no idea if I can automate approving the uploaded file. the only solutio[详细]
2023-04-11 16:11 分类：问答AutoUpdate VBA startup macro?
I\'m building some Word 2003 macro that have to be put in the %APPDATA%\\Microsoft\\Word\\Startup folder.[详细]
2023-04-11 15:32 分类：问答DateDiff split into months access/vba
How would I create a query/vba function similar 开发者_运维百科to DateDiff that splits the result into days per month (i.e. 1/1/2010 - 2/3/2010 = January: 31, February: 3 (disregarding formatting)).OK[详细]
2023-04-11 15:05 分类：问答Display a specific record by clicking an open form button in MS Access 2007 doen't work
Assume I have 2 tables in MS Access: Table about some people which work for some company: And table about some projects which some company holds:[详细]
2023-04-11 14:19 分类：问答Select IIF SUM command
I am using Jet SQL from excel using an ADODB connection to an IBM400 server to try and and get some data.I have done this fine before and it is fine with all other JET SQL commands however I have ran[详细]
2023-04-11 13:51 分类：问答Weird situation, define a file path connecting to Access .accdb database in Excel VBA using ADO, however it tells me couldn't find .mdb file
I\'m writing code in Excel VBA using ADO connection to open an Access .accdb database. I defined the file path as bellow, but when I run my code, error message tells me that \"couldn\'t find file C:\\[详细]
2023-04-11 13:16 分类：问答In nested Excel VBA For...Next loop, parent Next cannot find its For
For j = 0 to SpreadCount If TypeName(ChainsDC(j,0) = \"String\" \'testing for an error Goto EndLoop Else:[详细]
2023-04-11 13:02 分类：问答EXC_BAD_ACCESS "Office for Mac 2011" Excel macros MicrosoftOleautomation debug cause
I\'m encountering the ubiquitous EXC_BAD_ACCESS error in Microsoft Office for Mac 2011 on OSX 10.7 (Lion). Latest office update installed too (14.3 I believe it was)[详细]
2023-04-11 12:47 分类：问答
加载中,请稍侯......