I am having an issue with Microsoft Excel 2003. I can open the application and do work for it. The problem starts when I open an Excel file saved work, I am seeing this error:

Cannot find the file path (or one of its components). Make sure the path and file name are correct and that all required libraries are available.

I’ve tried to save the file in a USB, and open it from another computer, and it works. Also, this occurs in all my saved Excel files. So I am sure this has something to do with my Microsoft Excel application.

Hi,

I am working on a project in Excel/VBA and am unfortunately got stuck in a technical issue.

In fact, I am trying to develop a loop as I want to check for a cell and on the other hand the cell contains nothing, I want to populate some data into another particular cell.

If I would tell you in context then, it would be as like I want to check cell f1, if it is not empty then I would like to enter the VALID in a specific cell (suppose) G1. But when f1 should be blank/empty then the G1 would likely leave blank.

Conclusion: at the point/stage F1 appears as empty cell, that should be or possibly the end of my produced data. I want to do this via do while loop to stop (the operation) but I am not been able to do so.

Hi,

I have an Excel sheet containing about 1,200 rows. Each of the rows has different customer information. I want to know how many of them have dues.

Problem is the number of rows is not fixed. They may vary. So I can’t count the number of empty cells and just minus it from total rows. Do you have any suggestion?

Hi,

I am learning Excel VB programming. It is quite easy. But I don't get how to use custom function in here?

Public Function gradeCal(gpa As Double)
            If (gpa >= 5) Then
                Return "A+"
            ElseIf (gpa >= 4) Then
                Return "A"
            ……
End Function

Hi,

I am doing some work with Excel. I am not much familiar with VB but the Excel macro seems easy and interesting. I have yet used MsgBox and buttons to do almost everything. The Excel sheet was the main window which is used as a form for hosting the other stuffs.

For example if i need 3 data to input I use something like

x = InputBox("enter the value", "Its the title")

3 times.

Now I think it would be cool to have my custom popup messages/forms for doing all these. But how do I do this? Please help.

Hi

I have been playing around with Excel a few days. It is really a nice tool. I can do a lot of calculations here with less effort. I have also heard that it is possible to do some programming with excel too. So i thought i will try.

Here is what I want to do first.

My present sheet has 7 columns each are having a value (cash amount) in each of them. The 8th column holds the following equation:

=SUM(A1:C1)/3+SUM(D1:E1)/2+F1+G1              

So it gives the summation of the left 7 columns. The equation changes from A1 to A25 , depending on the row number.

Hi,

I have an Excel application that is just a simple crude database for my coffee shop. There is a form which takes order and prints the Receipt. We have 3 types of coffee in the shop and we are increasing. Currently, in the form we have to add the whole name “Black” , “Light”,  in the type field to create the receipt properly.

I want a drop down box there which will have all the types, so I can just select it from there. How can I do this? I am not an Excel expert, nor even a programmer. I hired a student to make this Excel file for me which I copy-paste every year.

I can see the code and that is very interesting! So I thought that maybe I can do this little tweak. It may be possible if you help!

Hi there,

I have developed an Excel VB sheet to generate transcripts. The application is simple. But I don't know how to print the page with macro. Currently, I just copy-paste the generated transcript to Word and print it manually. This is not looking much professional. So  I would like to make it automated.

Please help.

Hi,

I am using Microsoft Office Excel 2007, but I do not have enough skills in Excel. That's my main problem – I do not know how to classify different data and sort them according to my wants.

Mainly I need help in the field of Filtering Data. How does it work? Moreover, I will be glad if anyone tells me how I can write formulas to sort my data easily.

Excel is a very important software for me, as I have to work with it regularly. Can anyone tell me the meaning of those formulas used in Excel?

I want to know how those formulas work. I have tried to understand this but I couldn't. Those formulas can make my work easy, so it's very important for me to know how these formula work.

I encoded thousands of names to update our employee list but I forgot to put the numbers before the names so I can monitor the list, 

How do I save time from typing the numbers?