Search results for query: *

Hello Am a little dusty with this and not sure if this is what you are looking for, but for inventory, the MARC table should have basic inventory by material and plant with min and max levels. So you could see if something is below the min level... Not sure if that helps...

Hello everyone I would like to find a way to copy all items from a calendar in one of my personal folders to all my calendars, which are spread accross multiple folders. I am not aware of a setting to synchronize all of them, so figured I could do this through VBA. Problem is I have not...

Please disregard this posting. I was able to accomplish my goal through using the API Timer Functions. Thanks

Hello I have spun my wheels enough, and now need some help. I have a reminder in outlook set for every Friday, to tell me to update a status file. I often just dismiss it and then get very off track and do not remember to update the file until the weekend. I want to put some code in the...

Here is what I am talking about: I am launching excel from withing an SAP application and when I select to disable macros I get the message: "This workbook contains a type of macro (Microsoft Excel 4.0 or Visual basic) That cannot be disbled..." So you either enable macros or the workbook...

Thank you for the replies. I admit, I didn't see how what I was asking would be possible. I have done your suggestions, and that works fine, but just thought I would ask. I think my mind is playing tricks on me and I never actually saw a workbook do what I was proposing.

Hello I have seen workbooks that will not allow you to open them unless you select "enable macros." Just wondering if anyone knows how this would be accompished. Thanks

I still have the problem. Have you found a solution?

Sorry, I should have included all that. Win2000 is what I am operating on. My Access version is 97. Any access database causes the problem. for instance...I just created a blank db. If I just I do nothing, there is no problem. The moment I try anything in the db, my usage goes to 100% and...

Hello I hope someone can give me direction. Microsoft Access causes my computer to crash, if it has been opened for a couple minutes, regardless of the DB size (CPU Usage maxes out and never drops unless I close Access). I have tried everything I know and have exhausted all knowledge in my...

Thanks for the advice. Here is something I threw together for 2 columns, RC and Amount. Could you let me know if this is a good method (I am extremely new to Excel VBA)? Also, if I were working with say 15 columns, would building an array based on the number of columns to hold the data...

Hello I have worked with Word and Outlook, but am new to Excel VBA and am wondering if someone can get me started with this. I have a query tool that loads in Excel, from SAP. The data may look like this: RC Proj Amount ABCDEF AA $25.00 ABCDER AA $25.00 ABCDYT AA $25.00 ABDFGE BB $25.00...

Jesternails "Can a scheduled task kick off a macro in outlook while it is open?" Here is something you can do. Create a reoccuring item with a reminder set. Now put some code in the Reminder event that checks for the type of reminder and maybe something in the Subject. If all holds true...

Thanks for the reply. I should have been more specific. We have an instance of FileNET and project related documents need to be stored there. We do not have FileNET fully integrated with Microsoft Office (FileNET group said there are problems with the integration) and so it is tedious for...

Hello Having trouble figuring out how I may do this. Let's say I want an event to open Windows Explorer and then perform operations in that environment. For instance, I want to open windows explorer and then go to the Map Network Drive tool. Is that possible? Let me know if this is not...

Just thought I would throw in a couple considerations you will need to make...I created a document with extensive naming logic and ended up having to scrap most of it for various reasons... 1) Where will the document be stored? A FileNET type of environment does not work well with the...

I know very little about Outlook, so thought someone may be able to help answer what I imagine is a simple problem. I am composing a mail message. I click a custom button and i want to be able to insert something (text, hyperlink, etc..) where the cursor was when I clicked the button. the...

Hello I posted this in the Office forum, but thought I would here as well, since I get such good VBA answers from everyone... Does anyone know if there is a way to set a max attendee limit for meetings? I want to send a meeting notice to 40 people, but only allow 20 to sign-up. So after 20...

Hello I posted this in the Office forum, but thought I would try here, since I always get such good answers to my VBA questions... Does anyone know if there is a way to set a max attendee limit for meetings? I want to send a meeting notice to 40 people, but only allow 20 to sign-up. So after...

Hello Does anyone know if there is a way to set a max attendee limit for meetings? I want to send a meeting notice to 40 people, but only allow 20 to sign-up. So after 20 have accepted, all others trying to accept would receive a notice that the meeting is full. Any help would be...