hi Experts
I have a really long line of code:

sheets("Personal Format Presentation").Range("B21").value = Range("A21").value & " " & Range("C21").value & Range("D21").value

How Can I make this easier to read ?

Hope that makes sense !

Sandra

Is there a way to disable grouping worksheets in a workbook? I am using Excel in Office 2007.

Hi,

I'm trying to get data from others workbooks.

I have a workbook (summary) with a list of name (12MIRC026, 11MIRC032 for example)
and a directory with a folder named 12MIRC026 containing a workbook (data) named
12MIRC026.xlsm with of course the same thing concerning all the name of
the list.
I want to get a value from 12MIRC026.xlsm'!'!Validation!R5C3' and put it in my
summary workbook in order to fill my summary workbook (cell in red).
So I need to create a path changing according the list, so the path is
modified by a cell content(C7 for example).

Can you give me a hand

Hi all
I have a external Hard Drive which i use to store all my Audiobooks. These Audiobooks are organised by Folders (Authors Name=First Name first then Last Name) and those Folders have subfolders where the various Book Titles are stored. ( I might also have in there a separate sub folder for a Series that that Author may have written) What i would like to, is make a list in excel showing me a list for all Authors and which book i have from these Authors. ( and if they have a Series what Titles i have in that Series)

HELP!

I have a workbook, consisting of 4 spreedsheets...Master, Daily, Weekly, LND Scorecard...

What I am trying to do is only input data on the master spreadsheet and have the data pull automatically to the daily, weekly and LND Scorecard. But different data is pulled from the specific categories of that spreadsheet.

File is attached

Daily: Needs to pull on the properties that are triggered the "Supply Estimated HUD" date. and only pull the columns specified on the daily spreadsheet

Hi !!

I have a macro code to save my invoices but I want to change it.

In my invoice template, A12= John Smith // C11= 10/01/2012 // C12= 00000002, and my current code is:

Sub SaveAs()
ThisFile = Range("C12").Value & Range("A12").Value
ActiveWorkbook.SaveAs Filename:=ThisFile
End Sub

This code save my invoices as: 2John Smith.

I want change the file name to "Inv 2 John Smith 10-01-12"

Can someone help me?

Thank you,

hi Excel Experts.
I am an Excel newbie, and I'd like to know whats the best way to learn VBA ?

I am looking for some help in creating an excel file that can auto-create invoices. I have attached my excel file. Basically what I have is a worksheet that I use to track the daily activities of trucks. In about 4 weeks I will be entering around 40-50 lines a day and have multiple "Master Invoice" numbers. What I would really like to do is to be able to type into a box or something the invoice number I want to create and then have excel auto-populate the fields.

Having trouble with Find function (that is, cntrl+Find). It can't find anything, even if the search argument is available. What am I doing wrong?

Hi

I am just starting to learn VBA, i have attached a excel sheet and there is some data in column A and i want it like in column B. I tried it with loops, array and select case but didn't got success. Please help me.

Thanks,
Manish

Hi,
I am trying to pull data from different sheets in a workbook. Basically I want to be able to type in a date and then have it pull the customer information for that date onto my sheet from multiple sheets. There can be different customers for that day on different sheets. I need it to pull the whole row of information for that date onto one sheet.

Thanks,
-Teryn

have a small problem that i was hoping you can help out with

i have a excel file where i input some data. but i want the fields to
be automatically to populate a internet form which saves it
somewhere.

is there anyways to export this data set from excel to an internet
form much like this form.

Name:
Card #:
Phone #:
Problem: ****this is a drop down menu all I want this do is select the
3 option "help"****
Notes:
ID:
Phone EXT:
computer Name:

I know this looks like i'm spaming people but i'm really not.

hi my friends
can i use excel to work with graphs like determining the number of plates by mccabe-thiele method ?
plz help

Hi,

I'm creating a new Workbook, but it has lots of sheets all of them as calculations, so when we implemented the following code:

Private Sub Button_Calculate_click()
Application.ScreenUpdating = False
Application.CalculateFullRebuild
Application.ScreenUpdating = True
End Sub

And the excel is updating all the cells, however I just want to update the
row in which I did the change. I can identify the row, but I don't know if
there is some way of only calculating the selected row. Can you please help
me?

Thanks in advance.

Hi All,
I have the need import multiple text files located in single file folder to excel worksheets(preferably to multiple sheets). I have sperate text files with diffrent file names stored in one folder. I want to import them in to seperate excelsheets. Please let me know if this can be done. I am not an excel or VBA expert. Any help would be great.
Thanks
Eranda

Hi!

I need help with a VBA Code that is giving me an error:

