Search:

Try Select Case Worksheets(idx).Range(FGRNames_Report.Address).Value instead. FGRNames_Report is a range object and the default property of a range is the value, not the address of the range. This...

I updated this to work with xcopy. It was failing before because xcopy requires stdin to run. I've also renamed it to CRunApp but works the same as the previous.

Note: Since this opens up stdin,...

Ok, I tried it and got what you were talking about. It's just bad technique! If I try at a fast speed with good form, I get the dialogue. If I try to go so fast that it's just a big key mash then it...

I can't reproduce that problem no matter how fast I hit ALT-E-S. I am certain your coworkers can adapt. I've never heard of being able to switch that off.

You don't need to program in a sendkeys hack. It's basically prompting because you told it to. Change this line to be either wdFindContinue or wdFindStop depending on whether you want to search the...

Sheet1.Cells(13 + i, 4).Numberformat = "@"

You should check to see if the style is H2 first before you loop through your collection. You could save the oPara.Range.Text to a string before looping through the collection so it doesn't have to...

There is nothing wrong with your code that I can see. You need to format your cells to text or excel will remove the leading zeroes.

If you're going to use .net maybe you could look into doing openxml development... Automating Excel outside of VBA isn't as pleasant of an experience.
...

Ecniv, your code is less readable than the OP.

Hey Tony, is the javascript in the forms the only thing that is keeping you from using a different method? Is the javascript so complex that what it does would be real cumbersome to replicate? The...

If you're looking for style suggestions, I'd say that everything looks fine. It's not sloppy at all!

The only things I'd point out is that you should probably get into the habit of not assigning...

True, westconn1.

Workbook passwords (to open) encrypt the file contents. I'm sure you could code the macro to brute force the encryption, but you would have to replicate the same things those...

It's not really a case of privileges from my understanding. It's that you are now trying to use Outlook through the API, and Microsoft has nerfed that functionality. Once you try to do something...

I hope I never end up in one of your classes.

Select Case t And mph

Juicy, I think this is your sticking point right now. You're trying to code in English, but that's not how the computer thinks. "AND" is an operator to the computer. Read...

I would love to hear some tips from you, incidentals. I have recently started giving a class to workmates and I find it hard to go back and see things from their perspective. I started off by...

Hey don't be too hard on the guy. I used to have pages in large documents like this when I worked for insurance companies. Pages in these documents become their own entities and repagination would...

A union is a range in the form of $B$1:$C$2,$D$1:$E$2. This is not a valid range for a pivot table. You can't even do that if the ranges touch and are the same size.

You are correct that filtering...

Use a select case if you want it to follow english more...


Select case wc
Case 40 to 50
'code
End Select

If 50 > wc > 40 Then

I don't think this line does what you think it does. Remember operator precedence and execution order. In this case I think 50 > wc would evaluate to true or false and then do...

This is going to be nearly impossible to troubleshoot through the forums. All I can say is double check your table names and connection string.

As far as I know you can't run it in the background using a command-line switch. You could write an external app to call excel using its com interface. You could even use vbscript to do this if it is...

As long as the 32/64 bit versions of the COM addin and office are the same, they should work together. Also ensure the COM addin is registered on the system through either self-registration or...

access creates the tabledefs locally and they are cached in the database. refresh the tables in your linked table manager (database tools tab) and the update should propagate.

You have to assign something to the worksheets you dim.


Sub StatSig()
Dim FirstSht As Worksheet
Set FirstSht = Worksheets("NAMEHERE")
ActiveSheet.Name = FirstSht
Dim StatSigSht As Worksheet...

You could try the library in my signature.

Check out some examples here.

http://msdn.microsoft.com/en-us/library/ee336041%28v=office.12%29.aspx

This is how to iterate rows in the most basic fashion. They are editing fields here, but the...

You certainly can't speed up the round trip time of the network backend, but you certainly can cut down on the number of trips is has to make. That is a lot of DLookups. I would seriously consider...

Thanks a lot for this. I'd considered the thread dead :)

Do you know if the strings returned from crackurl have to be freed?

Does anyone have a working example of using WinHttpCrackUrl? For some reason I can't get this one working for the life of me. Here's the declarations I have so far.


Private Declare Function...

You're probably running into nulls. Try this.


Private Sub btnEMailSecChfs_Click()
DoCmd.OpenQuery ("qry SECTION CHIEFS")

Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim objSubject As...

That's really script-like. Much like languages that support syntax like "/echo {A{1}}" type expressions. VBA is not that kind of language. You'll want to use arrays and enumerations.

Access doesn't have a query that does this as far as I'm aware. You can do this with code using the form's load event.


Private Sub Form_Load()
Dim tdf As TableDef

...

Look for Application.Run

MS didn't make the outlook model very good. Looks like this may not be possible through straight outlook because the object is so restrictive. You may need to get outlook redemption even as a trial.

I don't think he's trying to combine the documents so much as just trying to save them. The pdfs are loaded in separate message files that are also attachments, so he has to open the email message,...

Which version of excel are you using? 2007 his this built in.

Arrays don't appear to be supported as a return type. The api in the c program would have to be modified to accommodate the return array as an argument.

type Optional. Data type of the value...

It should have already been registered. It's part of the operating system. This could have been part of the original problem.