Improve company productivity with a Business Account.Sign Up

x

Google

824

Solutions

1K

Contributors

Google is an American multinational technology company specializing in Internet-related services and products that include online advertising technologies, search, cloud computing, software, and hardware.

Share tech news, updates, or what's on your mind.

Sign up to Post

Question
How do I set the address of a Hyperlink variable?

Code
Dim strUrl As String
Dim hyper_Url As Hyperlink

'Start URL
strUrl = "https://www.google.com/maps/dir/

hyper_Url.Address = strUrl   '<------ this line errors out

What I'm trying to do
Build a URL for Google Maps direction.

The Whys
I can load the URL as a string in a browser, but when I try to send it in an email the email recognizes the first part of the URL and not the addresses I add.  So the user clicks on the URL in the email and doesn't get the map.  My thought is that if I had a Hyperlink variable to the email, it will work.

Thanks in advance for any help.
LJG
0
Worried about phishing attacks?
LVL 1
Worried about phishing attacks?

90% of attacks start with a phish. It’s critical that IT admins and MSSPs have the right security in place to protect their end users from these phishing attacks. Check out our latest feature brief for tips and tricks to keep your employees off a hackers line!

Hi,
 
 In a service industry environment where it is legal office with several lawyers or plumbing company with several service technicians,  I noticed that some use online calendar such as Google Calendar or Apple iClould Calendar and wanted to sync with their Outlook software.
 I like to know why people use Google Calendar or Apple iClould Calendar instead of using Outlook Calendar if they already have Outlook?
 What does Google Calendar or Apple iCloud Calendar provide that Outlook Calendar does not provide?

Thanks.
0
I have written VBA code that reads a very complex email from MS Outlook, interprets it to extract over a dozen fields. The code then displays the info on a form giving me the opportunity to check and edit before I press the Go button. The Go button searches for the Key field in an Excel spreadsheet and updates it, or if it can't find it, adds the record to the sheet.

I am then using the Excel spreadsheet as a data source for an Appsheet form that is updated on mobile devices in the field. Unfortunately Excel is proving very unstable so I should use a Google Sheet instead which will make it very robust.

My problem is that, although I am very confident with VBA, I have zero knowledge of any code that will enable me to manipulate Google Sheets. Is there a way to manipulate Google Sheets with VBA, or is there any other solution that anyone could suggest?
0
When I try to visit a site  that has a video I get the following error:

www.youtube-nocookie.com sent an invalid response

I don't know how to fix this. I'm using Win 10 and Google as my search engine.
0
Hello Experts,

I'm sure this is a simple question, but I can't figure it out.  I have a spreadsheet in Google Sheets.  It basically keeps a running total of payments and deposits.  I got the formula working as needed, but when I copy the formula in the balance column, the column displays "FALSE" if there is nothing in the payment or deposit columns.  I would like the balance column to be blank if there is nothing in the payment or deposit columns.  I think the formula will have to have an "ISBLANK" IF statement, but I just can't seem to get this to work.  Below is the formula I have and an image of the issue.'

Thanks,
Nick

Formula:  =if(sum(F7:G7)>0,(-F7+G7)+H6,(if(sum(F7:G7)="0",0)))

Check-Register---Google-Sheets.png
0
I'm on Android and my Gmail for one particular email won't give me push notifications on my phone like my other ones do. I've duplicated the notification settings my other emails have, yet I still get no notifications for that one particular email.
0
windows10 laptop

google earth latest edition

only open gl works

I uninstall
safe mode,
restore default settings
delete my places
turn off atmosphere

even though I uninstall/re install

direct x will not work.
start google earth many times
0
Good afternoon

Has anyone using google drive to backup the file server ? I have sign up for the g suite for different tenant and I want to backup our file server onto the google drive.

Many thanks
0
I keep running into a very annoying problem with Google Chrome. Every week or two it seems the cache gets corrupted and when I go to view sites they display with no styles applied. My work around is to clear cached images. I'm looking for a more permanent fix, so I don't have to keep working around it. I haven't found anything useful on Google's forums.

