Recent Posts

626

General Software Discussion / Re: Merge or combine worksheets from the same excel workbook

« Last post by Contro on February 09, 2020, 11:32 AM »

Perhaps it is an idea to export everything into CSV files, combine these text-based CSV files into one and then import the result back into Excel again?

Still, that requires the content of each sheet to be the same as the others.

Exporting everything to CSV should be easy enough with Excel itself. You could use join software for combining these CSV files. Once done with that, you can then use the CSV import functionality from Excel itself to get one worksheet with all the data in a new Excel file with an appropriate name.

Unless there is a need to keep formulas etc. exporting to the simplest data format, using one of many free join software programs to create one big file and then importing this file onto a new Excel file, seems the best way of tackling Contro's problem. To me, at least.

-Shades (February 08, 2020, 06:38 PM)

Shades I was thinking in an ahk script.
I am doing manually.

If you export to csv you have a txt plain text.

I finally make work the rdbmerge utility to see that change everything.

It's clear that excel is a "big" program. But perhaps one that have traumatized me in the past like Autocad, microsoft word and some technical software. And of course windows xp pro traumatized me a lot.

I am applying manually from each worksheet the usual or standard copy/paste excel have with no problem.
So perhaps a little script with autohotkey may be useful for me.
I am thinking visit the code snack section.....

 

627

General Software Discussion / Frozen window in windows explorer

« Last post by Contro on February 08, 2020, 04:41 PM »

Windows 10 home 64
I don't know exactly how I arrive the situation.
I can't move that window
I can't click anywhere in that window
Obviously i can't close, minimize or maximize that window.

You can open other windows folder and goes well, but that ones you can do nothing
Through the task administrator if you close the folder don't obey, we need reiniate the windows explorer to make that problematic window dissappear.

 
What mistery is this  ?

 

628

General Software Discussion / Re: Merge or combine worksheets from the same excel workbook

« Last post by Contro on February 08, 2020, 02:11 PM »

What I simply need is an utility able to combine the worksheets from a single workbook into a new one by the the method of copy/paste.
Not considering structures or data, only copying from one worksheet to the combined one by order....

 

629

General Software Discussion / Re: Merge or combine worksheets from the same excel workbook

« Last post by Contro on February 08, 2020, 01:32 PM »

1 google search gave me enough information to find this makeuseof page (select Not Now in the red page-blocker when using a decent browser with an ad-blocker), providing not 1, but 3 step-by-step procedures to accomplish what you ask. With the standard product, so no utilities needed, only a rather simple skill: google

As you forgot to mention what Excel version you are using, I assume you have a decently modern version that has a ribbon (Excel 2007 or newer).

-Ath (February 08, 2020, 11:30 AM)

The link don't do what I ask.
Use the copy/move option that is not enough to merge sheets in one sheet.

I use a online utility Free Online xls merger that works fine to merge xls files in one file converting every  workbook in a worksheet in my example (just because each workbook only have one worksheet). So I obtain a single xls with a 13 sheets.

The difficult point is get a new workbook with only one worksheet obtained from the previous 13 worksheets.
And in this point the native excel utility is not enough.

 

Note : this is the merger online to group several xls files in one single xls with worksheets created from the original workbooks : https://products.gro...pdocs.app/merger/xls

630

General Software Discussion / Re: Merge or combine worksheets from the same excel workbook

« Last post by Contro on February 08, 2020, 01:10 PM »

1 google search gave me enough information to find this makeuseof page (select Not Now in the red page-blocker when using a decent browser with an ad-blocker), providing not 1, but 3 step-by-step procedures to accomplish what you ask. With the standard product, so no utilities needed, only a rather simple skill: google

As you forgot to mention what Excel version you are using, I assume you have a decently modern version that has a ribbon (Excel 2007 or newer).

-Ath (February 08, 2020, 11:30 AM)

Oh. I was investigating and put the results above.
I will try your link.
Best regards Ath
The version is excel 2010

631

General Software Discussion / Merge or combine worksheets from the same excel workbook

« Last post by Contro on February 08, 2020, 10:09 AM »

I have 13 sheets in an excel workbook. Format xls.
I want to join, merge or combine the 13 sheets in only one.
I have tried to select all but moving or copying give not the target.
How can I do that with a free utility ?
Best Regards
 

a worksheet merger utility from the same file or excel workbook.

Note : I have tried two utilities from vba code in commercial pages, but don't work. So I would the correct code with no problems.
Note : I am trying to find here : http://www.rondebrui...ns/sectionaddins.htm , seems not commercial.
 
Note : http://www.rondebrui.../addins/rdbmerge.htm
There are two versions depending of excel version .
 
 Note : I obtain automation error with the addon and occurr an exception.
then open excel 2010 again and nothing....

So I need a good addin for the occassion or use well the The Ron The Bruin addon

