@JasGot said in Late Night VBA Help Needed:

@garak0410
Is the original document already an excel spreadsheet? and in this function that e-mails the document you also want to "save As" the document?

This is what we use in one of our vba apps, it saves the excel to a new name in another folder.

SaveAsFileName = "s:\Sales Docs\Quotes\Sales\" & Forms!Call_Ticket!Combo101 & "-" & Forms!Call_Ticket![Project Name] & ".xls" xlApp.ActiveWorkbook.SaveAs (SaveAsFileName) Set xlSheet = Nothing Set xlBook = Nothing Set xlApp = Nothing

This problem sounds familiar.
It's not a normal.dot type problem is it? Where the originator used normal.dot as their doc tempate, saved it as .dot again and it's screwing up everyone's normal.dot that reads / alters the document.

We use Trello and like it a lot, but we use it for a coding process, not job tracking.

@Dashrender said in Excel freezing:

@wrx7m said in Excel freezing:

@VoIP_n00b said in Excel freezing:

Excel is a bitch

Especially, here. They are running all their forecasts through it. Excel using something like 16GB of RAM for one sheet.

As much as that likely belongs on a DB server somewhere - who's going to set it up? and program the new interface, etc?

yeah. that has been in the works for over a year. We are syncing the data to SQL and then will be able to run queries and also export it to Domo.

Ah, the old reboot/reinstall/redo.

@LilAng said in Copy / Paste from Excel on Mac to Outlook Web Access Creates Image Rather than Table:

In Excel, use File > Save as web page, then attach the web page to your email message?

Yeah, we found that process. That's a pretty huge "fail" process.

@DustinB3403 if you have them filtered down and want to cut/paste to another tab, you can select "visible cells only" by going to Edit / Go To... / Special... and select "visible cells only" to cut/paste just those rows visible in your selection.

@DustinB3403 its been 2 years. now im using w10 . and no issue

I have seen weird/slow response with the video/hardware acceleration turned on. Try disabling it.

@dashrender said in Excel - auto recover:

@scottalanmiller said in Excel - auto recover:

@dashrender said in Excel - auto recover:

@jaredbusch said in Excel - auto recover:

@dashrender said in Excel - auto recover:

@jaredbusch said in Excel - auto recover:

@dashrender said in Excel - auto recover:

@scottalanmiller said in Excel - auto recover:

@wrx7m said in Excel - auto recover:

That is why I tell people the policy is to reboot every night before you leave for the day. Most people do... some don't. This is the exact reason why this is the policy.

Yup, I agree, end of day reboots are the smartest if you can get people to do it.

Most of our people do - the few (really the one) who doesn't is also the one in charge. I can't make them.

Sure you can. If it is company policy, you simply create a schedule task to reboot machines.

LOL - You're on a roll today!

Just stop covering up bad behavior.

You, and others make it sound like I have a choice here - I only have two choices, perhaps three - 1) quit
2) according to you all ignore her
3) just stop talking to you all about trying to find solutions to provide to attempt to fix things.

No, you are missing the one thing we all recommend...

The CTJ talk. The talk where you give her the options and make her choose. You don't make up the options, you just enumerate the ones that exist.

No one has suggested any of the things you think we are recommending and missing the one choice we almost all agree on.

Can you spell out those options, apparently I've missed them.. .I feel like I've already gave her said options.. and she chose the one not on the table - to do nothing and still complain about it.

At which point, my option option is to basically ignore her - stop caring, whatever you want to call it, it's basically the same thing.

You can come up with the range of known options. Examples:

Use Google Apps and live with their save mechanism. Use local Excel and live with it's save options, either auto or off. Use Excel online and live with its save options. Use a different application, like OnlyOffice. Use Excel with auto save but get a "save all changes" storage system like Exablox

Tell her what is possible, that's your job. Afix prices and info to each. Then make her decide. Then any complaints you just tell her "hey, talk to the person who made this decision... you".

The system was set to automatic.

Use Drupal. It's almost purpose built for this type of stuff. Custom content types and views make anything possible.

OK so it's a complicated pivot table but it still a pivot

Also this is what I've done, but modified the latter half of the page to keep everything in place.

Well the report is automatically generated from a system we use here. So if possible, rather than having people have to open 2 files, I'd like the modules to just import when excel launches.

I suppose I could bury the modules into the personal file. But I'm not sure if that't the best approach.

@gjacobse said in Need recovery software my excel files got corrupted in my pc 😞:

@RoopanKumar
Were you able to resolve your Excel issue?

I'm going to assume so and close this one out.

@Carnival-Boy said:

the wonderful, and under-rated, Microsoft Access.

Die in a fire heretic!

@JaredBusch said:

@scottalanmiller said:

If you learn a language just to do this, Python would be my recommendation. Specifically well suited to learning, good for doing small scripts of this nature and good for list processing like this. It's just a good fit. But yeah, if you know some other language already, definitely go with that.

I dislike any whitespace delineated language.

I do hate that aspect of it, very Fortrany, but it does make readability a clearer priority for the newbies and can have benefits, especially when working in teams of non-full time programmers.