Replies

Mark–

Thanks for the work you’ve done on this. Your Access db worked like a charm. I appreciate your help.

Mark–

Thanks for the work you’ve done on this. Your Access db worked like a charm. I appreciate your help.

Hey Mark–

Thanks for the reply. I think this is exactly the kind of tool I’m looking for. However, I’m just a little over my head, here. I probably understand about 80% of the code you included. But that’s how you learn, right? Jump in a little over your and try to figure it out.

I started out by taking the code and dumping in into the Excel VBA editor. I think I’m missing one or more references. Can you pass along which references should be checked.

Also, when I try to compile the code, the first error states “Cannot define a public user-defined type within an object module” at the Type WIN32_FIND_DATA line. This doesn’t sound like a missing reference error. I’ve never created my own types before, so I’m not sure how to correct this error.

If I call the GetTopLevelSubfolderSize procedure within the immediate window, I get an error stating that the procedure or function is not defined. Now that I think about it, this is probably because the code hasn’t compiled, yet.

As I said, this is exactly what I was looking for, but I may need a little hand-holding while I make it work for me. I’m still very much a newbie when it comes to working with the Windows API. Thanks again, Mark, for your contribution.

Hey Mark–

Thanks for the reply. I think this is exactly the kind of tool I’m looking for. However, I’m just a little over my head, here. I probably understand about 80% of the code you included. But that’s how you learn, right? Jump in a little over your and try to figure it out.

I started out by taking the code and dumping in into the Excel VBA editor. I think I’m missing one or more references. Can you pass along which references should be checked.

Also, when I try to compile the code, the first error states “Cannot define a public user-defined type within an object module” at the Type WIN32_FIND_DATA line. This doesn’t sound like a missing reference error. I’ve never created my own types before, so I’m not sure how to correct this error.

If I call the GetTopLevelSubfolderSize procedure within the immediate window, I get an error stating that the procedure or function is not defined. Now that I think about it, this is probably because the code hasn’t compiled, yet.

As I said, this is exactly what I was looking for, but I may need a little hand-holding while I make it work for me. I’m still very much a newbie when it comes to working with the Windows API. Thanks again, Mark, for your contribution.

Joe–

Thanks for your response. I’ve downloaded the Directory Printer. While it appears to have some powerful features, there is way too much information for what I’m looking for. We have hundreds of home folders and it is giving me information on every subfolder of each home folder. If I start with the parent folder for the home directories and check “Search Sub-Folders”, I get information on every sub-folder for every home directory. If I start with a specific user’s home folder, I could just a easily check the properties for each individual home folder–but that would take more time than I have. I wish it had a setting for “Search sub-folders only one level down”.

Is there any other ways to get at the total folder size for all home directories?

Joe–

Thanks for your response. I’ve downloaded the Directory Printer. While it appears to have some powerful features, there is way too much information for what I’m looking for. We have hundreds of home folders and it is giving me information on every subfolder of each home folder. If I start with the parent folder for the home directories and check “Search Sub-Folders”, I get information on every sub-folder for every home directory. If I start with a specific user’s home folder, I could just a easily check the properties for each individual home folder–but that would take more time than I have. I wish it had a setting for “Search sub-folders only one level down”.

Is there any other ways to get at the total folder size for all home directories?

What a great tip. Thanks Jan!

What a great tip. Thanks Jan!

Thanks, everyone, for your responses to my question. Digitally signing a project has been tricky to figure out, having not done so to this point. This was just another piece to the puzzle.

I have been double-clicking a shortcut to open the file. Opening it through the Open dialog box while holding down shift worked as designed. I will probably add a simple IF Statement and MsgBox asking if I want to run the macro, which I can comment out once all my testing is done.

Thanks again for everyone’s help.

Thanks, everyone, for your responses to my question. Digitally signing a project has been tricky to figure out, having not done so to this point. This was just another piece to the puzzle.

I have been double-clicking a shortcut to open the file. Opening it through the Open dialog box while holding down shift worked as designed. I will probably add a simple IF Statement and MsgBox asking if I want to run the macro, which I can comment out once all my testing is done.

Thanks again for everyone’s help.

John–

Thanks for your response. However, I’m not sure what the code you presented is suppose to do. As far as I can tell, as long as the Printers Dialog can show, my code will fire. I think I’m looking for something more than that.

I’m need to make sure we’re talking about this same thing, first. You referenced Net01, while I’m refering to a printer port designation of Ne00, Ne01, Ne02,… Is this what you meant?

I need to make sure my excel document prints to a specific printer. In the printers dialog box, it is refered to as printername. When I check the Application.ActivePrinter property, it returns printername on Ne0x, where x varies, but is usually 0, 1 or 2. I don’t know how to refer to this printer if the name of the printer changes.

Do you (or anyone else) have other suggestions? Or have I misunderstood the use of your code? I good at doing that!

John–

Thanks for your response. However, I’m not sure what the code you presented is suppose to do. As far as I can tell, as long as the Printers Dialog can show, my code will fire. I think I’m looking for something more than that.

I’m need to make sure we’re talking about this same thing, first. You referenced Net01, while I’m refering to a printer port designation of Ne00, Ne01, Ne02,… Is this what you meant?

I need to make sure my excel document prints to a specific printer. In the printers dialog box, it is refered to as printername. When I check the Application.ActivePrinter property, it returns printername on Ne0x, where x varies, but is usually 0, 1 or 2. I don’t know how to refer to this printer if the name of the printer changes.

Do you (or anyone else) have other suggestions? Or have I misunderstood the use of your code? I good at doing that!

I have been using your solution for a number of years, but didn’t know if there was something else I didn’t know–huh, ya know?

I hadn’t thought about using a custom format. This is probably the ticket for me since these numbers will not be used for calcuations. (I’m programmatically importing data into my spreadsheet and need to get the visual formatting correct.)

If I were to need these numbers in some calculations, does anyone else have some suggestions that would keep me from having to manually divide all the numbers in the range by 100? (Although I guess I could do this programmatically, also)

I have been using your solution for a number of years, but didn’t know if there was something else I didn’t know–huh, ya know?

I hadn’t thought about using a custom format. This is probably the ticket for me since these numbers will not be used for calcuations. (I’m programmatically importing data into my spreadsheet and need to get the visual formatting correct.)

If I were to need these numbers in some calculations, does anyone else have some suggestions that would keep me from having to manually divide all the numbers in the range by 100? (Although I guess I could do this programmatically, also)

I thought so, but it couldn’t hurt to ask. Thanks again.