Search results for query: *

Hi All, I have two fixed width text files which I have created from an excel workbook and I'm trying to append one to another and output the result to a third text file. I've been using the shell to do it as it seemed to be the simplest way. The following works fine: OutputFolderName =...

View > Watch window somehow isn't displaying the watch window. I suspect that I have moved it to one side at some point and somehow I can't get it back. Help!!!

This is probably an easy question but I couldn't find the syntax to do this anywhere. I just want to use VBA to modify a pulldown menu to open a word document (in excel). I can do it manually so there must be a way to do it using VBA Note that this is excel 2003. Set Btn_HelpSupps =...

Note: Excel 2003, OS Windows XP (or Windows Vista) Hey There, I have a couple of old excel toolbars which I can't seem to get rid of (and neither can my users): Both the code below and manual edits work fine in the current excel session but then if I exit excel and start again, Hey...

Note: Excel 2003 Hi There (again), I'm currently tearing my hair out trying to define ranges using variables rather than hard coding in the references Dim TheCell As Range Dim TheNextCellDown As Range Dim ANCol As String Dim StartofDataRow As Long Dim i As Long ' These Values will...

Just thought I'd ask before I put this: Public Const XlMaxRows As Long = 65536 In the various bits of code I have. I figured surely they would for backward/forward compatibility. Or am I just Fantasizing ??

Note: Excel 2003 and XP operating system. Hello All, I had an issue with trying to identify/count how many windows I have open for a particular workbook in VBA. Then as I was typing it in here I worked it out. So I thought I might post it as a hint to see what you People think. If for...

I have a multi-user database (single mdb with everything in it) on a network drive which has been working fine for about a year now. The problem that is occurring is intermittent. The user will be editing a record in a continuous subform and/or adding a new one (the VB code will be doing it...

(see also thread702-1520919 ) Hey All, This is a problem that has suddenly appeared in a Database that has been working very well for a number of years. It is a single shared database on a network drive which can have up to around 20 users. - The Version is Access 2003...

Hey there, this is a pretty simple question - I just need help because when I run the macro recorder I can't select stuff with the mouse, I need to select the first 2 rows in a table in Word so I can set them as header rows: eg. 'Set the first two rows as repeatable heading rows ' This ain't...

Hi all, I've been trying to use some public variables in my DB but they seem to "disappear" quite easily and I was wondering if anyone was aware of this problem (2003) ' Vars are defined when the database opened: ' Public Vars for the Valuations form Public Task_Subform As Form Public...

Hi All, I'm currently trying to build a "universal" filter form with which to apply filters to existing reports as they are opened. I have built the filter with no problems but I have trouble applying it to the report when using a variable for the report name rather than the actual name. I...

Hi All I'm just wanting to clarify before I start coding away (I haven't done any for 2 years) that using the Dlookup function is not the same as a lookup column in a table. I gather that a lookup column in a table is where you use an ID which links to another table where the Valid list of...