Recent content by M0E-lnx

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?