Note : To avoid confuse Ath or any other helper I am trying to determine the exact target to get :

Consolidate in Excel: Merge multiple sheets into one

Merge several excel files in one is done well with https://products.gro...pdocs.app/merger/xls

All my worksheets have the same configuration or formulas.

The target is :
Condensing Multiple Worksheets Into One (Microsoft Excel)

Note 08.02.2020.19.50 : trying this
https://excelribbon...._Worksheets_Into_One

Note : 08.02.2020.20.01 I tried. No good result. So probably the xls files components and threrefore the worksheets have not the same structure.

I must do manually with the old method copy/paste.
Best Regards

632

General Software Discussion / Re: Webbrowser for a special ocassion (virtualbox - guest xp pro)

« Last post by Contro on February 07, 2020, 05:59 AM »

I have to run the virtual machine under windows xp pro because is installed there a program that don't works in upper windows operating system.

That old program is able to recognize bc3 standard files FIE/BDC standard for budgets in construction.
so I can drag from the browser the data and are recognized by the old program.

Then. If you assume that I need the old program running in an old operating system you will be able to help me.

The old operating system have an old browser . No enough security, problems with new webs, etc. etc.

The old browser accompany windows xp pro is IE 7.

so I need substitute for a better browser able to see correctly the pages with a decent level of security.

I suggest the link http://www.xpbrowsers.com/

I begin trying this and waiting for someone that in the past had my similar problem.

Best Regards
 


Edited : I think it's done.

I enter in the link http://www.xpbrowsers.com/ from the virtual machine. I tried google chrome, but have no support. I couldn't enter in the web.

I try Firefox. Seems a file I can decompress.
I download from windows 10 with firefox to my pc and put in a share folder to enter in the virtual machine.

I decompress there and copy the folder under c:\program files in the virtual machine.

I execute firefox.exe from inside that folder.

I create a shortcut in the desktop.

so seems a sort of portable version of firefox

http://ftp.mozilla.o.../releases/52.9.0esr/

    firefox-52.9.0esr.win32.sdk.zip

Seems to go well now. I can also enter my web.

Best Regards
 

633

General Software Discussion / Re: Webbrowser for a special ocassion (virtualbox - guest xp pro)

« Last post by Contro on February 06, 2020, 12:51 PM »

I am surprise because in one of my attempts I get the website.
sometimes.
Even happen with donationcoder.com

634

General Software Discussion / Webbrowser for a special ocassion (virtualbox - guest xp pro)

« Last post by Contro on February 06, 2020, 12:03 PM »

I have several old virtual machines running under windows xp pro + sp3 with IE 7
At the present moment i can't see many pages, including my own web page (a blogspot....) .

so I would like to solve my problem installing :

a) a portable browser inside the virtual machine.  Sharing a folder outside, in one of my data disks.
b) a system browser inside the virtual machine.

Note : The web browser I use everyday is Firefox.
But for the ocassion I don't need special or relevant features. Even those important ones like to share passwords, favourites, etc.

 



Note : I need simply good advice. I can risk in my own way http://www.xpbrowsers.com/ , but this is not the target.

If you know a good browser for the ocassion I will adopt.
Best Regards.
 

Note 2 : the hardware behind is not problem. it's my new laptop . hp pavilion 15-bc520ns, 

What is my target ? I have an old program to budgets that use a last price generator online. I need to see that webpage .

Note 3 : A good fear. I use the prntkey to take a screenshot and the virtual machine collapses.....

635

Living Room / Re: Connector SAS

« Last post by Contro on February 03, 2020, 03:30 PM »

I have bought two disks.

https://www.ebay.es/...mp;item=332878771430

https://www.amazon.e...00?ie=UTF8&psc=1

I try to reassure the disk is good for asus z170k , but they send me to crucial and asus. so I prefer apply the 4wd criteria under my total responsability.

Best Regards

Note : I hope no problems sending to canary islands.....
sometimes I pay and then they tell me they can't send to tenerife.....
 

636

General Software Discussion / Re: Alternatives 7stacks for w10home

« Last post by Contro on January 31, 2020, 06:33 AM »

Stacky promises the best . Experimenting :

Stacky is a small program for Windows that displays contents of a given directory as a list of clickable, labled icons.

 

P.D. I began to fight with the program with no need by my ignorance. Now I will try to follow the instructions.


First condition : use as a toolbar accomplish



Second condition drag to the task bar and insert. We can put in any place of the taskbar ----- acomplish

pending : change the icon to the shortcut created. See the content with icons instead of like you see in the image above.

P.D. For me the important thing is have the opportunity now of creating a new shortcut to a folder and put in the task bar. trying.

 

Edited 31.01.2020.12.57 :

Second stacky created :


I don't understand why but I can see one icon from iWriter.


What's pending now :

