logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Export to XLS file format Issue
K8ZM
#1 Posted : Monday, July 4, 2022 1:13:45 PM(UTC)
bwilliams

Rank: Advanced Member

Groups: Registered
Posts: 410
Location: Mentor, OH

Thanks: 97 times
Was thanked: 123 time(s) in 113 post(s)
I have been exporting out of LOGic to multiple XLS files for some time and it works except I have always had to open the XLS file in Excel and save it as XLSX or Excel will not allow me to link/import it to another XLSX Workbook. Can LOGic be updated to have the option to export to XLSX ?? The ability to save to a later version Excel file format would save a ton of time.

If anyone has a better way to export data for linking to an Excel Workbook/Worksheet please share. I'm using Office 365 latest version.

73 de Brad, K8ZM
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
K8ZT
#2 Posted : Monday, July 4, 2022 4:25:17 PM(UTC)
aluscre

Rank: Advanced Member

Groups: Registered
Posts: 43
Location: Stow, OH

Thanks: 1 times
Was thanked: 7 time(s) in 7 post(s)
Brad

Dennis help me set up a command to export to an xls file

1. Tools
2. Advanced >> Database Commands
3. Type in "use log" then Enter
4. Paste this or an edited version of this line:
export to ("c:\export_"+ttoc(datetime(),1)+".xls") type xls for qso_date>={^2022-06-14} fields call,qso_date,time_on,rst_sent,rst_rcvd,mode,freq,band,state,dxcc,pwr,grid,userfields
5. Press Enter
6. You will find file in C:/ drive

I think you could change .xls to .xlsx (in the first instance only)
1 user thanked K8ZT for this useful post.
WN4AZY on 7/10/2022(UTC)
K8ZM
#3 Posted : Monday, July 4, 2022 9:42:42 PM(UTC)
bwilliams

Rank: Advanced Member

Groups: Registered
Posts: 410
Location: Mentor, OH

Thanks: 97 times
Was thanked: 123 time(s) in 113 post(s)
Hey neighbor !!

Thanks for sharing, I'll play around with it and report back.

Best 73's de Brad, K8ZM
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.024 seconds.