VBA
Error returning objects to VBA from Visual Foxpro COM server
I am getting the following message when trying to return a new object to VBA from my Visual Foxpro COM server.[详细]
2023-04-12 19:40 分类：问答Preparing Excel Pivot Table
- I have a tabular data with values as in picture. I created a pivot table in excel 2007 .How can I get count value of each up/Down for date specified. I tried to开发者_开发百科 by making one colu[详细]
2023-04-12 17:03 分类：问答Upload file via FTP from Excel VBA
Need to upload a file (file.txt) to a server (ftp.server.com) from Excel VBA. (does not have to be necessarily FTP, just need to be able to put the file there and get it back, and I\'ve got a server o[详细]
2023-04-12 16:24 分类：问答Expression to test for one or more spaces in VBA to find matches in Excel cells
I am trying to use regular expressions in a macro for an Excel document. Here is what I have so far:[详细]
2023-04-12 15:49 分类：问答Move data from every X column into single column in Excel
Problem Solved using modifications to answer Dim i As Long, values As Range, current As Range Set current = Range(\"D4\") \'//select 1st anchor cell[详细]
2023-04-12 15:10 分类：问答Using VBA, how to populate ComboBox values based on specific comlumn in an excel table
Using VBA, I\'m trying to build this sophisticated form to add new 开发者_StackOverflow中文版rows to an existing table.[详细]
2023-04-12 15:01 分类：问答Copy information from one spreadsheet to another based on a single factor
ABC 1. cFirst Last 2. dF开发者_运维技巧irst Last 3. eFirst Last 4. cFirst Last 5. cFirst Last I\'m trying copy the information from columns B & C over to another worksheet (tab in the same docu[详细]
2023-04-12 14:56 分类：问答Is there a way to Find & Replace a cell reference value in Excel 2010? VBA?
I have an Excel worksheet that contains a bunch of charts created from data pulled from another worksheet in the workbook. At the beginning of each month, when I add last month\'s data to the data wor[详细]
2023-04-12 14:49 分类：问答How to make hidden rows not editable/copiable in VBA?
The macro hides rows. After the rows are hidden, users can copy, edit and delete blocks of cells/rows. When users select the range that contains hidden cells, hidden cells, unfortunately, got selected[详细]
2023-04-12 14:36 分类：问答How to prepare Collection object in VBA
Below code is in VB.net, how can i do the same thing with vba Option Strict On Imports System.Collections[详细]
2023-04-12 12:10 分类：问答
加载中,请稍侯......