Search results for query: *

I went into about ... forms3: 14.0.7140.500 version 1628

I dont know....how do i tell....sorry this is so complicated ...only worked with vb a little bit

the text box name is data5 if I click define name is gives me a refres to =Invoice!$E$12

of I get object required if I take out the sheet.

Debug.Print Data5.Text Debug.Print sheet.Data5.Text I cant get these to work... method or data member not found

same problemish.... it says method or data member not found and if focuses on data5

still having trouble with pulling the text out....run time error ThisWorkbook.Sheets(1).Cells(i, 2).Value = data5.Text and if I negate that line it doesn't cycle through the all of the workbooks

and yes it is the various invoice workbooks

Workbooks.Open (directory & fileName) this is going to open each of the work books and im going to grab the text out of a couple of textboxes.. but each of the textboxes info needs to go into a differnet spot in the new excel sheet . and some of the data is going to get searched through and only...

the code is in the file clients1 each invoice sheet is identical Workbooks.Open (directory & fileName) this is where the text box is located Workbooks.Open (directory & "clients1.xlsx") this is where the data is going to end up (should I have this outside the do while loop) inside the...

directory & fileName is where the text boxes are coming from directory & "clients1.xlsx" is where all the data is going to go Do While fileName <> "" i = i + 1 j = 2 jj = j + 1 Cells(i, 1) = fileName Cells(i, 2) = lastTextbox...

all of the invoices are in different workbooks. that the only way I can find to get the data out of them, is have the vb program open the workbook and hopefully pull that data out. the final print out will have all of their data in a row and the then next client under that. I don't...

here is a copy of my invoice next to name there is a text box named data5 I am trying to get that string out of that box ... if it goes somewhere, how do I find out where it has gonehttp://files.engineering.com/getfile.aspx?folder=05e3de36-aefa-4519-91a2-1192031fac49&file=invoice.png

I am trying to read text out of a text box in our invoices and make a master sheet that has all of out customers info on it its going from a text box to just getting placed into a basic excel spredsheet

no they are not data5 in in a work book "filename" and I want to put the in a new work book "clients1" the vb code in being done inside clients1 if that makes any difference

yes

Im trying to write a progam that takes text out of a text box named data5 that is in a excel document that which I have defined as workbooks(fileName).worksheet(1).I want to take that string and save is a lastTextbox and put it in a another excel document that is called Clients1 at cell(i,3)...