|
I want to know if its possible to select more than one item from a criteria when using the autofilter. Example: i have a list of fruit. I can use the autofilter to select only the apples, or only the oranges. But I want to see both apples AND oranges at the same time.
|
#
¿
May 25, 2009 12:04
|
|
|
|
| # ¿ Apr 28, 2024 12:05 |
|
|
Thel posted:Finally got everything working the way I want. Using the Office 2010 GPO admin templates, you can specify trusted directories, so all files within that directory will auto-enable macros. Not sure if you can use it to specify sharepoint location though. Edit - We only have policies in place for Word, but I assume Excel has similar options. User config > admin Templates > Word 2010 > Word Options > Security > Trust Centre > Trusted Locations e2 - On re-reading your post, I think i may have just told you a heap of stuff you already know. Swink fucked around with this message at 12:21 on May 15, 2011 |
|
#
¿
May 15, 2011 12:14
|
|
).
|
^ Yeah exactly that. Like I said, I'm not 100% on how you do it for files hosted on Sharepoint. All ours are for network drives (T:\Templates etc), and I dont have access to a sharepoint install at the moment to play around.
|
|
#
¿
May 16, 2011 03:49
|
|
|
I've got a dumb request from a client that I cant solve. He wants to track a loan repayment, where the repayment amount can vary, as well as the date he pays. Each time a payment is made, he wants to add on the interest for the days since the previous payment. He wants to know exactly how much is left on the loan at any given time. He intends to pay semi-regularly with some large lump payments but also some periods where he pays nothing. I cant figure out how to keep a running total of the balance outstanding. I need to add x days of interest to the balance, and subtract the principal paid each time a payment is made. He intends to update the sheet himself with the date paid and the amount. I've not worked with finance stuff in Excel, and this request sounds pretty stupid, but if someone could take a quick look and where I'm at so far I'd appreciate it. http://dl.dropbox.com/u/58703/runninginterest.xlsx
|
|
#
¿
May 22, 2012 09:33
|
|
|
Yeah but the top left is unimportant. Thanks - I guess I'd been staring at it too long and I'd lost all my sense.
|
|
#
¿
May 23, 2012 01:27
|
|
|
I'll preface this with the fact that I dont know the first thing about databases and SQL, or if this will help you at all, but I bookmarked this post because it seemed useful at the time - http://chandoo.org/wp/2012/04/02/using-excel-as-your-database/ From what I can tell its a very basic instruction on setting up your sheet to accept SQL statements (via VBA).
|
|
#
¿
May 28, 2012 04:54
|
|
|
I'm sorry I dont know a better place for this. I'm trying to parse the following XML with VBA. code:
|
|
#
¿
May 1, 2015 11:11
|
|
|
|
| # ¿ Apr 28, 2024 12:05 |
|
|
Thansk for taking a look and I should have mentioned in my first post, the reason I'm finding it impossible to parse correctly. Your code, like all of mine, throws "Object Variable or With block variable not set" on the last line - GetUrlValue = doc.DocumentElement.SelectSingleNode("data/url").Text It's making me think my XML is broken or otherwise weirdly delivered. If you have any more suggestions, thats great, but in the interests of just getting this thing written I'm going to dump it all to a text file and search it out.
|
|
#
¿
May 3, 2015 11:37
|
|