osx - How can I open external websites in Excel 2011 for Mac? -

-

in excel 2010 it's easy me make macro opens website, selects data website, , pastes workbook.

i've searched everywhere figure out how can on mac running excel 2011, i'm guessing since reintroducing vba mac version of office may not have capabilities (yet).

can me figure out how if possible?

look querytables answer in how can send http post request server excel using vba?

that's working on both windows , mac.


Comments

Post a Comment

Popular posts from this blog

android - Cannot use ndk-build on Cygwin -

-
i have use ndk clien't project. using windows 7. i followed installation instructions. have installed cygwin 1.7.1. in cygwin bash, go android ndk root directory. when see contents of directory, usin $dir command, can see contents including ndk-build, when try use ndk-build, result get: $ndk-build bash: ndk-build: command not found. not sure doing wrong. cygwin emulates gnu/linux environment on windows computer. means you're working "shell" not same windows command-line. if type asdf.exe in windows command-line, tries find asdf.exe in current directory. if can find it, file executed. if can't find it, it'll go through every directory of %path% , try again. however, if type asdf in bash (there multiple kind of shells, bourne again shell 1 of them), not after in current directory. instead it'll try find in 1 of path directories. can't give sources here, afaik it's security reasons. if want run file not in path , must p...
Read more

sql server - python to mssql encoding problem -

-
Image
greetings by using pymssql library, want write data mssql database encounter encoding issues. here sample code write db: # -*- coding: utf-8 -*- import _mssql .... connection info data here .... def mssql_connect(): return _mssql.connect(server=host, user=username, password=pass, database=db, charset="utf-8") con = mssql_connect() insert_ex_sql = "insert mydatabsae (id, programname, programdetail) values (1, 'test characters ÜŞiçÇÖö', 'löşüiiğĞü');" con.execute_non_query(insert_ex_sql) con.close() sadly data written db corrupted: the collacation of mssql db is: turkish_ci_as how can solved? here possible solution : the key insert_ex_sq.encode('your language encoder') . try instead: con.execute_non_query(insert_ex_sq.encode('your language encoder'))
Read more

c# - BasicHttpBinding equivalent CustomBinding using WCF Client and PHP WebService -

-
i running visual studio 2008 unit test c# webservice php using wcf , received following error: system.servicemodel.security.messagesecurityexception: http request unauthorized client authentication scheme 'anonymous'. authentication header received server 'ntlm,basic realm="(null)"'. ---> system.net.webexception: remote server returned error: (401) unauthorized.. i using windows xp sp3 machine, unit test vs 2008 , wcf connect php webservice. i have no control php webservice. cannot modify (neither configuration security). here config file client use webservice php: <system.servicemodel> <extensions> <bindingelementextensions> <add name="customtextmessageencoding" type="company.integracioneasyvista.customtextencoder.customtextmessageencodingelement,company.integracioneasyvista.customtextencoder, version=1.0.0.0, culture=neutral, publickeytoken=9744987c0853...
Read more