For me is enough if a I can launch the folders from an icon in the task bar. At the present moment is the same icon. The icon from the original program Stacky.



I suppose this is easy to change with an utility.

At the present moment when you maintain the mouse cursor over the icon the correct legend appear.

I try also with a bat, but I think is better with the program. With 7stacks i was using icon with the initial letter of the folder to see......


Do you know a freeware to change easily the icon to a exe file ?

By some reason some icons are recognised and others no .
See, by example, vlc player recognised, but screenshot captor no.

 




Stacky in my system is going well. Is fast and don't hang up. So I think i can configure the rest of elements.

For me is not easy to see how to change the icon .
Or even respect the original icon changing the color or overtype letters on it.

But I know from the past that this icon is changeable.

The best thing would be not to change the original executable icon, only in the shortcuts personalized by folder. Like 7stacks did.



I have finished the configuration.
I think is not possible to change the icon . Perhaps with a bat converted to exe.

637

General Software Discussion / Re: Alternatives 7stacks for w10home

« Last post by Contro on January 31, 2020, 06:19 AM »

The first one 4wd propose :


menuApp is flexible

Using menuApp you can display a menu from a shortcut...

...or via hotkeys.

...or by double-clicking on the desktop.

...or by clicking on the system tray icon.

I suppose if double clicking on the desktop then I can fix in the task bar that icon.

I gonna try now.
 

uFF. tOO difficult for me.

If very configurable and assumed all can be done. But the learning curve..... 

Note : I have problems with windows defender and the installer, so I disable the antivirus for installing.
 

638

General Software Discussion / Re: Alternatives 7stacks for w10home

« Last post by Contro on January 31, 2020, 04:17 AM »

