Posts made by garak0410

garak0410

Not sure...the store Remote Desktop has always worked until now. Both machines are up to date with the same updates and versions. It has been baffling for sure. Like I said, the traditional Remote Desktop works fine and is the workaround.

garak0410

@dustinb3403

Windows 10 (1709) to Windows 10 (1709)...

garak0410

Has anyone seen this error recently?

I can't seem to resolve it. The user's passwords are fine both in AD and saved in their remote desktop applications.

They are connecting to VPN just fine from their home back to the office but remote desktop will fail with this error.

If they revert back into the older, built in RDP, so far, it works. They prefer this "store" version of RD

Any suggestions?

garak0410

@scottalanmiller said in ZoHo Creator - Anyone Using It?:

vFront is likely what you want.

@scottalanmiller said in ZoHo Creator - Anyone Using It?:

Not used Zoho Creator. I like Zoho overall, but things like that I feel are just really bad ideas. But we have developers, so we don't have the limitations that some companies have, either.

I'll check out vFront. But might be a moot point unless I can whip something up real quick. I'm still taking baby steps in improving my dev skills

I think ZoHo is going to be a waste of money if we are going to end up just dumping back to Excel to format (which my boss suggested if ZoHo can't make reports like we want.)

I'm just surprised there isn't an active community for ZoHo. My forum posts seem to be in limbo on their official forums.

garak0410

My company is really pushing for a database/reporting option that will replace two messy but company critical spreadsheets. I'm the SOLO IT Director/Person but they decided to go around me to a building engineer who has C# experience to see if he can program it. But between his normal duties and the time needed to do this, he passed. But he lead them to Zoho Creator so they are turning it back over to me, despite some of my concerns with it. But it is what it is and I have to move forward with it (and a whole other discussion). My concerns about ZoHo were the cost per user for what little they will use it for and Zoho's slow support and forum moderation. I tried to look for options within our Office 365 Enterprise E1 that would be as easy as ZoHo but I couldn't.

The main spreadsheet has always shown the deliveries with the customer in the rows and details about the deliveries like colors, date, miles, dollars, etc in the columns. The current sheet separates the weeks of deliveries by a simple black line and at the bottom of the sheet is the year to date dollar totals to show the owner of the company. This is pretty much the sheet he drives off of to know how sales are. The other sheet shows what is yet needed to deliver a job. All the data I've so far imported into the database on Zoho will let me create these two reports and other options.

The problem I have is I can't get find documentation on how to do things in ZoHo to make it report like the spreadsheet. Sure, a lot of it is simple but finding documentation in ZoHo or getting a response in email or forums is difficult.

I'd love some opinions on ZoHo but I don't think my company will change from this now. So, overall, I'm looking on how to get more detailed reporting as described above and to make it print and look neat.

Thanks...

garak0410

Happens to me too much...

0_1515437828463_babylon5exit - Copy.jpg

garak0410

I think I am closer...the first worksheet doesn't have column D protected. The rest of the pages do have column D protected. If I unprotect column D on the other sheets, my macros finally work.

However, management wants column D protected.

This worked fine under the recorded macros but not the rewritten ones I had to make to support Excel 2003.

garak0410

@dafyre said in Rewriting VBA Macros from Excel 2013 to Excel 2003 - Works One One Sheet Only.:

@garak0410 said in Rewriting VBA Macros from Excel 2013 to Excel 2003 - Works One One Sheet Only.:

Ws.Range("D2:J9").Sort Key1:=Ws.Range("G2"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal

I can't help but notice on this line, the Ws.Range("G2") is that supposed to be a range or a single cell?

If it's a single cell, what happens if you try Ws.Cell(2,"G") ?

Good question as my "chicken scratch" VBA code sometimes didn't make sense that it worked at all. I'll give it a shot.

What is mind-boggling is that the "G2" reference appears in all of the Macros, even their first line is not G2. And the Macros on the first page all work correctly, even with the G2 Reference in them. I'm sure this is mega easy but just can't find the problem.

garak0410

@dafyre said in Rewriting VBA Macros from Excel 2013 to Excel 2003 - Works One One Sheet Only.:

@garak0410 said in Rewriting VBA Macros from Excel 2013 to Excel 2003 - Works One One Sheet Only.:

@dafyre said in Rewriting VBA Macros from Excel 2013 to Excel 2003 - Works One One Sheet Only.:

@garak0410 said in Rewriting VBA Macros from Excel 2013 to Excel 2003 - Works One One Sheet Only.:

I've had the unenviable chore to re-write Macro's to work with a legacy machine. They were created by Macro-Recording in Excel 2013 but they wouldn't run on our heavy machinery PC's out in our shop. Upgrading them to Office 2013 is currently not an option.

Here is the original Macro:

Sub Macro1()
ActiveSheet.Sort.SortFields.Clear
ActiveSheet.Sort.SortFields.Add Key:=Range( _
"G2:G13"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("26 GA SP & GV").Sort
.SetRange Range("D2:J13")
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub

Through some research and assistance, it was determined to re-write it to this:

Dim Ws As Worksheet
Set Ws = Worksheets("26 GA SP & GV")
Application.ScreenUpdating = False
Ws.Range("D2:J13").Sort Key1:=Ws.Range("G2"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
Application.ScreenUpdating = True

So, all of the Macro's on the first weeksheet called 26 GA SP & GV work just fine in Excel 2003. However, there are 3 more worksheets and simply using this format for them isn't working. The kicker: all of the remaining macros are all stored in one module. The ones for the first sheet had individual modules. So I am thinking this is where the problem lies but sure how to fix it. If I try to run these re-written Macros for the other worksheets, I get this error:

RUN TIME ERROR 1004 - SORT METHOD OF RANGE CLASS FAILED.

I'm thinking it might have something to do with them all being in one module but not sure. Any suggestions?

Thanks...

The way your new Macro is written, it looks like it's only meant to work on one worksheet.

Can you loop through the worksheets and run the Macro on each one?

Well, I've changed the Worksheet name on the other sheets to this:
Set Ws = Worksheets("26 GA SP & GV")
Set Ws = Worksheets("26 GA KY")
Set Ws = Worksheets("24 GA KY")

And the code always dies here:
(different ranges of course per macro)
Ws.Range("D2:J9").Sort Key1:=Ws.Range("G2"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal

I did pull one of the Macros out and put them in a module alone and still crashes.

I think I am "oh so close" on this but with my limited VBA knowledge, can't say.

So there's one Macro per sheet?

On sheet one, called 26 GA SP & GV, there are 17 Macro's, all stored in individual modules in VBA called Module 1- Module 17.

The second sheet is called 26 GA KY and it has 8 Macro's all stored under ONE Module called Module18

All of the Macro's on sheet 26 GA SP & GV work fine and I simply copy and pasted the code, just changing the ranges.

When it came to sheet 26 GA KY, I made sure it selected that sheet in the code and then changed the ranges for each Macro and that is when the errors come. I sure thought this would all work.

garak0410

@dafyre said in Rewriting VBA Macros from Excel 2013 to Excel 2003 - Works One One Sheet Only.:

@garak0410 said in Rewriting VBA Macros from Excel 2013 to Excel 2003 - Works One One Sheet Only.:

I've had the unenviable chore to re-write Macro's to work with a legacy machine. They were created by Macro-Recording in Excel 2013 but they wouldn't run on our heavy machinery PC's out in our shop. Upgrading them to Office 2013 is currently not an option.

Here is the original Macro:

Sub Macro1()
ActiveSheet.Sort.SortFields.Clear
ActiveSheet.Sort.SortFields.Add Key:=Range( _
"G2:G13"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("26 GA SP & GV").Sort
.SetRange Range("D2:J13")
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub

Through some research and assistance, it was determined to re-write it to this:

Dim Ws As Worksheet
Set Ws = Worksheets("26 GA SP & GV")
Application.ScreenUpdating = False
Ws.Range("D2:J13").Sort Key1:=Ws.Range("G2"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
Application.ScreenUpdating = True

So, all of the Macro's on the first weeksheet called 26 GA SP & GV work just fine in Excel 2003. However, there are 3 more worksheets and simply using this format for them isn't working. The kicker: all of the remaining macros are all stored in one module. The ones for the first sheet had individual modules. So I am thinking this is where the problem lies but sure how to fix it. If I try to run these re-written Macros for the other worksheets, I get this error:

RUN TIME ERROR 1004 - SORT METHOD OF RANGE CLASS FAILED.

I'm thinking it might have something to do with them all being in one module but not sure. Any suggestions?

Thanks...

The way your new Macro is written, it looks like it's only meant to work on one worksheet.

Can you loop through the worksheets and run the Macro on each one?

Well, I've changed the Worksheet name on the other sheets to this:
Set Ws = Worksheets("26 GA SP & GV")
Set Ws = Worksheets("26 GA KY")
Set Ws = Worksheets("24 GA KY")

And the code always dies here:
(different ranges of course per macro)
Ws.Range("D2:J9").Sort Key1:=Ws.Range("G2"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal

I did pull one of the Macros out and put them in a module alone and still crashes.

I think I am "oh so close" on this but with my limited VBA knowledge, can't say.

garak0410

I've had the unenviable chore to re-write Macro's to work with a legacy machine. They were created by Macro-Recording in Excel 2013 but they wouldn't run on our heavy machinery PC's out in our shop. Upgrading them to Office 2013 is currently not an option.

Here is the original Macro:

Sub Macro1()
ActiveSheet.Sort.SortFields.Clear
ActiveSheet.Sort.SortFields.Add Key:=Range( _
"G2:G13"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("26 GA SP & GV").Sort
.SetRange Range("D2:J13")
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub

Through some research and assistance, it was determined to re-write it to this:

Dim Ws As Worksheet
Set Ws = Worksheets("26 GA SP & GV")
Application.ScreenUpdating = False
Ws.Range("D2:J13").Sort Key1:=Ws.Range("G2"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
Application.ScreenUpdating = True

So, all of the Macro's on the first weeksheet called 26 GA SP & GV work just fine in Excel 2003. However, there are 3 more worksheets and simply using this format for them isn't working. The kicker: all of the remaining macros are all stored in one module. The ones for the first sheet had individual modules. So I am thinking this is where the problem lies but sure how to fix it. If I try to run these re-written Macros for the other worksheets, I get this error:

RUN TIME ERROR 1004 - SORT METHOD OF RANGE CLASS FAILED.

I'm thinking it might have something to do with them all being in one module but not sure. Any suggestions?

Thanks...

garak0410

@dashrender said in Production / Enterprise Level Printing With Multiple Sorter/Mailbox Trays:

So you have few enough users to make the number of trays useful, OK.

Yes and in fact, we need 12 output trays if we could.

The biggest inconvenience (and productivity killer) for management the time spent employees will spend sorting drawings if we have to settle for one tray.

garak0410

Here is our, now dead (RIP) 9040...we lived by that output tray.

garak0410

After a lot of searching today and two calls from vendors, it looks like meeting all of our requirements may be impossible.

We found several Lexmark printers that have stackable output bins but no 11x17. They both said there hasn't been much demand for what we had in our 9040.

garak0410

I'm in the midst of a difficult search. Our trusty HP 9040 with an 8 tray sorter/mailbox has died on us...

Upon searching, I can't seem to find anything close to this. HP makes a sorter but mainly for an option to have a stapler. I've checked Lexmark and they have some options but not sure about the quality and if we can assign trays per user like we can with the HP.

The craziest part, is my preferred vendors are dragging their feet on researching and quoting options for me. I am doing my own searches but I might not blame them. It has been difficult...

Our needs:

Enterprise/Production Level Printing
Trays: Letter, Legal, 11x17
The most output bins we can get these days.

Any suggestions?

garak0410

I have a Surface Book (i7, 512GB, 16GB RAM, Nvidia GPU) that has been "good enough" for me on mobile gaming and has played everything I've thrown at it. I have, though, given thought on selling it, while resale value is still high, for a good gaming laptop. Very tempted...