cell a1 = 1206. This is really 12/1/06 in a date format, and this is the string I need to derive from this representation.
cell a2 = 107. This is really 1/1/07 in a date format, and this is...
I have several excell document that have multiple users accessing them, some users can open an make changes while other are connected, and some only get read only. How can i fix it so that all...
Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience. This happens when my user saves an excel spreadsheet.
What data does this error rep...
Hi,
I've got a problem with Excel 2007. If i try to open a file using any method other than the Office button in Excel itself it tells me that it cannot find the file. So, if i go to my Doc...
I would like to create an excel macro which highlights an entire row to red based on a condition within a cell. What is the best way to go about doing this procedure? Thanks.
I have a macro which scans all excel files in a directory. but the path of the directory is in the VB code.
i would like to know if this can be changed. i . e . path should be in the excel s...
Max points for Macro to Copy Excel Rows
Help&need to accomplish the following: Copy rows from one excel spreadsheet to another with each row being copied multiple times based upon the valu...
Hi experts,
I have a report that outputs text into a date column 'E' in excel.
This formula works:
The Excel function that converts dates to text is: =TEXT(XX,"m-d-yyyy")
XX is the ...
I would like to find an alternative spreadsheet program to Excel that can use my existing Excel spreadsheets, including the macros I have built into my existing spreadsheets. I find the Open ...
Excel 2003...
I entered a column of names...about a dozen...A5:A30
Then I went to the "borders" icon on the tool bar and selected to put a border around each cell...this give me a black ...
I am coding a VBA function in Excel with the following code that keeps giving me an error "Argument not optional" when I try to compile it.
The error happens on the call to WriteToINI.
A...
When opening a shared workbook in Excel 2000 receive followi message: "Microsoft Excel for Windows has encountered a problem and needs to close...". The specific information is as follows: AP...
In Excel I've inserted a "button" and assigned it to a macro. How do I change the face color of the button? I'd like to change the face color from grey to blue. Or better yet can I insert a...
I am looking for a better method to do search and replace for data on an Excel VBA file import conversion application. Currently, we have a subroutine that performs 4,500 search and replaces....
In a administration sheet used for software testing I want to count certain values for an overview.
I need some help for this situation:
A test-checklist leads to a number of issues. In th...
HELP! I have a customer that has Office 2007 and when they open a certain worksheet, it does not show the Maximize, Minimize or Restore buttons. However, when they open any other spreadsheet, ...
hello,
i'm trying to run excel file with macro inside via a batch file. with the excel 2003 i did it via -> "run excel macro" an EXE file -> it was opening the excel -> and it was uploaded vi...
i have problems using Save as method in excel macro.
In my code i am using Something like this open different worksheets in different excel sheets in a directory:
' setting up the Source ...
Hi,
my customer reports that they can open same excel file for editing with other users (same time). Usually Excel would open it as read only because it's already opened by other user.
S...
This is probably a very basic Excel question, but I just can't find the answer anywhere! If I type a word into cell A1 and make column A very narrow, the text overlaps into cell B1 (which is ...
Hi experts,
Is there any way I could create a VBA macro that when run would display a pop-up list of values of which one could be selected and inserted into the current cell?
For exmaple...
Ok Excel Guru's
I have 4 columns of data. Each column is a list (audit) of the computer names on my network.
The rows are from AD, SAV, WSUS, and a Network Security Scan Tool.
Some computer...
MS Excel (all versions) has two characteristics that have me fed-up; so I'm hoping someone with broad spreadsheet experience can make some recommendations. The two problems:
1) MS Excel can ...
Hello,
I found this function, FIFO, that computes product cost. I want to modify the example so I can apply it to my case. Instead of many product codes, I only have one product. Instead o...
When trying to save an Excel file to a mapped shared folder on 2003 SBS, the progress bar gets to about 98% then stops and after 20-30 seconds an exclamation icon appears in the system tray wi...
