Search:
Type: Posts; User: Garratt
Search:
Search took 0.08 seconds.
-
I'm trying to find a good way to do this.
(say) I have a spreadsheet with two columns: IN and OUT.
These two columns are in the full date-time format (mm/dd/yy hh:mm:ss). I need to go down...
-
That didn't help at all but I blame myself. :p I could not figure out how to get the v11 object library going
I did figure out a way around it though
"Imports Excel.Constants" takes care...
-
Me = totally new to VB.NET
I downloaded the free VB.NET express edition to give it a try at work. I have a bunch of VB6 applications that I would need to convert, most that end up dumping data to...
-
I'm pretty good with VB, but that's it (well, I know a little SQL).
I have a need to make a web db. This would be for the purpose of asking a large number of multiple choice questions (radio...
-
TempA: Original String
TempB: The search string ('BLUE') is inside of the TempA text
TempC: The String to replace the found string with if found (i.e. if "blue' is found, replace 'blue' with...
-
UT2004 Onslaught is an amazingly fun online action game.
I've played everything online or head to head starting with Doom I via a serial cable in the old days.
(Considering That) I have to say...
-
Totally wrong forum. This is the VBA forum for discussing "Visual Basic For Applications".
You'll probaly want to post your question here:
http://www.vbforums.com/forumdisplay.php?s=&forumid=11...
-
He'd need some type of matching key field for that right though?
Depending on what he's doing it could end up being a Union or even he could open two record sets at the same time... ?
-
?
Open "C:\myfile.txt" for Output as #1
Do until rs.eof = true
Output #1, rs.fileds("myfield1") & "," & rs.fields("myfield2") & "," & rs.fields("myfield3" )
rs.movenext
-
http://www.exceltip.com/st/Use_a_closed_workbook_as_a_database_(ADO)_using_VBA_in_Microsoft_Excel/432.html
-
:p typo = copy and paste error.
-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro2k/html/sql00k1.asp
There should be nothing in that folder unless it was setup on purpose to database replicate. I'd say...
-
I think it would be something like:
oldString = InputBox("Type the four digits you want to replace")
newString = InputBox("Type in the Replacement Digits: ")
strSQL = "SELECT SUB_ID,...
-
This post got really long (sorry).... To sum up, I'm looking for a way to make a select statment that says something like: "SELECT all records where the timestamp is withing +/- 20 seconds of this...
-
I'm a little boerd so I worked out a solution. I'm sure someone smarter could find a more quick and simple way to do this, but here's what I came up with:
(Assuming that Column A is filled with...
-
Wow... I had no idea. For "Input", "Line Input" doesn't show up as a related topic in the help file.
Poop - egg on my face.
Thanks man :wave:
-
I'm using Excel VBA to read some big ASCII/Text files.
I've run into a problem and finally figured out that when I'm INPUTing lines in from the text file, lines with commas in them are broken up....
-
Is everything always 2 alpha and 2 number?
TempstringA = Left(Cells(1,1).value,2)
TempStringB = Right(Cells(1,1).value,2)
TempIntegerA = Val(TempStringB)
-
A listbox can either be setup (properties) as a single selection type only, or a multi-selection type.
Assuming you only have 1 selection enabled, you need to scan the listbox items first to find...
-
Sorry, I should have been more clear.
One of the Oracle databases I pull data from is not under my control. For corporate security reasons (blah blah), I only have read access to that db. Plus,...
-
You wouldn't have an example of a small PL/SQL file and what it would look like in VB would you? :)
-
Is it possible to pass a small Oracle PL/SQL program through a VB Oracle ADO connection?
I haven't tried yet and was just wondering if it was even possible.
-
OK, that didn't work at all. VB kept saying that an object was required.
But, I played around for awhile and this worked:
Dim exl As Excel.Application
Set exl = New Excel.Application
...
-
After searching around the forums, I found a reference to the Excel Object library and some starting code:
Dim exl As Excel.Application
Set exl = New Excel.Application
etc..
How to I use...
-
There are different types of mail objects, but all of them will email the open file, or a single sheet from it.
So, you don't have to worry about where the file lives.
:( I'm late for work,...
-
OK, that's cool... I'll give that a try at work today. The only problem would be that Sheet1 is not a static size. So I guess I would need to make the VLookup up on the fly and insert it into the...
-
I can't picture what you are trying to do at all.
Can you upload a small example sheet or something?
Column A has computer brand names
Columns B:H have.... ?
Columns I:O have.......?
...
-
I've got a massive Excel VBA 'macro' that in the middle of running ends up with two worksheets of data. These two sheets are farily large, containing up to 5,000 rows of data on the largest.
...
-
MyString = "sheet1"
Worksheets(MyString).activate
-
I was curious enough to look around for a few seconds.
I found this,
http://www.excelforum.com/t209535-s
But got boerd a few posts down. :p
-
If you click on the workbook item you can create a "open" sub in there:
Private Sub Workbook_Open()
'code
End Sub
But, because of security issues of course the user only has to hold down...
-
If you load a .dot file or any word document, access to the macro subroutines exist as long as they are "Public" subs.
I'm guessing you pointed to it's location as a template folder location and...
-
Are you saying you have a "Normal.dot" file on a shared or network drive and both of you have changed the "File Location" for templates to that dive (and it still doesn't work)?
-
From what? Which office product and which office version?
I'm guessing you're talking about Outlook.
-
Just a guess, but considering what the error points to, try changing the cell type to "text" for the cells in the "Name" column.
The first name is a number. Since the cell type is "general" Excel...
-
You should "Google" the phrase "data type mismatch for criteria expression"
I just did it and it game me a lot of ideas as to what the problem might be.
example:...
-
Go into the Visual Basic Editor.
Double click one of the worksheet items under "Microsoft Excel Objects".
Add this code:
Private Sub Worksheet_SelectionChange(ByVal Target As...
-
Repaints of the form my be causing delays.
You could try adding in some screenupdating toggles to manually refresh the screen every so often (so the user doesn't think things have crashed.
...
-
If you have multiple forms, global variables won't work.
Jmacp has the right idea... On one of your forms make either a text box or label for ever variable you need to share.
...
-
This is for Excel97 VBA if it matters.
I've been trying to read up on the file access methods but I'm a little slow this morning:
(example)...
|
Click Here to Expand Forum to Full Width
|