Anyone ? This is a really annoying issue that I am just unable to fix.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick
-in/xlstart file ?
That is my problem. When using the xlstart file, it opens automatically
every time I open a csv file no problem at all, it's just I get the 400
error every time I execute one of the macros contained therein.
Any other suggestions ? Regards, Fin.
--
FORUM RULES (934+ members
I am very new to Excel VBA Code so please forgive my coding clumsiness.
I have the following Code that I use to format various reports. I want to
be able to install it automatically for CSV files I open, format then save
as xls files. I have tried creating both an xla add-in file and when that
Oops, Excel 2002 on Office XP Pro OS = XP Pro SP3.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not
So, no takers huh ? .. Anyone .. ?
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
Haseeb, thank you so much for your efforts, that is amazing I must say.
I'm frankly staggered how you achieved that with formulas. Now I must admit
I'm lost as to how you did so, but I kind of need to know if I am to repeat
the task with the next days report. The end of day data that the
--here we write out the macro to highlight active stocks in
yellow
v.line_out = 'Sub Color_Active_Yellow()'
v.line_out = 'Dim CellVal As Variant'
v.line_out = 'Selection.CurrentRegion.Select'
v.line_out = 'iRows = Selection.Rows.Count'
.0
If body = ctl.1.i then xlobj~Selection~Item(iR,
iC)~Interior~ColorIndex = 6
End -- Do ctl.0
End -- Do iRows
The rest of the code is of course a lot bigger but the above is the
area I was hoping to optimize.
Anyone with any bright ideas ?
Cheers, Fin
