Search results

The pricing needs to be adjusted because some of the pricing (metals) change on a daily basis... so keeping the prices updated is a task of its own... but most of the stuff's prices are stable Here is what I have so far, with the purchasing side simple enough, but fits my needs as it is...

Thanks for the replies so far guys. I've checked out those data models and they really dont help me much. My situation is not about inventory, but rather quantities ordered vs quantities invoiced. Like I said, I got the purchasing side of things setup the way it should work... There is a parts...

Hello forums. Using access 2010 here. Trying to setup a database that would allow me to create purchase orders, and then receive the items within that purchase order I think I got the purchasing side of it setup properly, but i'm having trouble with the receiving side of things. For the...

Never mind All, I just found the ActiveWorkbook.Name which provided what I needed.

Does anyone know of a way to read the name of the currently open file in excel using VBA? I've tried the Application.Getopenfilename, but that brings up the Open file dialog which I do not want. If I'm editing a file called "Sample-sheet.xls" I need a way to find that string in VBA Any ideas?

Me neither... I've been having to manually edit the body string to format it correctly.

Thank you.. I never realized that... works like a charm. It's been annoying me for months.

Anyone ran into this problem before?

Situation: I have a VBA function that collects information from the current excel worksheet and some text files on my system. Uses this information to generate an email, and attaches a copy of the current worksheet to the email. All works fine, and it really works wonders... saves me a ton of...

In that case, I'd better leave it alone.. it's probably more than I can handle. Thanks

Is it possible to trigger a macro when exiting / updating a cell in excel?

Hi, I need help figuring out how to do this I have a template that I use a lot. From this template, I save the filled out .xls into a separate folder to keep for our records.... What I want is a way to do away with typing the same information over and over... so I have like 50 shipping...

Yes.. new project the un-hide option is grayed out When I open my template, I can hide it and do it that way, but I need to always open that template. It'd be nice to have it setup like you said, but I can't find a personal.xls in this box... I already ran a search for it.

I just tried that, and the unhide list doesn't show a personal.xls Using Excel 2003 here

And where is this Personal.xls file located? or can I just store it anywhere?

So you keep this Personal.XLS file open @ all times?

Hi, I have an excel template that I use every day.. pretty much the same routine.. Update the date field, make the necessary changes, attach it to an email. I thought it'd be nice to create a bit of VBA code to do the routine stuff, so I did. I have added a button on my toolbar which has...

Indeed, I've tried using the after update and change events, but they dont seem to fire up unless data is physically entered. I need these 2 fields compared if they both hold the same value, I'll trigger other things

anybody?... I've been trying to get this, I can't seem to wrap my brains around it

I haven't tried this, but I would imagine you can add a textbox then add a timer and on the timer's event, you set the textbox's value to now() formatted however you want it..