Josep Roca wrote:There is not need to modify anything. Just add #define _WIN32_WINNT &h0602 before #include "windows.bi".

(smacks forehead) bingo! thanks for that @Josep Roca - i feel like i am starting to get a handle on using third party and ms libraries now!

i have been working on a project processing date time records from a system and I needed time zone information to aid processing this data. the information i needed to access include the current time zone name (in my case, AUS Eastern Standard Time or AEST) and whether or not i am currently in dayli...

marcov wrote:.... you need to get some excel reading library (readxl, libxl) and use that. (though C++ ones will be hard).

i am not sure where to start with readxl - have you used it yourself ? has anyone converted the headers ?

using fbfrog https://github.com/dkl/fbfrog I translated the libxl header and posted some examples here https://www.freebasic.net/forum/viewtopic.php?p=233695#p233695 that's the thread i first looked at and why i dug in to look at libxl! nice work on the header conversion - i have been using the bi ...

this is a work in progress and is just a few snippets really to just read out some cell values...the main code sample i used was from the libxl website & some ideas off stackflow. #include "libxl.bi" #inclib "xl" Declare Function xlwrite () As long Declare Function xlread () ...

Interesting thread, but a bit confused. I wish there was a simple example showing how to get raw data from active sheet, RxCx:RyCy. i have a bit of working code now using the libxl library - nice library, a bit of work though having to figure out utilisation of the library as there are only a few e...

I have a need to read MS Excel Files, convert them to CSV files and transfer the data into a postgres database. i want to use freebasic so i am looking for some libaries and/or third party tools to read the excel file content, or convert the excel files to csv format. My target OS's are windows (7,8...

@fxm, thanks for picking that up! The last point in the ReDim notes talks about the use of Redim (resizing) with a complex expression, yet there is no example of resizing using a complex expression. The current examples use fixed values for the ReDim examples, therefore i thought an additional examp...

getting my head around dim redim and redim preserve i thought an additonal example for the FBWiki : KeyPgRedim page may be useful. here's my example and example output: 'Example of using ReDim to resize a variable-length array Type FileSpecs FilenameOnly as string FilePathOnly as string FileSize as ...

@fxm - thats great. I am also wondering if you can add a clarification to the Dir() Description. It wasnt clear to me that Dir needs to be invoked multiple times to get a list of files in a dir (i now get it). Could some additional explanatory text be added at the start of the Description for Dir() ...

could you sign me up too please:
userid: andykmv
MD5: [...]

guys, thanks for the replies. i am not exactly sure what the error i got first time was when i tried the Dir example, as i did not grab a screenshot at the time - i might have to start fresh and see if i can replicate it. i reviewed some other code and added the parenthesis, but was consistently get...

hope this is the right place to report an error in the FB chm Dir page and wiki https://www.freebasic.net/wiki/wikka.php?wakka=KeyPgDir Edit: turns out it was me not the example! when i was looking at the Dir command first code example (both the frebasic 1050 chm and fbwiki) i noticed that the calls...

How to dlltool 32/64-bit XXX is the PATH to your FreeBASIC folder 32-bit: "XXX\bin\win32\dlltool.exe" -d pq.def -l XXX\lib\win32\libpq.dll.a 64-bit: "XXX\bin\win64\dlltool.exe" -m i386:x86-64 --as-flags --64 -d pq.def -l XXX\lib\win64\libpq.dll.a Joshy @D.J.Peters, many thanks f...

If you want to know details about a filetype, a good start is running the *nix/mingw command "file" on them. My bet is that the msvc libs show "omf" as filetype, while the mingw derived (*.a) files are (pe)coff. thanks for that! as mingw did not have a file.exe equivalent I trie...