I have tried manually removing the cache files in AppData\Local\Google\Chrome\User Data\Default\Cache thinking there may be something corrupted in them, but the problem still recurs.

Chrome is up to date. Version 65.0.3325.181 (Official Build) (64-bit)

Has anyone figured out how to stop this annoying bug?
0
My Google box looks good until you type something in to do a search then the letters are too close to the bottom overlaying the bottom border of the box.  Is there a way to widen the box so this doesn't happen.  Please see attached image.  The website is http://insurance.illinois.gov
GoogleBoxError2.jpg
0
Get 10% Off Your First Squarespace Website
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Google Search Box is not displaying correctly.  Please see attached image. There is a box inside a box, inside a box...why is it doing this?  I though it might be the divs, but that proved incorrect.  Any idea why it's displaying this way?  I had it in an include.  Think that was the issue I moved it, but got the same results.

http://insurance.illinois.gov/defaultNew.html
GoogleBox.jpg
0
I'm pretty advanced when it comes to Outlook, but I can't seem to get my head around how to achieve this particular task.

The Scenario

- In Outlook, I have a standard PST File containing multiple POP3 email addresses.

- I also have an IMAP connection with Gmail saved in an OST File.  

When I look at my default data file (Outlook.PST) the Calendar shows both my own Calendar entries, as well as those set in my Gmail Calendar. Same goes for when I look at the calendar while looking at my Gmail IMAP account.

The Problem!

The Calendar is obviously syncronizing with IMAP's entries because the GMAIL calendar entries are there, however, the times are all wrong!

What should be a 9:00 am (as confirmed when I look at my Google calendar in Gmail), appears as 7:00 am in my Outlook Calendar. It's the same entry and on the correct date, it's just that the time is wrong. Appointments in my Gmail calendar are often set by a contact in the USA.

I've confirmed the time and zone is set correctly to my location in Gmail, but can't seem to nut out how to get the times to appear correctly in my Gmail Calendar (See Below)

Gmail Calendar
I've googled this problem to death and there are too many conflicting answers.

Some suggestions say you need an app. Some say it can be done but don't explain how its done adequately.

Some say you need a second calendar in Outlook.

Others say you should just use Google's Calendar and not bother, but I …
1
I have an Access 97 database with Customers. I wish to parse the address field into a URL that can be opened with Google Maps.
Has anyone done this before so I do not have to re-invent the wheel?
I see there are certain parameters to use in order for the URL to work properly.
I have the addresses stored in SQL tables.

Address1
Address2
Province/State
City
Zip/Postal Code
Country

Any suggestions please?
Thanks!
0
I would like to set up a secure email account and wonder if you can point me in the right direction?  When I search Google for secure email I get a long list of results, none of which do I know I can trust.

I'm currently using Gmail.

Any ideas?
0
Hi  -

I’m trying to link outlook 2010 to my Google account. Once I go through all the setup steps, outlook keeps asking for a password. I know it’s do to 2 factor authentication because I do not have 2 factor set up on Google. What else could be causing this issue?
0
Why would Google be crawling the wp-include folder? I've attached the crawl errors. Maybe I should be using robots.txt to exclude the folder? Thanks.
blog-magickitchen-com_20180330T1638.xlsx
0
I have just helped a customer moving their webshop from HTTP to HTTPS.
Unfortunalely Google keeps claiming, that this site is not safe!
I can confirm that it is in fact HTTPS.
The address is: https://cotonshoppen.dk
can anyone tell me what the problem is?
0
Links to local files do not work in webbrowser

I'have a problem, I have made a intranet for a client. With links to local files as  *doc, *pdf & jpg.
I have make a link:  <a href="file:///G:/Maintenance/Schade/2018/example.jpg" target="_blank">photo</a>
But the link doesn't work. It seems that firefox and google chrome does not allow this. Does anyone know a solution?

