Recent content by EddyH

You're correct but I want the whole shebang from drive to folder without opening the file once checked it is there.

By VBA I have found a filename within a known folder, could be .doc file or some other non spreadsheety one. As I am within Excel I wish not to open it but just to capture its filepath. Any offers?

I have a multitude of files within a folder being pdf and Excel. They are identified by their leading 3 characters ie ZZf....xls. Ideally only one Excel file will match ZZf in that folder. I want to quickly get the filename inside that folder matching ZZf so I can use it later. Doing this via...

OK bitDoctor I am an amateur at this stuff as you realise, on the lernin rather than burnin curve. Starred you as it looks like the answer lurks where you directed me. I'll start a new thread for each bit in future, thanks for the hint. Glad I didn't get any responses from psychologists to...

Thanks Bit Doctor I will run thru it later to disentangle what it does. I'll eventually need something to rapido the process when I've put it together. Given Tony a star so far as he set me on the road, but don't get upset! I now need to programmatically wrap the text but not to look as below...

Appreciate all replies will be useful for other stuff too! Got me on the right road This code with a twiddle or two will capture what I want. Also counts the pages! PageCount=1 Do If Not Rows(ActiveCell.Row).PageBreak = xlNone Then PageCount=PageCount+1 MsgBox ActiveCell.Row & " of...

Simple objective:I need to know the row numbers that are just below and just above the natural page breaks in a long Excel file of 1000 rows or so. I am writing a macro to automate thjis and other bits involving text wrapping so VBA method needed. It must be locked away in help somewhere, I...