Private Sub Worksheet_Activate()
With ActiveSheet
If Date > CDate(.Name + 5) Then
MsgBox "No changes allowed"
End If
.Unprotect "PROTECT"
.Cells.Locked = True
.Protect "PROTECT"
End With
End Sub

The error keeps happening in the:
If Date > CDate(.Name + 5) Then

Here is what I am trying to do:

Hi Vishesh,

I need VBA code to perform a check for naming conventions of about 100 excel files. It includes following tasks.

1. Asks for a path for an excel file which has about 100 file names in it, open it.

2. Ask to browse a folder which has 100 files in it. Compare each file name from that excel file in to a this folder.

3. If match doesn't found (Should be a strict match) it should create a list or highlight that files in to excel file.

I am looking to type part numbers into a sheet and then have it look into my drawing folder, and create a smaller version of the drawing in the sheet beside the part number.

Most of the drawings are in PDF format.

Basically like a catalog but without a description.

I have weekly reports of products required to ship, that I'm trying to make a list with a small drawing beside for pickers to find and package.

Is there a way to do this?

Hi,

I required additional code for my macro. My macro is attached with this.

For your information let me tell you that I first input data starting from cell C57 and cell D57.in tab B. In tab C I first give range in column A and column I give table name to the selected range in both the columns and then input the data in W58 and X58 for comparison. And then I run both the macros. I want this task to be done by additional macro code and also want to combine both the macros in one macro.

Additional code require this to do:

In “All Media” tab if file name is,

I am using the following VBA code whilst capturing a number in a WORD doc text form field, because the WORD document form that I am creating loses the formatting when you save and reload the document.

Despite having the correct format #,##0.00 the number truncates the decimals so that 45.67 appears as 45.00 – I suspect that this is happening at the input stage – any ideas ?

Sub formatfldresultN()
Dim ffname As String
ffname = Selection.Bookmarks(Selection.Bookmarks.Count).Name
With ActiveDocument.FormFields(ffname)
.Result = Format(.Result, "#,##0.00")
End With
End Sub

how do I display the full path in excell 2010

Hi !!

I'm new at VBA and need help.
I have a spreadsheet with a summary of all my sales. In this spreadsheet, I have a column "C" with description of the item sold.
I need a code where "If cell C1 = x then copy row to worksheet 2", "If cell C1 = Z then copy row to worksheet 3"...
I want to be able to split my items sold to different worksheets according to their description.

Please I need help URGENT.

Thank you

I've produced some code which goes down a drop-down list and creates a word report for every entry but i'm looking to modify it so that it incorporates a combo-box rather than a drop-down list but i'm struggling to make my code work properly so any assistance you can provide would be extremely appreciated.

The code is

Sub Report()
 
Dim Cell As Range
For Each Cell In Range("Regions")
Range("A4").Value = Cell.Value
 
    Dim wdApp       As Object
    Dim wd          As Object
    Dim sFil        As String
 
    On Error Resume Next
    Set wdApp = G

i need an help from you guys,i am creating an data base file ,where people can enter data and later they can print out by queries and they can Update all the previous data...i have three user form for that,

userform 1 where people can enter data,which is working fine,

userform2 where people can queries and print out...which is not working

... userform 3 where people can update old data..which is not working as well...i am getting an error every time "permission Denied" friends ined help on this data base file please any help appericiated,

Hi,

Myself using Excel 2007

Is it possible to have a hyperlinked rowlabel/column label in pivot table

I need vba code to reference a cell from a closed workbook to a cell in another workbook. I currently have code that is a combination of cells that create a file and path from where the file resides. So I'm trying to get what show's up as text, to appear as a formula so the true value can appear. How do I do this?

I’m designing a website for a kids’ football league. A very small, cheap, no big-back-end or cms website. They want to be able to update it easily, and I’ve found a site they can log into, so I can just edit the code slightly when making the pages, and they can easily just go and log into this site and edit the content in specifically defined areas on each page.

But, every Saturday there are games, of course, and scores for those games; and then the league tables change. the guy whose job it is, currently manually updates all of these in a many-sheeted spreadsheet.

I hope somebody can help me as I am new to macro and do not have sufficient knowledge to fix my problem.

I would like to create a workbook for my students' personal information. I am looking for macro to copy rows based on partial cell content of a column. I would like to copy those data to other new worksheets when a certain criteria met.

Below is my sample:

(Sheet: Student Info)
Name: Peter
Staff ID: E90001
Class: 4D
---------
Name: Mary
Staff ID: E90103
Class: 2E
---------
Name: John
Staff ID: E93125
Clasee: 3A