when included in the
add-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.
--
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 a
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
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
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 origina
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.
2)
Hello People,
Just in case any is actually working on a solution to this rather urgent
problem of mine, I have updated the vb_macro file with the updated
conditions as I stated in my earlier post. I have added the POS/NEG
conditions (outside bracket elements) as well as the VPOS/VNEG/PPOS/PNEG
--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'
v.
do i = 1 to ctl.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 ?
