[ARCHIVE!] Any rookie question, so as not to clutter up the forum. Professionals, don't pass by. Can't go anywhere without you - 4. - page 401
You are missing trading opportunities:
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
Registration
Log in
You agree to website policy and terms of use
If you do not have an account, please register
What do you mean?
I mean that they used to tell me within 24 hours, but now I can't get through. There used to be a dialogue and now there's silence.
There!
The man can't open the door... "Maybe the Sum_Loss variable should be specified as a negative one? I got confused. I tried a lot of variants, but I didn't get the right result. I want you to guide me in the right direction, tell me how to do it, because I don't understand what I need to do.
Service Jobs - help! As I've already recommended:
"If you can't do it yourself, go to the "Jobs" section of the fifth forum - they do it for food...
The code will be written for free from scratch ONLY if you have personal interest!
Everything."Application.DisplayAlerts = False OpFn = fName + ".txt" ActiveWorkbook.SaveAs Filename:= _ OpFn _ , FileFormat:=xlCSV, CreateBackup:=False // FileFormat:=Text попробуй такой вариант формата ActiveWorkbook.Save ActiveWindow.Close Application.DisplayAlerts = TrueMake a blank macro :
menu\developer\macros\record
stop recording
macros/macro panel/change
put this code in it, fName == file name when saving.
Save macro should be a hotkey, save document. first you open the book with the macro, then (on top of it) open your file, do what you need, and then press the hotkey, it saves the active (your document at the moment).
Is it converting dates?
Yeah. Yeah.
It's got this nasty habit.
Are you digging into reports or tick reports ? what is the task ?
try digging into the date format, through the main menu, see the localisation.
Although in the case of 10 will not help, I can't stand it - it does everything in its own way. The best for this is 97 office - fully manageable, 2003 is not bad either, and the new ones will do what they want.
He has this nasty habit
Are you digging into reports or tick reports ? what is the task ?
try digging into the date format, through the main menu, see the localisation.
Although in the case of 10 will not help, I can't stand it - it does everything in its own way. For this the best is 97 office - fully manageable, 2003 is not bad either, and the new ones will do what they want.
These are tests of the time conversion function. 11000 variants with benchmarks.
Edited by hand in UltraEditor in 30 minutes. I only had to add 200 cells. I was spending more time on the settings and experiments in EXCEL. It's been almost twenty-four hours already.