Tagged Questions
0
votes
2answers
18 views
Function call on left hand side of the assignment must return Variant or Object, finding common values in two arrays
I've got two arrays and I'm trying to pull out the common values in them and the function findUniques is supposed to return the strings (they're names) concatenated and separated by a comma. I think ...
0
votes
1answer
44 views
Appending a Variable Number of Characters to a String based on the Current Length of the String
I have a list of Names, Dates, and Titles that I am trying to output to a textbox. I am looking to have the format of the output have the following "Columns":
Name | Date | Title | Index Number
...
1
vote
2answers
50 views
Assigning cells formula using variable and cell reference
I am trying to assign a formula to a cell whose reference changes at every iteration. The left-hand side of the assignment below, however, seems to work since if I make the right-hand side ...
4
votes
1answer
85 views
VBA string contain
I want to find if a Sting is having ","(comma) in it. Do we have any other option other than reading char-by-char. As we have Sting contains in VB.
1
vote
3answers
257 views
Compare strings in excel vba
I have a bunch of strings comprising of characters "A","B"..."Z" (and no others). A typical string looks like ABZYC. The strings are given to me in pairs like ABC,ABDC. The strings are comparable if ...
0
votes
2answers
56 views
Changing String input data into week / month format
I'm not sure if this is possible but I thought I would ask to see if any one may have a solution.
Issue:
I have a macro were the user inputs a date as a string (e.g. 021513) in an input box. It is ...
0
votes
0answers
210 views
Excel VBA String Parsing Array/Table
I have a spreadsheet that uses a string convention to convey levels of detail about individual "cases."
The convention is as follows: There are 5 main categories for the data in the string. ...
1
vote
1answer
762 views
Excel 2010 VBA step through a string and place one char into each cell in sequence
I am used to string slicing in 'C' many, many years ago but I am trying to work with VBA for this specific task.
Right now I have created a string "this is a string" and created a new workbook.
What ...
1
vote
1answer
48 views
VBA is it possible to search a text that has a certain font
I need to process an excel file where the alpha symbol(α) has been entered as an "a" character to which the symbol font has been applied.
When exporting the file, formatting is lost and there is no ...
-1
votes
2answers
594 views
In Excel 2010, how to delete a portion of a string within a cell using a Macro?
I am trying to create a macro for an Excel file which has a column (let's call this column A) of cells, and each cell contains 4 to 5 project Deliverables & Work Products separated by a comma, as ...
1
vote
4answers
176 views
CleanName not cleaning " in Excel VBA?
I'm updating the question to show what I have already, before adding in lines from here...
Function CleanName(strName As String) As String
'will clean part # name so it can be made into valid folder ...
0
votes
1answer
427 views
Excel String Parsing
I have a spreadsheet that uses a string convention to convey levels of detail about individual "cases."
The convention is as follows: There are 5 main categories for the data in the string. ...
3
votes
1answer
315 views
In VBA for Excel, How can I manipulate a header/footer when the string contains '&'
I have a section of code that writes to the header section of the page. The problem is that the string that is written to the header occasionally contains a '&' symbol. This interferes with the ...
0
votes
1answer
4k views
Getting data from HTML source in VBA (excel)
I'm trying to collect data from a website, which should be manageable once the source is in string form. Looking around I've assembled some possible solutions but have run into problems with all of ...
0
votes
1answer
135 views
Creating a string editing macro for Excel Visual Basic
I need help creating a string editing macro for excel in visual basic. I am going to describe what I need to be done but any tiny bit of information would help me if a full answer is not possible. I ...
