Hi!! I have 16,000+ zip codes that I would like to find the distance for. I did exactly as instructed and it worked well for a sample of 1,000. However, I was wondering if anyone is running into potential issues with API Key prices and using APIs with Excel? I talked to Google Cloud support and they said to never use APIs with Excel since it can run unwanted requests that might exceed the limit of the free requests one can use (apparently there is a limit on how many requests can be made in a month). @SyntaxByte is this an issue you've encountered or heard of? I'm surprised no one in the comments has really mentioned that using this API key can cost money or that its not recommended to use Excel. Looking for advice! Thank you
Hi, Found this very useful But I get this Run time error '438' at line, I guess HeaderRowRange has to be used by a fixed length now. Are you planning to change your code ?. 'For Each c In ActiveSheet.ListObject(1).HeaderRowRange.Cells'
Thank you for posting this. I was trying to add some padding to some preselected rows which aren't all the same height. For some reason Set x = Row.RowHeight kept throwing an error, but this worked: Set myrows = selection For Each Row In myrows.Rows x = Row.RowHeight myrows.RowHeight = x + 5 Next Row Thanks again.
I used to hate it until they hired me as a Java expert. The thing is, I wouldn't use it for my personal projects; I prefer Python, JavaScript, or even C.
too much drinking, geez. when i do trainings at work i don't sniffle or drink 1000x. And it was giving you 1.7 miles as straight line distance which is totally useless unless you're flying a plane.
i created the api key and am doing the same thing in the video. copied his text and every thing and i get a #name? error for the result. anyone have any idea why?
Thank you so much! You not only explained the solution in a simple manner, you absolutely channeled the frustration I just went through before I came to search for a solution!
I'm working on a script that may or may not already have a modifier existing on an object. How do I get the ID or Name of the modifier I just added? If I run "bpy.context.object.modifiers['ARRAY']" I'll get the modifier named "ARRAY" but that may not be the one I want to edit. The new modifier may be called "Array.001" or "Array.002"... etc
Very good explain bro. How I can click/touch for a point on one 3D model to make an action? I wan't to create my business card with a game console and when I click on on button of the controller put information on the screen, giving different action on each button on the 3D model.
I tried this method but still when I run neofetch it still says that my device is using the i915 driver for the integrated intel gpu instead of my amd gpu. Any way to fix this? Thx.
Hi there, I am following your steps and it does not work. It simply sees the name, surname, contact, email just as one header then imports all the data under the name in contacts, and then another row named "Field 2 and Field 3 ". Not sure how to fix it please can you give me tip on what I should do to fix this thanks.
If you fields don't show up on the left hand side when you go to map, something is probably wrong with the way your CSV is setup. I would try opening the file in excel and making sure everything is setup correctly and saving it again. If you do see all those fields on the left hand side, it sounds like something went wrong with the mapping. In that case, map sure you click "Clear map" before you map the fields to make sure any default mappings are removed.