I'll attach the download here so you can try it, it's rather old (2009, that's not a typo), but it's the latest available. Please run some AV across it before actually trying it, just to be sure.

-Ath (January 29, 2020, 12:56 PM)

Thanks Ath. Now I am sure I can download.
If not tomorrow I will surf from another station ....

Note : Is downloaded 

Note after installation : I am lost !

In the installation directory only a doc and a dll !.
How can I use it ?
I am more used to the icon in the desktop to launch the program. 

-Contro (January 29, 2020, 12:59 PM)

It's an extension of your taskbar.  Right click your taskbar and select toolbars, then there should be an entry- not sure if it will say truelaunchbar or not.  Show that bar, then right click on it to get to the options.  For more than that, go to the TLB site.

-wraith808 (January 29, 2020, 11:41 PM)

Running to try, but I think is not the same that 7stacks.....

 

Note : change the taskbar and introduces another "filosophy" to study :

639

General Software Discussion / Re: Alternatives 7stacks for w10home

« Last post by Contro on January 31, 2020, 04:15 AM »

From AlternativeTo:

MenuApp
Stacky

-4wd (January 29, 2020, 05:34 PM)

Yeap, thanks. It's an alternative.

Experimenting ..

What I need is a substitute for 7stacks.

7stacks have this philosophy or working principles :

Works like a windows toolbar in the task bar. Really open a folder and let us see the content : icons to launch programs, other folders includes, any file....

Additionally you select an icon to represent the toolbar or selected folder.

Additionally you can insert the icon whenever you need.

So :
A windows toolbar open a folder and we are able to launch any option inside.

7stacks assign an icon to the toolbar you can insert in any place in the task bar. Changes the way a basic windows toolbar shows the option. With 7stacks you see the icons assigned to the program or file to be launch or open.

 

640

Living Room / Re: Connector SAS

« Last post by Contro on January 29, 2020, 05:25 PM »

If both the connector and drive support PCIe mode, (and correct key), then there shouldn't be a problem, I have a Crucial P1 500GB in my machine.

Be aware of the limited Write Endurance if you plan on shifting large amounts of data:

1TB drive: 200TB Total Bytes Written (TBW), approximately 109GB per day for 5 years

It's also Quad-Level Cell which means it's slower than TLC, (especially for large writes), and may wear out a bit faster, (hence the low TBW value), but is reasonably cheap.

-4wd (January 29, 2020, 05:07 PM)

Nice indeed. I will keep this information .
 

641

General Software Discussion / Re: Alternatives 7stacks for w10home

« Last post by Contro on January 29, 2020, 12:59 PM »

I'll attach the download here so you can try it, it's rather old (2009, that's not a typo), but it's the latest available. Please run some AV across it before actually trying it, just to be sure.

-Ath (January 29, 2020, 12:56 PM)

Thanks Ath. Now I am sure I can download.
If not tomorrow I will surf from another station ....

Note : Is downloaded 

Note after installation : I am lost !

In the installation directory only a doc and a dll !.
How can I use it ?
I am more used to the icon in the desktop to launch the program. 

642

Living Room / Re: Connector SAS

« Last post by Contro on January 29, 2020, 11:58 AM »

On the other hand, SATA drives can be connected to SAS controllers with a cheap cable adaptor.

But anyway that motherboard doesn't have a SAS controller or ports.

https://www.asus.com...70-K/specifications/

So just get boring old SATA drives to keep it simple.

-4wd (January 29, 2020, 02:28 AM)

Good to know.

Then I can't have it.

Best Regards.

Additional comment :

1 x M.2 Socket 3, , with M key, type 2242/2260/2280 storage devices support (both SATA & PCIE mode)

Can I connect a Crucial P1 CT1000P1SSD8 - Disco Duro sólido Interno SSD de 1 TB (3D NAND, NVMe, PCIe, M.2)   ?

 

643

Living Room / Re: Connector SAS

« Last post by Contro on January 29, 2020, 11:55 AM »

Though SAS and SATA connections are quite alike, they aren't interchangeable. SAS drives are mostly used in servers and are usually much too expensive to be used in desktop systems.

OTOH, if you already own a SAS drive you can buy a PCI interface for your desktop system to connect that drive. Speed is usually similar to SATA, when used in a desktop system.

-Ath (January 29, 2020, 01:04 AM)

SCSI and SAS are expensive, but in ebay and others offers cheaper than sata 3 drives........
A SAS 6 TB drive for the same price of a SATA 3 one.... 

644

Living Room / Connector SAS

« Last post by Contro on January 28, 2020, 05:09 PM »

I am willing to buy another hard drive disk.

One is a NVMe m.2 ssd of 1 TB and the other a mechanical HDD up from 6 TB.

I have a motherboard Asus Z-170K .
I don't know if have SAS connector.
I assume that the conector are SATA type. SATA3

Do you know if I can connect a SAS hard drive ?

Best Regards

645

General Software Discussion / Re: Alternatives 7stacks for w10home

« Last post by Contro on January 28, 2020, 05:04 PM »

The advantage of TrueLaunchBar (shareware) is that the menu pops out on mouse-hover, where the Windows toolbars need a mouse-click to open.

-Ath (January 27, 2020, 01:23 AM)

There are other advantages to TrueLaunchBar other than that, but yes, you could just use the windows feature.  If free is what you're looking for, they offer an older version of TrueLaunchBar as FreeLaunchBar for (predictably) Free!  http://forum.tordex.com/thread-3321.html

-wraith808 (January 27, 2020, 01:30 PM)

Running to try this is there is a download link with no problems with my filters.
 

edited : I am not that lucky man.....

646

General Software Discussion / Re: Alternatives 7stacks for w10home

« Last post by Contro on January 28, 2020, 05:03 PM »

I use Bins - http://www.1upindustries.com/Bins/

-c.gingerich (January 27, 2020, 01:28 PM)

It's a 14 days trial.
Don't use folders, only icons to be dropped.
May serve but I prefer a freeware and folder oriented like 7stacks.
 

647

General Software Discussion / Re: Alternatives 7stacks for w10home

« Last post by Contro on January 28, 2020, 04:55 PM »

I use True Launch Bar (http://www.truelaunchbar.com/).  It can just be a quick list, or can take the lists from folders (which mine does)

-wraith808 (January 26, 2020, 03:15 PM)

I have problems where I connect with the filter. Down sites. I will persist when I can.
 

648

General Software Discussion / Re: Alternatives 7stacks for w10home

« Last post by Contro on January 28, 2020, 04:54 PM »

What about the standard Win10 toolbars?
Right-click on the taskbar, open Toolbars and select Desktop (like I did), or add a new toolbar, pointing to a folder where you create links to your files/applications as desired. Multiple toolbars can be defined.

[ Invalid Attachment ]

Example of my (partial) Desktop toolbar:

[ Invalid Attachment ]

The advantage of TrueLaunchBar (shareware) is that the menu pops out on mouse-hover, where the Windows toolbars need a mouse-click to open.

-Ath (January 27, 2020, 01:23 AM)

I am using toolbars . At the present moment IrA is the name. In the past I used three toolbars. 7stacks put the jump list in the place you select. The toolbar goes at the sides.

649

General Software Discussion / Re: Alternatives 7stacks for w10home

« Last post by Contro on January 26, 2020, 03:33 PM »

I use True Launch Bar (http://www.truelaunchbar.com/).  It can just be a quick list, or can take the lists from folders (which mine does)

-wraith808 (January 26, 2020, 03:15 PM)

Running to try wraith808
Best Regards

650

General Software Discussion / Re: Import/Export (backup/restore) wifis from one laptop to another

« Last post by Contro on January 26, 2020, 03:30 PM »

https://www.raymond.cc/blog/import-and-export-your-wifi-keys-with-wirelesskeyview/

First result in Google.

-Shades (January 26, 2020, 01:41 PM)

Thanks Shades.
I prefer your advice.