thanks in advance
0
I have a google mail account for a domain name that I am paying $5 a month.

Email is not working so I need to send google a message.

How can I reach google
0
Improved Protection from Phishing Attacks
LVL 1
Improved Protection from Phishing Attacks

WatchGuard DNSWatch reduces malware infections by detecting and blocking malicious DNS requests, improving your ability to protect employees from phishing attacks. Learn more about our newest service included in Total Security Suite today!

One of my users receives Google calendar invites in UTC time zone in the subject line of the email invites he receives in Outlook.  I sent a test invite to myself from one of my Gmail accounts to my Outlook (same domain and time zone as this other user) and the subject line's event time is the same as the actual event time (correct time and time zone).  When I sent the same invite to this other user, it shows up in the subject line in UTC time zone (test event was scheduled for 1 pm to 1:30 pm Central and shows up labeled as 6 pm to 6:30 pm (UTC) )  When accepted, the event goes into his Outlook calendar with the correct time.  What do I need to change to get these invites to show up correctly in the subject header?  This is a higher up in my company and he receives all of his invites for his charity he runs via Google calendar invites.
0
Hi I am using latest version of Mozilla firefox. I love this browser but I have noticed recently it started taking high CPU usage for no apparent reason.
I tried opening in safe mode but still same issue.

When I open firefox with only 1 tab which is google. Task manager shows 6 instances of Firefox running consuming CPU and memory each instance. I tried disabling all add ons but still same issue.

I am on Firefox Quantum 59.0.2 ( 64 bit ) and its upto date. I am running windows 10 64 bit OS with 16 GB Ram and SSD.

Anyone know how to fix it ?
0
One of my clients is moving over to Goole Suite.

A couple of the staff use Macs. Is it possible for them to sync their calendars and contacts with Google Suite using Outlook for Mac 2016 as the front end?

For Windows Outlook Google have a syncing tool. Is there a Mac equivalent or if not what is the workaround?

Many thanks.
0
I'm trying to get Blazor working and during the install procedure I ran into an error. Please see attached for a screenshot. Can anyone tell me how I can download Roslyn Language Services for Visual Studio 15? A google search returns nothing.
razor.PNG
0
past two weeks, users have complained of slow internet connection. Nothing was changed or added to network. I've checked the ISP service by using laptop directly to fiber/ethernet port and no issues. we get the error for all websites as attached. But if users wait at-least a minute, the site will load. switches have spanning tree enabled and have not found any loops. any suggestions? I've installed Wireshark and notice quite a bit of broadcast, but from what I've read from google, sounds like broadcasts are normal. any suggestions would be greatly appreciated.
connection-error.docx
0
One thing I've never been able to fully grasp and get my head around in Window 10 is how to add custom Icons to Windows 10 and where the best places are to find Icons.

For example, if I find some icons that I like, how do I add them to be available in the "%SystemRoot%\system32\imageres.dll" file?

I've read many articles found using Google on this topic, but none of them explained the process very well in my opinion and just left me confused. So my questions are;

  1. How to add icons to Windows 10 "imageres.dll" file so that they are available to me when I want to select a different desktop Icon for a folder or whatever?
  2. Is it possible to have a folder with Icons in it that can then be browsed and selected when using the Properties > Change Icon option on folders or Program Icons? If so, what size do these icons have to be in order to be used?
  3. What are some of the best sites to find Windows 10 compatible Icons? Free preferred, but good Paid sites are not out of the question for me.

I ask you please provide detailed explanations to questions 1 and 2, rather than just links to external sites if possible. Answers from those who have personal experience in these matters would be great, as well as screenshots of steps included in your answers if possible.

I am skilled with Windows 10, but having trouble figuring out the best way to solve this particular requirement.

Any assistance would be appreciated.

Many thanks.

Andrew
0

Google

824

Solutions

1K

Contributors

Google is an American multinational technology company specializing in Internet-related services and products that include online advertising technologies, search, cloud computing, software, and hardware.