Search:
Type: Posts; User: Volos
Search:
Search took 0.02 seconds.
-
I've thought of trying to use the Index function, but I would want the end user to be able and edit the information as they scroll (and an index would be written over in this case).
-
I'm working on a COM add in, but I would be happy to have this solved in VB or VBA. I have user reports that are generated based off selections from a database, then the sheet is added into an...
-
Ah of course. I knew it was something stupidly simple. Thanks.
-
So I'm working on learning VB.Net and VBA as additional languages. I must clearly be missing something simple from the MS example, because I can't seem to get my user control to pop up:
...
-
Sorry I need to dig more, before I ask. I really don't know what caused these errors, but I'm on to other methods which seem better do the same thing. Example:
Dim cn As ADODB.Connection,...
-
Ok so clearly I'm way off base on perhaps even the correct way to do what I want. Watching an Excel written macro has led me to:
Dim DBPath As String
DBPath = "E:\LacProj\Dummies and...
-
Hello again,
So now that I've finished my previous project, and migrated everything successfully to an Excel Spreadsheet, I have been "allowed" time to try and get it working with an Access/Excel...
-
My bad on that.
I actually had it on set first--I pulled that when I tried to debug (and was copying the code in the middle of the night). But it didn't throw the error, instead pulled the...
-
While I still feel the name solutions should have worked, I was able to pull it from looping through all the smtp addresses each time....
-
So I am yet another person failing with .SendUsingAccount! I look at plenty of purportedly correct uses, yet I'm coming up with RT error "-2147024809" every time.
so my first shot:
Sub...
-
I am trying to send out several emails sent from an Excel file. Everything seems to be working but Outlook prompts for a security exception with every single email. RangetoHTML is not my solution,...
-
I'm trying to send a form email with recipient dependent variables reported in a few HTML tables. I would like the email to be formatted nicely, but I've been having a hard time doing anything but...
-
I don't at the moment have time to throw any code up for you, but I would use .FindNext (http://msdn.microsoft.com/en-us/library/office/bb219895%28v=office.12%29.aspx) and .SaveAs...
-
Ok so I'm moving along in hacking this together in VBA, and I have actually imported the whole DB into one Excel file (turned out to have 12 tables, all of which I put on a separate sheet). I've...
-
Access might be a viable option, but at the moment I'm thinking an entirely VB front end that prompts for the daily values and pulls from csv files for client data. Is there any reason that I would...
-
Good to know others have the same initial thoughts I did. There are some unfortunate problems. First the poor old server the DB is on is slated to be junked, and a copy of the DB is to be thrown on...
-
Hi everyone, I thought I would give this forum a second go. Even if I answer my own questions again, hopefully it might help someone else. I work mostly in computer vision, and thus my language...
-
Ok so the key-command problem cleared up when I saved the file, closed it, went to lunch, and re-opened it.
-
OK so I solved my own problem partially:
Sub Shorter96()
Application.ScreenUpdating = False
Dim platenumber As Integer
platenumber = Application.WorksheetFunction.CountIf(Range("A:A"),...
-
I suppose I shouldn't keep replying to my own thread, but I see that using .Select is slow. I'm trying to work out a solution with .Offset now, but so far I've failed.
-
Sorry I didn't wrap the code! As soon as I posted it I try to find it to edit it, but I think I lost it to being approved. Here is the wrapped code:
Dim platenumber As Integer
platenumber =...
-
Hi everyone, first post. I have a fair amount of experience in other computer languages, some in .Net, and I'm just starting out in VBA as part of a new project.
For lack of a better description,...
|
Click Here to Expand Forum to Full Width
|