Visual Basic for Applications (VBA) is an event-driven, object-oriented programming language for writing macros, used for the entire Office suite. If your question is specifically about programming Excel, Access, Word or Outlook, use the appropriate tag: excel-vba, access-vba, word-vba or ...
0
votes
0answers
2 views
Serial Number Activation
I've made an serial number activation program which tries to find a .txt which will contain the serial that the user will type in the "serialnumber" textbox. My program as soon as the user presses the ...
0
votes
0answers
10 views
Serial Number Activation
I've made an serial number activation program which tries to find a .txt which will contain the serial that the user will type in the "serialnumber" textbox. My program as soon as the user presses the ...
0
votes
1answer
16 views
“Run time error '9' Subscript out of range” shows up while trying to fetch the Email body from outlook to Excel file
I am trying to fetch the part of the Email body from outlook to Excel file using the following coding. It is giving me error as “Run time error '9' Subscript out of range “ as specified in the ...
0
votes
0answers
19 views
Excel VBA - Finding workbooks by name and copying and pasting worksheet to another workbook*
i'm new to this so this should be fairly easy. I need to find an open workbook by the rightmost characters in the workbooks name, then copy a worksheet and place that worksheet in another open ...
2
votes
1answer
39 views
SQL Searching a String for Numbers between different criteria
I have been attempting this issue for a while and have yet to find a solution.
I am looking for a method using SQL commands to Search a String for an alphanumeric number between 2 points.
For ...
1
vote
2answers
28 views
Excel 2007 VBA Syntax for Range reference that used to work, doesn't anymore
I hope this isn't something that has been asked before. And I REALLY hope that there is something wrong and I'm not just missing something...
I'm making a macro in Excel 2007 to clear the input ...
0
votes
1answer
31 views
How can I pull data from multiple files in Excel using Visual Basic?
I have an Excel problem that should hopefully be quite easy (logic-wise), but my knowledge of Visual Basic is very limited. I have a few folders with about 30 .xlsm files in them each (each file ...
0
votes
0answers
8 views
Using IWebBrowser2 to put Widgets in PowerPoint — Automation Error: Unspecified Error
I created a simple macro to put an HTML widget from Weather.com in to a PowerPoint slide.
It is not event-based, but ActionButtons call the ConnectWidget subroutine, when navigating to the slide. ...
0
votes
1answer
15 views
VBA: Reading excel data into word
I am making a simple form that extract the data from my excel sheet, such as name, date of birth, and address. And inserting them into my word form, I am doing 20-30 sheets everytime, so I think it ...
0
votes
0answers
18 views
How to turn a string value into a usable data from a serialized .xlsx file in excel using VBA
I have very limited experience with VBA and excel.
So I have a server which generates reports in .xlsx format for users to download. I'm trying to have an excel macro grab the data from the generated ...
4
votes
2answers
50 views
Copying Worksheets in VBA Copy Error
Hi I'm having a problem copying worksheets from one workbook to another in VB. The code I have works fine with brand new workbooks, but after awhile it breaks and gives me this error: "Method 'Copy' ...
0
votes
1answer
16 views
Searching Tables from VBA
As much as I hate asking without having a good start I am stuck on something very simple I think.
I have a table with only 3 fields. I want to be able to search them using a InputBox which I call ...
3
votes
1answer
33 views
How can I copy Excel cells with rich text formatting but not the global cell format?
Using VBA, I'm copying the value of one cell to another:
Dim s As Range
Dim d As Range
Set s = Range("A1")
Set d = Range("B2")
d.Value = s.Value
This works fine, but if the source contains rich ...
0
votes
0answers
9 views
Saves as files in word VBA drops extension if it appends another registered extension
I was hoping someone might have some suggestions for a problem i am having saving documents in Word 2010 via a macro. I am writing a macro based on a few examples on the web to do a number of things ...
0
votes
0answers
9 views
Sending and receiving data via POST in Microsoft Word 2011 for OSX
I am trying to port a macro that we have working for MS Word on Windows that uses a website to generate an equation image and returns that image for insertion into a document. The current (working on ...
