Search results for query: *

I use a master workbook that functions as the open and close point for the macros that run the other workbooks. I have never tried a Save Workspace command, that may be next. But, when I try to use a macro that I know exists in my master workbook, it executes the first one or two commands and...

Sort of, I think that I am looking at a VBA failure, not just a problem in a single macro. On to plan B. All my inter-workbook macros are being eaten up when I open them. Thanks for your help. dbpcar

I am trying to write some macros to open several workbooks at a time and I am not having any luck. I have tried all the ways that I can think of to open workbooks, and the macro will not record any keystroke commands. I have done this before in infinite variety and never had a problem. I cannot...

Thanks for all the possibilities, they all seem to work.

I have a concatentate sentence that includes a date. The date comes up in number format, not date format ="not funded as of "&N2 n2 has the date in it. It comes up 37666 or some such, the absolute reference. Is there a way to convert this to a date that is recognizable? dbpcar

I knew there was someone smarter than me out there. Many thanks

I want to build a pivot table report that shows months as the header. I cannot get the table to build on months, only individual days. What am I missing? The table I want has year on the column, and months on the row, producing a summary by month and year. I tried splitting the date apart, but...

What a great little routine--thank you thank you thank you. dbpcar

Is there a way to sort the worksheets by tab, besides manually? Thanks dbpcar

Is there a way to keep the calculator that is in the accessories package on top, no matter what application I am using? dbpcar

brilliant and perfect, thank you! dbpcar

I have an excel mailing list that has the address and phone number together as below: "Costa Mesa CA 92626 714-557-2670" This entry is in one cell, separated by the computer graphic for "enter" I need to identify the delimiter in Text To Columns. I cannot...

I have a quick and dirty solution that will work for you if you still need a fix for this problem.... dbpcar

I have a macro that formats a stock number-the stock number is alphanumeric and the macro separates the numbers and letters. It is set to run as an equation in the workbook. I have to open the workbook that contains this macro to use it, I would like to set it as a either a button on my toolbar...

Currently, managers send daily reports, more or less reliably, by e-mail to the main office. Is it possible to set up Outlook to automatically send the reports, without prompting or any other action on the part of the manager, once a day? Thanks

Problem solved, I used the INT solution, it works best in my macros. Thanks for all the input. dbpcar

Thanks for your response, Dale. The problem is not what I can see, I can correct for that. The problem is in transferring to my accounting program, that amount is still in the cell as an artifact, even when I see zero. dbpcar

I am doing credit/debit entries in a blank workbook and instead of a zero balance I am getting the following: -8.88178E-15 as the result instead of zero. I dumped that workbook and started a new one, and I still have the same problem. I am a little confused here. This is an issue because the...

thankyou I guess this is the part about reading the directions first. s-)

Whenever I transfer a text document into excel it helpfully converts more data than it is supposed to...customer info is 3 letters and 4 numbers, and anytime this starts with 3 letters that excel thinks is a month it converts to a date. I need it to stay as a letter-number combination. I have...